/// <summary>
/// 更新销售计划
/// </summary>
/// <returns></returns>
public static bool Update(Hashtable ht,SellPlanModel sellPlanModel, SellPlanDetailModel sellPlanDetailModel, string strDetailAction, out string strMsg)
{
bool isSucc = false;//是否添加成功
strMsg = "";
if (IsUpdate(sellPlanModel.PlanNo))
{
TransactionManager tran = new TransactionManager();
tran.BeginTransaction();
try
{
UpdateOrder(sellPlanModel, tran);
#region 拓展属性
GetExtAttrCmd(sellPlanModel, ht, tran);
#endregion
//明细操作的类型
switch (strDetailAction)
{
case "1"://无操作
break;
case "2"://添加新明细
InsertOrderDetail(sellPlanDetailModel, tran);
break;
case "3"://更新明细
UpdateOrderDetail(sellPlanDetailModel, tran);
break;
case "4"://删除明细
DelOrderDetail(sellPlanDetailModel, tran);
break;
default:
break;
}
tran.Commit();
strMsg = "保存成功！";
isSucc = true;
}
catch (Exception ex)
{
tran.Rollback();
strMsg = "保存失败，请联系系统管理员！";
throw ex;
}
}
else
{
isSucc = false;
strMsg = "非制单状态的未提交审批、审批未通过或撤销审批计划不可修改！";
}
return isSucc;
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
//设置行为参数
string orderString = hiddExpOrder.Value.Trim();//排序
string order = "desc";//排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ModifiedDate";//要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_a"))
{
order = "asc";//排序：升序
}
int pageCount = int.Parse(hiddExpTotal.Value);//每页显示记录数
int pageIndex = 1;//当前页
int TotalCount = 0;//总记录数
string ord = orderBy + " " + order;//排序字段
DataTable dt = new DataTable();
string strPlanNo = hiddExpOrderNo.Value.Trim();
string strTitle = hiddExpTitle.Value.Trim();
string strPlanType = hiddExpFromType.Value.Trim();
string strBillStatus = hiddExpBillStatus.Value.Trim();
string strFlowStatus = hiddExpFlowStatus.Value.Trim();
string OfferNo = strPlanNo.Length == 0 ? null : strPlanNo;
string Title = strTitle.Length == 0 ? null : strTitle;
string PlanType = strPlanType.Length == 0 ? null : strPlanType;
string BillStatus = strBillStatus.Length == 0 ? null : strBillStatus;
int? FlowStatus = strFlowStatus.Length == 0 ? null : (int?)Convert.ToInt32(strFlowStatus);
string EFIndex = hidEFIndex.Value;
string EFDesc = hidEFDesc.Value;
SellPlanModel model = new SellPlanModel();
model.BillStatus = BillStatus;
model.PlanType = PlanType;
model.PlanNo = strPlanNo;
model.Title = Title;
dt = SellPlanBus.GetOrderList(EFIndex,EFDesc, model, FlowStatus, pageIndex, pageCount, ord, ref TotalCount);
//导出标题
string headerTitle = "计划编号|计划名称|计划类型|计划时期|最低计划额(元)|计划总金额(元)|单据状态|审批状态";
//string headerTitle = "建档日期|启用状态";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "PlanNo|Title|PlanTypeText|PlanDate|MinPlanTotal|PlanTotal|BillStatusText|FlowInstanceText";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "销售计划列表");
}
/// <summary>
/// 保存销售计划
/// </summary>
/// <returns></returns>
public static bool Save(Hashtable ht,SellPlanModel sellPlanModel, SellPlanDetailModel sellPlanDetailModel, out string strMsg)
{
bool isSucc = false;//是否添加成功
strMsg = "";
//判断计划编号是否存在
if (NoIsExist(sellPlanModel.PlanNo))
{
TransactionManager tran = new TransactionManager();
tran.BeginTransaction();
try
{
InsertOrder(sellPlanModel, tran);
#region 拓展属性
GetExtAttrCmd(sellPlanModel, ht, tran);
#endregion
if (sellPlanDetailModel.PlanNo != null)
{
InsertOrderDetail(sellPlanDetailModel, tran);
}
tran.Commit();
isSucc = true;
strMsg = "保存成功！";
}
catch (Exception ex)
{
tran.Rollback();
strMsg = "保存失败，请联系系统管理员！";
throw ex;
}
}
else
{
isSucc = false;
strMsg = "该编号已被使用，请输入未被使用的编号！";
}
return isSucc;
}
/// <summary>
/// 更新销售发货单
/// </summary>
/// <returns></returns>
public static bool Update(Hashtable ht,SellPlanModel sellPlanModel, SellPlanDetailModel sellPlanDetail, string strDetailAction, out string strMsg)
{
bool isSucc = false;//是否添加成功
//定义变量
string remark = string.Empty;
strMsg = "";
try
{
isSucc = SellPlanDBHelper.Update(ht,sellPlanModel, sellPlanDetail, strDetailAction, out strMsg);
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
catch (Exception ex)
{
//输出日志
SellLogCommon.WriteSystemLog(ex, LogInfo.LogType.SYSTEM, LogInfo.SystemLogKind.SYSTEM_ERROR, "2031001");
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
}
SellLogCommon.InsertLog(sellPlanModel.PlanNo, "2031001", "officedba.SellPlan", remark, ConstUtil.LOG_PROCESS_UPDATE);
return isSucc;
}
/// <summary>
/// 获取计划列表
/// </summary>
/// <param name="sellContractModel">sellContractModel表实体</param>
/// <param name="FlowStatus">审批状态</param>
/// <returns></returns>
public static DataTable GetOrderList(string EFIndex,string EFDesc,SellPlanModel sellPlanModel, int? FlowStatus, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
StringBuilder strSql = new StringBuilder();
int eid = 0;
eid = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID;
strSql.Append("select * from ( SELECT so.ID,so.PlanNo, so.Title, so.PlanTotal,case so.PlanType ");
strSql.Append(" when '1' then '月' when '3' then '年' when '2' then '季' ");
strSql.Append(" when '4' then '日' when '5' then '周' when '6' then '半年' ");
strSql.Append(" when '7' then '其他' end as PlanTypeText, ");
strSql.Append(" so.MinPlanTotal, so.ModifiedDate, ");
strSql.Append(" (CASE so.PlanType WHEN '1' THEN PlanYear + '年 ' + so.PlanTime + '月' WHEN '2' ");
strSql.Append(" THEN PlanYear + '年 ' + (CASE so.PlanTime WHEN '1' THEN '第一季度' WHEN '2' THEN ");
strSql.Append(" '第二季度' WHEN '3' THEN '第三季度' WHEN '4' THEN '第四季度' END) WHEN '3' THEN PlanYear + '年 ' ");
strSql.Append("WHEN '4' THEN PlanYear WHEN '5' THEN PlanYear +'年 ' +'第'+PlanTime+'周' WHEN '6' ");
strSql.Append(" THEN PlanYear + '年 ' + (CASE so.PlanTime WHEN '1' THEN '上半年' WHEN '2' THEN ");
strSql.Append(" '下半年' end) WHEN '7' THEN PlanYear + '年 ' END) AS PlanDate, ");
strSql.Append(" (SELECT TOP 1 FlowStatus ");
strSql.Append(" FROM officedba.FlowInstance ");
strSql.Append(" WHERE BillID = so.ID AND BillTypeFlag = 5 AND BillTypeCode = 8 ");
strSql.Append(" ORDER BY ModifiedDate DESC) AS FlowStatus, ");
strSql.Append(" CASE so.BillStatus WHEN 1 THEN '制单' WHEN 2 THEN '执行' WHEN 4 ");
strSql.Append(" THEN '手工结单' WHEN 5 THEN '自动结单' END AS BillStatusText, ");
strSql.Append(" CASE WHEN (SELECT TOP 1 FlowStatus ");
strSql.Append(" FROM officedba.FlowInstance ");
strSql.Append(" WHERE BillID = so.ID AND BillTypeFlag = 5 AND BillTypeCode = 8 ");
strSql.Append(" ORDER BY ModifiedDate DESC) IS NULL THEN '' WHEN ");
strSql.Append(" (SELECT TOP 1 FlowStatus ");
strSql.Append(" FROM officedba.FlowInstance ");
strSql.Append(" WHERE BillID = so.ID AND BillTypeFlag = 5 AND BillTypeCode = 8 ");
strSql.Append(" ORDER BY ModifiedDate DESC) = 1 THEN '待审批' WHEN ");
strSql.Append(" (SELECT TOP 1 FlowStatus ");
strSql.Append(" FROM officedba.FlowInstance ");
strSql.Append(" WHERE BillID = so.ID AND BillTypeFlag = 5 AND BillTypeCode = 8 ");
strSql.Append(" ORDER BY ModifiedDate DESC) = 2 THEN '审批中' WHEN ");
strSql.Append(" (SELECT TOP 1 FlowStatus ");
strSql.Append(" FROM officedba.FlowInstance ");
strSql.Append(" WHERE BillID = so.ID AND BillTypeFlag = 5 AND BillTypeCode = 8 ");
strSql.Append(" ORDER BY ModifiedDate DESC) = 3 THEN '审批通过' WHEN ");
strSql.Append(" (SELECT TOP 1 FlowStatus ");
strSql.Append(" FROM officedba.FlowInstance ");
strSql.Append(" WHERE BillID = so.ID AND BillTypeFlag = 5 AND BillTypeCode = 8 ");
strSql.Append(" ORDER BY ModifiedDate DESC) = 4 THEN '审批不通过' WHEN ");
strSql.Append(" (SELECT TOP 1 FlowStatus ");
strSql.Append(" FROM officedba.FlowInstance ");
strSql.Append(" WHERE BillID = so.ID AND BillTypeFlag = 5 AND BillTypeCode = 8 ");
strSql.Append(" ORDER BY ModifiedDate DESC) = 5 THEN '撤销审批' END AS FlowInstanceText ");
strSql.Append(" FROM officedba.SellPlan as so where 1=1 and so.CompanyCD=@CompanyCD ");
strSql.Append( " AND (CHARINDEX('," + eid + ",',','+so.CanViewUser+',')>0 OR so.CanViewUser='' or so.CanViewUser is null OR so.Creator=" + eid + ") ");
string strCompanyCD = string.Empty;//单位编号
strCompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
ArrayList arr = new ArrayList();
arr.Add(new SqlParameter("@CompanyCD", strCompanyCD));
if (sellPlanModel.BillStatus != null)
{
strSql.Append(" and so.BillStatus= @BillStatus");
arr.Add(new SqlParameter("@BillStatus", sellPlanModel.BillStatus));
}
if (sellPlanModel.PlanType != null)
{
strSql.Append(" and so.PlanType=@PlanType");
arr.Add(new SqlParameter("@PlanType", sellPlanModel.PlanType));
}
if (sellPlanModel.PlanNo != null)
{
strSql.Append(" and so.PlanNo like @PlanNo");
arr.Add(new SqlParameter("@PlanNo", "%" + sellPlanModel.PlanNo + "%"));
}
if (sellPlanModel.Title != null)
{
strSql.Append(" and so.Title like @Title");
arr.Add(new SqlParameter("@Title", "%" + sellPlanModel.Title + "%"));
}
if (!string.IsNullOrEmpty(EFIndex) && !string.IsNullOrEmpty(EFDesc))
{
strSql.AppendLine(" and so.ExtField" + EFIndex + " LIKE @EFDesc");
arr.Add(new SqlParameter("@EFDesc", "%" + EFDesc + "%"));
//comm.Parameters.Add(SqlHelper.GetParameterFromString("@EFDesc", "%" + EFDesc + "%"));
}
strSql.Append(" ) as f where 1=1 ");
if (FlowStatus != null)
{
if (FlowStatus != 0)
{
strSql.Append(" and f.FlowStatus=@FlowStatus");
arr.Add(new SqlParameter("@FlowStatus", FlowStatus));
}
else
{
strSql.Append(" and f.FlowStatus is null ");
}
}
return SqlHelper.CreateSqlByPageExcuteSqlArr(strSql.ToString(), pageIndex, pageCount, ord, arr, ref TotalCount);
}
/// <summary>
/// 为主表插入数据
/// </summary>
/// <param name="sellPlanModel"></param>
/// <param name="tran"></param>
private static void InsertOrder(SellPlanModel model, TransactionManager tran)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into officedba.SellPlan(");
strSql.Append("CompanyCD,PlanNo,Title,PlanType,PlanYear,PlanTime,PlanTotal,StartDate,EndDate,MinPlanTotal,Hortation,CanViewUser,CanViewUserName,Remark,BillStatus,Creator,CreateDate,ModifiedDate,ModifiedUserID)");
strSql.Append(" values (");
strSql.Append("@CompanyCD,@PlanNo,@Title,@PlanType,@PlanYear,@PlanTime,@PlanTotal,@StartDate,@EndDate,@MinPlanTotal,@Hortation,@CanViewUser,@CanViewUserName,@Remark,@BillStatus,@Creator,@CreateDate,@ModifiedDate,@ModifiedUserID)");
#region 参数
SqlParameter[] parameters = {
new SqlParameter("@CompanyCD", SqlDbType.VarChar,8),
new SqlParameter("@PlanNo", SqlDbType.VarChar,50),
new SqlParameter("@Title", SqlDbType.VarChar,100),
new SqlParameter("@PlanType", SqlDbType.Char,1),
new SqlParameter("@PlanYear", SqlDbType.VarChar,10),
new SqlParameter("@PlanTime", SqlDbType.VarChar,2),
new SqlParameter("@PlanTotal", SqlDbType.Decimal,13),
new SqlParameter("@StartDate", SqlDbType.DateTime),
new SqlParameter("@EndDate", SqlDbType.DateTime),
new SqlParameter("@MinPlanTotal", SqlDbType.Decimal,13),
new SqlParameter("@Hortation", SqlDbType.VarChar,1024),
new SqlParameter("@CanViewUser", SqlDbType.VarChar,2048),
new SqlParameter("@CanViewUserName", SqlDbType.VarChar,2048),
new SqlParameter("@Remark", SqlDbType.VarChar,1024),
new SqlParameter("@BillStatus", SqlDbType.Char,1),
new SqlParameter("@Creator", SqlDbType.Int,4),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@ModifiedDate", SqlDbType.DateTime),
new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50)};
parameters[0].Value = model.CompanyCD;
parameters[1].Value = model.PlanNo;
parameters[2].Value = model.Title;
parameters[3].Value = model.PlanType;
parameters[4].Value = model.PlanYear;
parameters[5].Value = model.PlanTime;
parameters[6].Value = model.PlanTotal;
parameters[7].Value = model.StartDate;
parameters[8].Value = model.EndDate;
parameters[9].Value = model.MinPlanTotal;
parameters[10].Value = model.Hortation;
parameters[11].Value = model.CanViewUser;
parameters[12].Value = model.CanViewUserName;
parameters[13].Value = model.Remark;
parameters[14].Value = "1";
parameters[15].Value = model.Creator;
parameters[16].Value = model.CreateDate;
parameters[17].Value = model.ModifiedDate;
parameters[18].Value = model.ModifiedUserID;
foreach (SqlParameter para in parameters)
{
if (para.Value == null)
{
para.Value = DBNull.Value;
}
}
#endregion
SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 跟新主表数据
/// </summary>
/// <param name="sellBackModel"></param>
/// <param name="tran"></param>
private static void UpdateOrder(SellPlanModel model, TransactionManager tran)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update officedba.SellPlan set ");
strSql.Append("Title=@Title,");
strSql.Append("PlanType=@PlanType,");
strSql.Append("PlanYear=@PlanYear,");
strSql.Append("PlanTime=@PlanTime,");
strSql.Append("PlanTotal=@PlanTotal,");
strSql.Append("StartDate=@StartDate,");
strSql.Append("EndDate=@EndDate,");
strSql.Append("MinPlanTotal=@MinPlanTotal,");
strSql.Append("Hortation=@Hortation,");
strSql.Append("CanViewUser=@CanViewUser,");
strSql.Append("CanViewUserName=@CanViewUserName,");
strSql.Append("Remark=@Remark,");
strSql.Append("ModifiedDate=@ModifiedDate,");
strSql.Append("ModifiedUserID=@ModifiedUserID");
strSql.Append(" where ID=@ID ");
#region 参数
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4),
new SqlParameter("@Title", SqlDbType.VarChar,100),
new SqlParameter("@PlanType", SqlDbType.Char,1),
new SqlParameter("@PlanYear", SqlDbType.VarChar,10),
new SqlParameter("@PlanTime", SqlDbType.VarChar,2),
new SqlParameter("@PlanTotal", SqlDbType.Decimal,13),
new SqlParameter("@StartDate", SqlDbType.DateTime),
new SqlParameter("@EndDate", SqlDbType.DateTime),
new SqlParameter("@MinPlanTotal", SqlDbType.Decimal,13),
new SqlParameter("@Hortation", SqlDbType.VarChar,1024),
new SqlParameter("@CanViewUser", SqlDbType.VarChar,2048),
new SqlParameter("@CanViewUserName", SqlDbType.VarChar,2048),
new SqlParameter("@Remark", SqlDbType.VarChar,1024),
new SqlParameter("@ModifiedDate", SqlDbType.DateTime),
new SqlParameter("@ModifiedUserID", SqlDbType.VarChar,50)};
parameters[0].Value = model.ID;
parameters[1].Value = model.Title;
parameters[2].Value = model.PlanType;
parameters[3].Value = model.PlanYear;
parameters[4].Value = model.PlanTime;
parameters[5].Value = model.PlanTotal;
parameters[6].Value = model.StartDate;
parameters[7].Value = model.EndDate;
parameters[8].Value = model.MinPlanTotal;
parameters[9].Value = model.Hortation;
parameters[10].Value = model.CanViewUser;
parameters[11].Value = model.CanViewUserName;
parameters[12].Value = model.Remark;
parameters[13].Value = model.ModifiedDate;
parameters[14].Value = model.ModifiedUserID;
foreach (SqlParameter para in parameters)
{
if (para.Value == null)
{
para.Value = DBNull.Value;
}
}
#endregion
SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 扩展属性保存操作
/// </summary>
/// <returns></returns>
private static void GetExtAttrCmd(SellPlanModel model, Hashtable htExtAttr, TransactionManager tran)
{
try
{
string strSql = string.Empty;
strSql = "UPDATE officedba.SellPlan set ";
SqlParameter[] parameters = new SqlParameter[htExtAttr.Count+2];
int i = 0;
foreach (DictionaryEntry de in htExtAttr)// de为一个Hashtable实例
{
strSql += de.Key.ToString().Trim() + "=@" + de.Key.ToString().Trim() + ",";
parameters[i] = SqlHelper.GetParameter("@" + de.Key.ToString().Trim(),de.Value.ToString().Trim());
i++;
}
int iLength = strSql.Length - 1;
strSql = strSql.Substring(0, iLength);
strSql += " where CompanyCD = @CompanyCD AND PlanNo = @PlanNo";
parameters[i] = SqlHelper.GetParameter("@CompanyCD", model.CompanyCD);
parameters[i + 1] = SqlHelper.GetParameter("@PlanNo", model.PlanNo);
//cmd.Parameters.AddWithValue("@CompanyCD", model.CompanyCD);
//cmd.Parameters.AddWithValue("@PlanNo", model.PlanNo);
SqlHelper.ExecuteNonQuery(tran.Trans, CommandType.Text, strSql.ToString(), parameters);
//cmd.CommandText = strSql;
}
catch (Exception ex)
{
string ss = ex.Message;
}
}
/// <summary>
/// 获取单据列表
/// </summary>
/// <param name="sellOfferModel">sellOfferModel表实体</param>
/// <param name="FlowStatus">审批状态</param>
/// <returns></returns>
public static DataTable GetOrderList(string EFIndex,string EFDesc,SellPlanModel sellPlanModel, int? FlowStatus, int pageIndex, int pageCount, string ord, ref int TotalCount)
{
return SellPlanDBHelper.GetOrderList(EFIndex, EFDesc, sellPlanModel, FlowStatus, pageIndex, pageCount, ord, ref TotalCount);
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_SALE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_SELLPLAN;
SellPlanModel modelMRP = new SellPlanModel();
modelMRP.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
modelMRP.ID = this.intMrpID;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "计划编号", "PlanNo"},
{ "计划名称", "Title"},
{ "计划类型", "PlanType" },
{ "计划时期", "PlanTime" },
{ "开始时间", "StartDate"},
{ "结束时间", "EndDate"},
{ "最低计划额(元)", "MinPlanTotal"},
{ "计划总金额(元)", "PlanTotal"},
{ "激励方案", "Hortation"},
{ "可查看人员", "CanViewUserName"},
{ "单据状态", "BillStatus"},
{ "制单人", "Creator"},
{ "制单日期 ", "CreateDate"},
{ "确认人", "Confirmor"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "Closer"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
};
string[,] aDetail = {
{ "部门/物品/人员", "DetailTypeName"},
{ "名称", "DetailName"},
{ "最低目标额(元)", "MinDetailotal"},
{ "目标额(元)", "DetailTotal" },
{ " 完成情况", "AddOrCutText2" },
{ "目标达成率", "CompletePercent"},
};
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.SellPlan");
if (dtExtTable.Rows.Count > 0)
{
for (int i = 0; i < dtExtTable.Rows.Count; i++)
{
for (int x = 0; x < (aBase.Length / 2) - 15; x++)
{
if (x == i)
{
aBase[x, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
countExt++;
}
}
}
}
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtMRP = SellPlanBus.GetRepOrder(PlanNo); //主表 MRPBus.GetMRPInfo(modelMRP);
DataTable dtDetail = SellPlanBus.GetOrderDetail(PlanNo); //明细表 MRPBus.GetMRPDetailInfo(modelMRP);
string strBaseFields = "";
string strDetailFields = "";
if (dbPrint.Rows.Count > 0)
{
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
}
else
{
isSeted.Value = "0";
strBaseFields = "PlanNo|Title|PlanType|PlanTime|StartDate|EndDate|MinPlanTotal|PlanTotal|Hortation|CanViewUserName|BillStatus|Creator|CreateDate|Confirmor|ConfirmDate|Closer|CloseDate|ModifiedUserID|ModifiedDate|Remark";
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
strDetailFields = "DetailTypeName|DetailName|MinDetailotal|DetailTotal|AddOrCutText2|CompletePercent";
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("销售计划", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, true);
}
#endregion
#region 明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("销售计划", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, false);
}
#endregion
}
