一段代码-优快云博客

本文链接：https://blog.youkuaiyun.com/Yubu_/article/details/102908884

本文详细介绍了使用C#从数据库获取项目性质并据此生成合同文件的过程。代码中通过ADO.NET执行SQL查询，依据项目性质选择不同的合同生成方法，最终将生成的文件以MS Word格式下载。涉及的技术包括字符串操作、条件判断、数据库交互、文件流处理及HTTP响应。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 string contract_id = context.Request["contract_id"];
                    if (string.IsNullOrEmpty(contract_id))
                    {
                        context.Response.Write("请求参数错误,生成合同文件失败");
                        return;
                    }
                    MemoryStream stream;
                    //项目性质
                    string sql = "select project_property  from t_crm_business where contract_id=@contract_id";
                    object project_property = adoTask.ExecuteSqlScalar(sql, new SqlParameter("@contract_id", contract_id));
                    if (project_property != null && "自送样".Equals(project_property.ToString()))
                    {
                        stream = new BusinessService().CreateContractDocumentFile2(contract_id, Current_CompanyId);
                    }
                    else
                    {
                        stream = new BusinessService().CreateContractDocumentFile(contract_id, Current_CompanyId);
                    }

                    context.Response.Clear();
                    context.Response.ContentType = "application/octet-stream;charset=gb2321";
                    string filename = "合同" + Guid.NewGuid().ToString().Substring(0, 6);
                    context.Response.AppendHeader("Content-Disposition", "attachment;filename=" + filename + ".doc");
                    context.Response.ContentType = "application/msword";
                    context.Response.Charset = "utf-8";
                    context.Response.BinaryWrite(stream.ToArray());
                    context.Response.End();