protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_SUBSTORAGE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_SUBSTORAGECUST;
SubSellCustInfoModel modelCust = new SubSellCustInfoModel();
modelCust.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
modelCust.ID = this.intCustID.ToString();
#region 1.初始化 取基本信息及明细信息的字段以及对应的标题
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "客户名称", "CustName"},
{ "客户联系电话", "CustTel"},
{ "客户手机号", "CustMobile"},
{ "客户地址", "CustAddr"},
};
#endregion
#region 2.所设的打印模板设置
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtCust = SubSellOrderBus.GetOneData(this.intCustID);
string strBaseFields = "";
if (dbPrint.Rows.Count > 0)
{
#region 设置过打印模板设置时 直接取出表里设置的值
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
#endregion
}
else
{
#region 未设置过打印模板设置 默认显示所有的
isSeted.Value = "0";
/*未设置过打印模板设置时，默认显示的字段 基本信息字段*/
for (int m = 0; m < aBase.Length / 2; m++)
{
strBaseFields = strBaseFields + aBase[m, 1] + "|";
}
#endregion
/*两种都可以*/
}
#endregion
#region 3.输出主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("客户", strBaseFields.TrimEnd('|'), "", aBase, aBase, dtCust, dtCust, true);
}
#endregion
}
/// <summary>
/// 获取MRP信息
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetPrintParameterSettingInfo(PrintParameterSettingModel model)
{
try
{
return PrintParameterSettingDBHelper.GetPrintParameterSettingInfo(model);
}
catch (System.Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取打印模板设置详细信息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static DataTable GetPrintParameterSettingInfo(PrintParameterSettingModel model)
{
#region 查询语句
//查询SQL拼写
StringBuilder searchSql = new StringBuilder();
searchSql.AppendLine("select * from officedba.PrintParameterSetting where BillTypeFlag=@BillTypeFlag and PrintTypeFlag=@PrintTypeFlag and CompanyCD=@CompanyCD");
#endregion
//定义查询的命令
SqlCommand comm = new SqlCommand();
//添加公司代码参数
comm.Parameters.Add(SqlHelper.GetParameterFromString("@CompanyCD", model.CompanyCD));
comm.Parameters.Add(SqlHelper.GetParameterFromString("@BillTypeFlag", model.BillTypeFlag.ToString()));
comm.Parameters.Add(SqlHelper.GetParameterFromString("@PrintTypeFlag", model.PrintTypeFlag.ToString()));
//指定命令的SQL文
comm.CommandText = searchSql.ToString();
//执行查询
return SqlHelper.ExecuteSearch(comm);
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_STORAGE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_OUTOTHER;
StorageOutOtherModel OutOtherSellM_ = new StorageOutOtherModel();
OutOtherSellM_.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
OutOtherSellM_.ID = this.intMrpID.ToString();
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase;
string[,] aDetail;
if (HiddenPrice.Value == "True")
{
aBase = new string[,]{
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "出库单编号", "OutNo"},
{ "出库单主题", "Title"},
{ "源单类型", "FromTypeName" },
{ "源单编号", "FromBillNo" },
{ "往来单位", "OtherCorpName"},
{ "往来单位类型", "CorpBigTypeName"},
{ "发货地址", "SendAddr"},
{ "收货地址", "ReceiveAddr"},
{ "经办人", "SenderName"},
{ "出库部门", "DeptName"},
{ "出库人", "TransactorName"},
{ "出库时间", "OutDate"},
{ "出库原因", "ReasonTypeName"},
{ "数量合计", "CountTotal"},
{ "金额合计", "A_TotalPrice"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserName"},
{ "最后更新日期", "ModifiedDate"},
{ "单据状态", "BillStatusName"},
{ "备注", "Remark"},
{ "所属项目", "ProjectName"},
{ "摘要", "Summary"},
};
if (HiddenMoreUnit.Value == "True")
{
aDetail = new string[,] {
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "批次", "BatchNo" },
{ "规格", "Specification" },
{ "基本单位", "UnitID" },
{ "基本数量", "ProductCount" },
{ "单位", "UsedUnitName"},
{ "仓库", "StorageName"},
{ "退货数量", "BackCount"},
{ "已出库数量", "OutedTotal"},
{ "未出库数量", "NotOutCount"},
{ "出库数量", "UsedUnitCount"},
{ "单价", "UsedPrice"},
{ "金额", "B_TotalPrice"},
{ "备注", "DetaiRemark"},
};
}
else
{
aDetail = new string[,] {
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "批次", "BatchNo" },
{ "规格", "Specification" },
{ "单位", "UnitID"},
{ "仓库", "StorageName"},
{ "退货数量", "BackCount"},
{ "已出库数量", "OutedTotal"},
{ "未出库数量", "NotOutCount"},
{ "出库数量", "ProductCount"},
{ "单价", "UnitPrice"},
{ "金额", "B_TotalPrice"},
{ "备注", "DetaiRemark"},
};
}
}
else
{
aBase = new string[,]{
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "出库单编号", "OutNo"},
{ "出库单主题", "Title"},
{ "源单类型", "FromTypeName" },
{ "源单编号", "FromBillNo" },
{ "往来单位", "OtherCorpName"},
{ "往来单位类型", "CorpBigTypeName"},
{ "发货地址", "SendAddr"},
{ "收货地址", "ReceiveAddr"},
{ "经办人", "SenderName"},
{ "出库部门", "DeptName"},
{ "出库人", "TransactorName"},
{ "出库时间", "OutDate"},
{ "出库原因", "ReasonTypeName"},
{ "数量合计", "CountTotal"},
// { "金额合计", "A_TotalPrice"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserName"},
{ "最后更新日期", "ModifiedDate"},
{ "单据状态", "BillStatusName"},
{ "备注", "Remark"},
{ "所属项目", "ProjectName"},
{ "摘要", "Summary"},
};
if (HiddenMoreUnit.Value == "True")
{
aDetail = new string[,] {
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "批次", "BatchNo" },
{ "规格", "Specification" },
{ "基本单位", "UnitID" },
{ "基本数量", "ProductCount" },
{ "单位", "UsedUnitName"},
{ "仓库", "StorageName"},
{ "退货数量", "BackCount"},
{ "已出库数量", "OutedTotal"},
{ "未出库数量", "NotOutCount"},
{ "出库数量", "UsedUnitCount"},
{ "单价", "UsedPrice"},
{ "金额", "B_TotalPrice"},
{ "备注", "DetaiRemark"},
};
}
else
{
aDetail = new string[,] {
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "批次", "BatchNo" },
{ "规格", "Specification" },
{ "单位", "UnitID"},
{ "仓库", "StorageName"},
{ "退货数量", "BackCount"},
{ "已出库数量", "OutedTotal"},
{ "未出库数量", "NotOutCount"},
{ "出库数量", "ProductCount"},
{ "单价", "UnitPrice"},
{ "金额", "B_TotalPrice"},
{ "备注", "DetaiRemark"},
};
}
}
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.StorageOutOther");
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 dtMain = StorageOutOtherBus.GetStorageOutOtherDetailInfo(OutOtherSellM_);
// DataTable dtDetail = 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
{
#region 未设置过打印模板设置 默认显示所有的
isSeted.Value = "0";
/*未设置过打印模板设置时，默认显示的字段 基本信息字段*/
for (int m = 10; m < aBase.Length / 2; m++)
{
strBaseFields = strBaseFields + aBase[m, 1] + "|";
}
/*未设置过打印模板设置时，默认显示的字段 基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "ExtField" + (i + 1) + "|";
}
}
/*未设置过打印模板设置时，默认显示的字段 明细信息字段*/
for (int n = 0; n < aDetail.Length / 2; n++)
{
strDetailFields = strDetailFields + aDetail[n, 1] + "|";
}
#endregion
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("其他出库单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMain, dtMain, true);
}
#endregion
#region 明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("销售出库单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMain, dtMain, false);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;//UserInfo.CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_SALE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_SELLGATHERING;
// /*接受参数*/
string GatheringNo = Request.QueryString["no"].ToString();
#region 基本信息 明细信息
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = { { "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "回款计划编号", "GatheringNo"},
{ "主题", "Title"},
{ "源单类型", "fromTypeName" },
{ "源单编号", "BillNo" },
{ "客户名称", "CustName"},
{ "客户类型", "TypeName"},
{ "客户电话", "Tel"},
{ "币种", "CurrencyName"},
{ "业务员", "SellerName"},
{ "部门", "DeptName"},
{ "计划回款金额", "PlanPrice"},
{ "计划回款时间", "PlanGatherDate"},
{ "实际回款金额", "FactPrice"},
{ "实际回款时间", "FactGatherDate"},
{ "回款相关单号", "LinkBillNo"},
{ "期次", "GatheringTime"},
{ "状态", "stateName"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
};
#endregion
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.SellGathering");
if (dtExtTable.Rows.Count > 0)
{
for (int i = 0; i < dtExtTable.Rows.Count; i++)
{
for (int x = 0; x < (aBase.Length / 2) - 22; x++)
{
if (x == i)
{
aBase[x, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
countExt++;
}
}
}
}
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtMain = SellGatheringBus.GetRepOrder(GatheringNo);
string strBaseFields = "";
if (dbPrint.Rows.Count > 0)
{
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
}
else
{
isSeted.Value = "0";
strBaseFields = "GatheringNo|Title|fromTypeName|BillNo|CustName|TypeName|Tel|CurrencyName|SellerName|DeptName|PlanPrice|PlanGatherDate|FactPrice|";
strBaseFields = strBaseFields + "FactGatherDate|LinkBillNo|GatheringTime|stateName|CreatorName|CreateDate|ModifiedUserID|ModifiedDate|Remark";
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
//第一个是打印页面的正标题,strBaseFields是在PrintParameterSetting表里设置的主表字段,
//strDetailFields是在PrintParameterSetting表里设置的明细表的字段,
//aBase,是打印设置页面上定义取出来的字段及对应的名称,
//aDetail是打印设置页面上定义取出来的字段及对应的名称,
//例如明细中的物品编号,对应的就是物品编号及取数据的字段ProdNo,
//dtMRP是主表的数据集,
//dtDetail是明细表的数据集,最后一个参数,用来区别是主表信息还是明细信息..
tableBase.InnerHtml = WritePrintPageTable("销售回款计划", strBaseFields, "", aBase, null, dtMain, null, true);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_PURCHASE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_PROVIDERLINKMAN;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "联系人姓名", "LinkManName"},
{ "供应商姓名", "CustName"},
{ "性别", "SexName"},
{ "重要程度", "ImportantName"},
{ "称谓", "Appellation"},
{ "单位", "Company"},
{ "部门", "Department"},
{ "职务", "Position"},
{ "负责业务", "Operation"},
{ "工作电话", "WorkTel"},
{ "传真", "Fax"},
{ "移动电话", "Handset"},
{ "邮件地址", "MailAddress"},
{ "家庭电话", "HomeTel"},
{ "MSN", "MSN"},
{ "QQ", "QQ"},
{ "邮编", "Post"},
{ "联系人类型", "LinkTypeName"},
{ "年龄", "Age"},
{ "证件类型", "PaperType"},
{ "证件号", "PaperNum"},
{ "最后更新日期", "ModifiedDate"},
{ "最后更新人", "ModifiedUserID"},
{ "生日", "Birthday"},
{ "爱好", "Likes"},
{ "备注", "Remark"},
};
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtProviderInfo = ProviderLinkManBus.SelectProviderLinkMan(this.intMrpID);
string strBaseFields = "";
string strDetailFields = "";
/*第二明细*/
string strDetailSecondFields = "";
if (dbPrint.Rows.Count > 0)
{
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
/*第二明细*/
strDetailSecondFields = dbPrint.Rows[0]["DetailSecondFields"].ToString();
}
else
{
isSeted.Value = "0";
strBaseFields = "LinkManName|CustName|SexName|ImportantName|Appellation|Company|Department|Position|Operation|WorkTel|Fax|Handset|MailAddress|HomeTel|MSN|QQ|Post|LinkTypeName|Age|PaperType|PaperNum|ModifiedDate|ModifiedUserID|Birthday|Likes|Remark";
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("供应商联系人", strBaseFields, null, aBase, null, dtProviderInfo, null, true);
}
#endregion
//#region 3.明细信息
//if (!string.IsNullOrEmpty(strDetailFields))
//{
// tableDetail.InnerHtml = WritePrintPageTable("物料需求计划", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, false);
//}
//#endregion
///*第二明细*/
//#region 4.明细信息2
//if (!string.IsNullOrEmpty(strDetailSecondFields))
//{
// tableDetail2.InnerHtml = WritePrintPageTable("物料需求计划", strBaseFields, strDetailSecondFields, aBase, aSecondDetail, dtMRP, dtDetail, false);
//}
//#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_PURCHASE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_PurchaseApply;
//PurchaseApplyModel modelMRP = new PurchaseApplyModel();
//PurchaseApplyModel.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
//PurchaseApplyModel.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"},
{ "单据编号", "ApplyNo"},
{ "主题", "Title"},
{ "采购类别", "TypeName" },
{ "申请人", "ApplyUserName"},
{ "部门", "DeptName" },
{ "源单类型", "FromTypeName" },
{ "申请日期", "ApplyDate" },
{ "到货地址", "Address" },
{ "数量总计", "CountTotal"},
{ "单据状态", "BillStatusName"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
};
string[,] aDetail;
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
aDetail = new string[,] {
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification"},
{ "颜色", "ColorName"},
{ "基本单位", "UnitName" },
{ "基本数量", "PlanCount"},
{ "单位", "UsedUnitName" },
{ "需求数量", "UsedUnitCount"},
{ "需求日期", "PlanTakeDate"},
{ "申请原因", "ApplyReasonName"},
{ "源单编号", "FromBillNo"},
{ "源单序号", "FromLineNo"},
};
}
else
{
aDetail = new string[,] {
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification"},
{ "颜色", "ColorName"},
{ "单位", "UnitName" },
{ "需求数量", "PlanCount"},
{ "需求日期", "PlanTakeDate"},
{ "申请原因", "ApplyReasonName"},
{ "源单编号", "FromBillNo"},
{ "源单序号", "FromLineNo"},
};
}
string[,] aSecondDetail;
/*第二明细*/
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
aSecondDetail = new string[,] {
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification"},
{ "颜色", "ColorName"},
{ "基本单位", "UnitName" },
{ "基本数量", "ProductCount"},
{ "单位", "UsedUnitName" },
{ "申请数量", "UsedUnitCount"} ,
{ "需求日期", "RequireDate"},
};
}
else
{
aSecondDetail = new string[,] {
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification"},
{ "颜色", "ColorName"},
{ "单位", "UnitName" },
{ "申请数量", "ProductCount"},
{ "需求日期", "RequireDate"},
};
}
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba." + ConstUtil.CODING_RULE_TABLE_PURCHASEAPPLY);
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 = PurchaseApplyBus.GetPurchaseApply(this.intMrpID.ToString ());
DataTable dtDetail = PurchaseApplyBus.GetPurchaseApplySource(this.intMrpID.ToString());
//DataTable PurchaseApplyPrimary = PurchaseApplyBus.GetPurchaseApply(ID);
//DataTable PurchaseApplySource = PurchaseApplyBus.GetPurchaseApplySource(ID);
DataTable PurchaseApplyDetail2 = PurchaseApplyBus.GetPurchaseApplyDetail(this.intMrpID.ToString());
string strBaseFields = "";
string strDetailFields = "";
/*第二明细*/
string strDetailSecondFields = "";
if (dbPrint.Rows.Count > 0)
{
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
/*第二明细*/
strDetailSecondFields = dbPrint.Rows[0]["DetailSecondFields"].ToString();
}
else
{
isSeted.Value = "0";
strBaseFields = "ApplyNo|Title|TypeName|ApplyUserName|DeptName|FromTypeName|ApplyDate|Address|CountTotal|CreatorName|CreateDate|BillStatusName|ConfirmorName|ConfirmDate|CloserName|CloseDate|ModifiedUserID|ModifiedDate|Remark";
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
strDetailFields = "SortNo|ProductNo|ProductName|Specification|ColorName|UnitName|PlanCount|UsedUnitName|UsedUnitCount|PlanTakeDate|ApplyReasonName|FromBillNo|FromLineNo";
}
else
{
strDetailFields = "SortNo|ProductNo|ProductName|Specification|ColorName|UnitName|PlanCount|PlanTakeDate|ApplyReasonName|FromBillNo|FromLineNo";
}
/*第二明细*/
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
strDetailSecondFields = "SortNo|ProductNo|ProductName|Specification|ColorName|UnitName|ProductCount|UsedUnitName|UsedUnitCount|RequireDate";
}
else
{
strDetailSecondFields = "SortNo|ProductNo|ProductName|Specification|ColorName|UnitName|ProductCount|RequireDate";
}
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("采购申请", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, true);
}
#endregion
#region 3.明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("采购申请", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, false);
}
#endregion
/*第二明细*/
#region 4.明细信息2
if (!string.IsNullOrEmpty(strDetailSecondFields))
{
tableDetail2.InnerHtml = WritePrintPageTable("采购申请", strBaseFields, strDetailSecondFields, aBase, aSecondDetail, dtMRP, PurchaseApplyDetail2, false);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_STORAGE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_INPROCESS;
StorageInProcessModel InProcessM_ = new StorageInProcessModel();
InProcessM_.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
InProcessM_.ID = this.intMrpID.ToString();
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase;
string[,] aDetail;
if (GetIsDisplayPrice() != "none")
{
aBase = new string[,] {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "入库单编号", "InNo"},
{ "入库单主题", "Title"},
{ "源单类型", "FromType" },
{ "生产任务单", "TaskNo" },
{ "加工类别", "ProcessType"},
{ "加工单位", "ProcessDeptName"},
{ "生产负责人", "ProcessorName"},
{ "入库人", "ExecutorName"},
{ "入库时间", "EnterDate"},
{ "入库部门", "InPutDeptName"},
{ "摘要", "Summary"},
{ "批次", "BatchNo"},
{ "数量合计", "CountTotal"},
{ "金额合计", "A_TotalPrice"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "单据状态", "BillStatus"},
{ "备注", "Remark"},
};
if (HiddenMoreUnit.Value == "true")
{
aDetail = new string[,]
{
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "基本单位", "UnitID"},
{ "单位", "UsedUnitName"}, //++
{ "仓库", "StorageName"},
{ "源单数量", "FromBillCount"},
{ "已入库数量", "InCount"},
{ "未入库数量", "NotInCount"},
{ "基本数量", "ProductCount"},
{ "数量", "UsedUnitCount"}, //++
{ "单价", "UnitPrice"},
{ "金额", "B_TotalPrice"},
};
}
else
{
aDetail = new string[,]
{
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "单位", "UnitID"},
{ "仓库", "StorageName"},
{ "源单数量", "FromBillCount"},
{ "已入库数量", "InCount"},
{ "未入库数量", "NotInCount"},
{ "实收数量", "ProductCount"},
{ "单价", "UnitPrice"},
{ "金额", "B_TotalPrice"},
};
}
}
else
{
aBase = new string[,] {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "入库单编号", "InNo"},
{ "入库单主题", "Title"},
{ "源单类型", "FromType" },
{ "生产任务单", "TaskNo" },
{ "加工类别", "ProcessType"},
{ "加工单位", "ProcessDeptName"},
{ "生产负责人", "ProcessorName"},
{ "入库人", "ExecutorName"},
{ "入库时间", "EnterDate"},
{ "入库部门", "InPutDeptName"},
{ "摘要", "Summary"},
{ "数量合计", "CountTotal"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "单据状态", "BillStatus"},
{ "备注", "Remark"},
};
if (HiddenMoreUnit.Value == "true")
{
aDetail = new string[,]
{
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "基本单位", "UnitID"},
{ "单位", "UsedUnitName"}, //++
{ "仓库", "StorageName"},
{ "源单数量", "FromBillCount"},
{ "已入库数量", "InCount"},
{ "未入库数量", "NotInCount"},
{ "基本数量", "ProductCount"},
{ "数量", "UsedUnitCount"}, //++
};
}
else
{
aDetail = new string[,]
{
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "单位", "UnitID"},
{ "仓库", "StorageName"},
{ "源单数量", "FromBillCount"},
{ "已入库数量", "InCount"},
{ "未入库数量", "NotInCount"},
{ "实收数量", "ProductCount"},
};
}
}
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.StorageInProcess");
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 dtDetail = StorageInProcessBus.GetStorageInProcessDetailInfo(InProcessM_.ID, InProcessM_.CompanyCD);
DataTable dtMain = StorageInProcessBus.GetStorageInProcessInfo(InProcessM_.ID, InProcessM_.CompanyCD);
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
{
#region 未设置过打印模板设置 默认显示所有的
isSeted.Value = "0";
/*未设置过打印模板设置时，默认显示的字段 基本信息字段*/
for (int m = 10; m < aBase.Length / 2; m++)
{
strBaseFields = strBaseFields + aBase[m, 1] + "|";
}
/*未设置过打印模板设置时，默认显示的字段 基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "ExtField" + (i + 1) + "|";
}
}
/*未设置过打印模板设置时，默认显示的字段 明细信息字段*/
for (int n = 0; n < aDetail.Length / 2; n++)
{
strDetailFields = strDetailFields + aDetail[n, 1] + "|";
}
#endregion
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("生产入库单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMain, dtDetail, true);
}
#endregion
#region 明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("生产入库单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMain, dtDetail, false);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_CUSTOMER);
model.PrintTypeFlag = ConstUtil.PRINTBILL_CUSTINFO;
CustInfoModel modelMRP = new CustInfoModel();
modelMRP.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
modelMRP.CustNo = this.CustNo;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "{ExtField11}", "ExtField11"},
{ "{ExtField12}", "ExtField12"},
{ "{ExtField13}", "ExtField13"},
{ "{ExtField14}", "ExtField14"},
{ "{ExtField15}", "ExtField15"},
{ "{ExtField16}", "ExtField16"},
{ "{ExtField17}", "ExtField17"},
{ "{ExtField18}", "ExtField18"},
{ "{ExtField19}", "ExtField19"},
{ "{ExtField20}", "ExtField20"},
{ "{ExtField21}", "ExtField21"},
{ "{ExtField22}", "ExtField22"},
{ "{ExtField23}", "ExtField23"},
{ "{ExtField24}", "ExtField24"},
{ "{ExtField25}", "ExtField25"},
{ "{ExtField26}", "ExtField26"},
{ "{ExtField27}", "ExtField27"},
{ "{ExtField28}", "ExtField28"},
{ "{ExtField29}", "ExtField29"},
{ "{ExtField30}", "ExtField30"},
{ "客户编号", "CustNo"},
{ "客户名称", "CustName"},
{ "客户大类", "CustBig" },
{ "客户简称", "CustNam" },
{ "拼音缩写", "CustShort"},
{ "客户管理分类", "CustTypeManage"},
{ "客户营销分类", "CustTypeSell"},
{ "客户优质级别", "CreditGradeNm"},
{ "客户时间分类", "CustTypeTime"},
{ "客户细分", "CustClassName"},
{ "客户类别", "CustTypaNm"},
{ "建档人", "CreatorName"},
{ "建档日期", "CreatedDate"},
{ "客户简介", "CustNote"},
{ "国家地区", "CountryName"},
{ "区域", "AreaName"},
{ "省", "Province"},
{ "市(县)", "City"},
{ "业务类型", "BusiType"},
{ "分管业务员 ", "ManagerName"},
{ "联系人", "ContactName"},
{ "电话", "Tel"},
{ "手机", "Mobile"},
{ "传真", "Fax"},
{ "在线咨询", "OnLine"},
{ "公司网址 ", "WebSite"},
{ "邮编", "Post"},
{ "电子邮件", "email"},
{ "首次交易日期", "FirstBuyDate"},
{ "运送方式", "CarryTypeNm"},
{ "交货方式", "TakeTypeNm"},
{ "联络期限(天)", "LinkCycleNm"},
{ "收货地址", "ReceiveAddress"},
{ "经营范围", "SellArea"},
{ "允许延期付款", "CreditManage"},
{ "信用额度(元)", "MaxCredit"},
{ "帐期天数(天)", "MaxCreditDate"},
{ "结算方式", "PayTypeNm"},
{ "结算币种", "CurrencyaNm"},
{ "发票类型", "BillTypeNm"},
{ "支付方式", "MoneyTypeNm"},
{ "开户行", "OpenBank"},
{ "户名", "AccountMan"},
{ "账号", "AccountNum"},
{ "单位性质", "CompanyType"},
{ "资产规模(万元)", "CapitalScale"},
{ "成立时间", "SetupDate"},
{ "注册资本(万元)", "SetupMoney"},
{ "员工总数(个)", "StaffCount"},
{ "法人代表", "ArtiPerson"},
{ "行业", "Trade"},
{ "营业执照号", "BusiNumber"},
{ "注册地址", "SetupAddress"},
{ "税务登记号", "TaxCD"},
{ "是否为一般纳税人", "IsTax"},
{ "客户来源", "Source"},
{ "年销售额(万元)", "SaleroomY"},
{ "年利润额(万元)", "ProfitY"},
{ "销售模式", "SellMode"},
{ "上级客户", "CustSupe"},
{ "价值评估", "MeritGrade"},
{ "阶段", "Phase"},
{ "热点客户", "HotIs"},
{ "热度", "HotHow"},
{ "关系等级", "RelaGrade"},
{ "启用状态", "UsedStatus"},
{ "关系描述", "Relation"},
{ "备注", "Remark"},
{ "最后更新用户", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "经营理念", "CompanyValues"},
{ "企业口号", "CatchWord"},
{ "企业文化概述", "ManageValues"},
{ "发展潜力", "Potential"},
{ "存在问题", "Problem"},
{ "市场优劣势", "Advantages"},
{ "行业地位", "TradePosition"},
{ "竞争对手", "Competition"},
{ "合作伙伴", "Collaborator"},
{ "发展计划", "ManagePlan"},
{ "合作方法", "Collaborate"},
{ "可查看该客户档案的人员", "CanViewUserName"},
};
string[,] aDetail = { { "", "" } };
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.CustInfo");
if (dtExtTable.Rows.Count > 0)
{
for (int i = 0; i < dtExtTable.Rows.Count; i++)
{
for (int x = 0; x < (aBase.Length / 2) - 82; x++)
{
if (x == i)
{
aBase[x, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
countExt++;
}
}
}
}
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
//DataTable dtMRP = SellContractBus.GetRepOrder(OfferNo);
DataTable dtMRP = CustInfoBus.GetCustInfoByNo(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, CustBig, CustNo);
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 = "CustNo|CustName|CustBig|CustNam|CustShort|CustTypeManage|CustTypeSell|CreditGradeNm|CustTypeTime|CustClassName|CustTypaNm|CreatorName|" +
"CreatedDate|CustNote|CountryName|AreaName|Province|City|BusiType|ManagerName|ContactName|Tel|Mobile|Fax|OnLine|WebSite|Post|email|FirstBuyDate|" +
"CarryTypeNm|TakeTypeNm|LinkCycleNm|ReceiveAddress|SellArea|CreditManage|MaxCredit|MaxCreditDate|PayTypeNm|CurrencyaNm|BillTypeNm|MoneyTypeNm|" +
"OpenBank|AccountMan|AccountNum|CompanyType|CapitalScale|SetupDate|SetupMoney|StaffCount|ArtiPerson|Trade|BusiNumber|SetupAddress|TaxCD|IsTax|" +
"Source|SaleroomY|ProfitY|SellMode|CustSupe|MeritGrade|Phase|HotIs|HotHow|RelaGrade|UsedStatus|Relation|Remark|ModifiedUserID|ModifiedDate|" +
"CompanyValues|CatchWord|ManageValues|Potential|Problem|Advantages|TradePosition|Competition|Collaborator|ManagePlan|Collaborate|CanViewUserName";
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
strDetailFields = "";
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("客户档案", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, null, true);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_STORAGE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_Init;
StorageInitailModel OutSellM_ = new StorageInitailModel();
OutSellM_.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
OutSellM_.ID = this.intMrpID.ToString();
string[,] aDetail;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "入库单编号", "InNo"},
{ "入库单主题 ", "Title"},
{ "仓库", "StorageName" },
{ "入库部门 ", "DeptName" },
{ "入库人", "ExecutorName"},
{ "入库时间", "EnterDate"},
{ "摘要 ", "Summary"},
{ "批次", "BatchNo"},
{ "入库数量合计 ", "CountTotal"},
{ "入库金额合计 ", "A_TotalPrice"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "单据状态", "BillStatusName"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserName"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
};
if (HiddenMoreUnit.Value == "true")
{
aDetail = new string[,] {
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "基本单位", "UnitID"},
{ "基本数量", "ProductCount"},
{ "单位", "UsedUnitName"}, //++
{ "数量", "UsedUnitCount"}, //++
{ "入库单价 ", "UnitPrice"},
{ "入库金额 ", "B_TotalPrice"},
{ "备注", "DetaiRemark"},
};
}
else
{
aDetail = new string[,] {
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "单位", "UnitID"},
{ "数量", "ProductCount"},
{ "入库单价 ", "UnitPrice"},
{ "入库金额 ", "B_TotalPrice"},
{ "备注", "DetaiRemark"},
};
}
#region 1.扩展属性
DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.StorageInitail");
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();
}
}
}
}
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtMain = StorageInitailBus.GetStorageInitailDetailInfo(OutSellM_);
// DataTable dtDetail = 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 = "InNo|Title|StorageName|DeptName|ExecutorName|EnterDate|Summary|BatchNo|CountTotal|A_TotalPrice"
+ "|CreatorName|CreateDate|BillStatusName|ConfirmorName|ConfirmDate|CloserName|CloseDate"
+ "|ModifiedUserName|ModifiedDate|Remark"
+ "|ExtField1|ExtField2|ExtField3|ExtField4|ExtField5|ExtField6|ExtField7|ExtField8|ExtField9|ExtField10";
if (HiddenMoreUnit.Value == "True")
{
strDetailFields = "SortNo|ProductNo|ProductName|Specification|UnitID|ProductCount|UsedUnitName|UsedUnitCount|UnitPrice|B_TotalPrice|DetaiRemark";
}
else
{
strDetailFields = "SortNo|ProductNo|ProductName|Specification|UnitID|ProductCount|UnitPrice|B_TotalPrice|DetaiRemark";
}
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("期初库存录入单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMain, dtMain, true);
}
#endregion
#region 明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("期初库存录入单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMain, dtMain, false);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel pModel = new PrintParameterSettingModel();
pModel.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
pModel.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_QUALITYCHECK);
pModel.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_CHECKREPORT;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "单据编号", "ReportNo"},
{ "主题", "Title"},
{ "源单类型", "FromType" },
{ "源单编号", "FromReportNo" },
{ "往来单位", "OtherCorpName" },
{ "往来单位大类", "CorpBigType" },
{ "生产负责人", "PrincipalName" },
{ "生产部门", "DeptName" },
{ "质检类别", "CheckType" },
{ "检验日期", "CheckDate" },
{ "报检人员", "ApplyUserName" },
{ "报检部门", "ApplyDeptName" },
{ "检验人员", "CheckerName" },
{ "检验部门", "CheckDeptName" },
{ "检验方案", "CheckContent" },
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName"},
{ "单位", "CodeName"},
{ "规格", "Specification"},
{ "报检数量", "CheckNum"},
{ "抽样数量", "SampleNum"},
{ "检验方式", "CheckMode"},
{ "合格数量", "PassNum"},
{ "不合格数量", "NoPass"},
{ "合格率(%)", "PassPercent"},
{ "检验标准", "CheckStandard"},
{ "检验结果描述 ", "CheckResult"},
{ "检验结果 ", "IsPass"},
{ "是否需要复检", "isRecheck"},
{ "单据状态", "BillStatus"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
};
string[,] aDetail = {
{ "序号", "SortNo"},
{ "检验项目", "CheckItem"},
{ "检验指标", "CheckStandard"},
{ "检验值", "CheckValue"},
{ "检验结论", "CheckResult"},
{ "检验结果", "isPass"},
{ "检验数量", "CheckNum"},
{ "合格数量", "PassNum"},
{ "不合格数", "NotPassNum" },
{ "检验人员", "Checker"},
{ "检验部门", "CheckDeptID" },
{ "标准值", "StandardValue"},
{ "指标上限", "NormUpLimit"},
{ "指标下限", "LowerLimit"},
{ "备注", "Remark"},
};
#region 扩展属性
DataTable dtExtTable = TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.QualityCheckReport");
int countExt = 0;
for (int i = 0; i < dtExtTable.Rows.Count; i++)
{
aBase[i, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
countExt++;
}
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(pModel);
DataTable dt = CheckReportBus.GetReportInfo(this.intID);
DataTable dtDetail = CheckReportBus.GetDetailInfo(this.intID);
dtDetail.Columns.Add("SortNo", typeof(string));
for (int i = 0; i < dtDetail.Rows.Count; i++)
{
dtDetail.Rows[i]["SortNo"] = i + 1;
}
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 = GetDefaultFields(aBase);
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields += "|ExtField" + (i + 1);
}
}
strDetailFields = GetDefaultFields(aDetail);
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("质检报告单", strBaseFields, strDetailFields, aBase, aDetail, dt, dtDetail, true);
}
#endregion
#region 明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("质检报告单", strBaseFields, strDetailFields, aBase, aDetail, dt, dtDetail, false);
}
#endregion
}
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_SELLCHANCE;
SellChanceModel modelMRP = new SellChanceModel();
modelMRP.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
modelMRP.ChanceNo = this.ChanceNo;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "机会编号", "ChanceNo"},
{ "机会主题", "Title"},
{ "机会类型", "ChanceTypeName" },
{ "客户名称", "CustName" },
{ "客户电话", "CustTel"},
{ "客户类型", "CustTypeName"},
{ "机会来源", "HapSourceName"},
{ "发现日期", "FindDate"},
{ "业务员", "SellerName"},
{ "部门", "DeptName"},
{ "提供人", "ProvideMan"},
{ "需求描述", "Requires"},
{ "可查看该机会人员", "CanViewUserName"},
{ "提醒时间", "RemindTime"},
{ "提醒手机号", "RemindMTel"},
{ "接收人", "ReceiverName"},
{ "提醒内容", "RemindContent"},
{ "预期金额", "IntendMoney"},
{ "预期签单日", "IntendDate"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "是否被报价", "IsQuotedName"},
{ "备注", "Remark"},
};
string[,] aDetail = {
{ "阶段", "PhaseName"},
{ "日期", "PushDate"},
{ "业务员", "EmployeeName"},
{ "状态", "StateName" },
{ "可能性", "TypeName" },
{ "阶段备注", "Remark"},
};
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.SellChance");
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 = SellChanceBus.GetRepOrder(ChanceNo);// SellPlanBus.GetRepOrder(PlanNo);
DataTable dtDetail = SellChanceBus.GetRepOrderDetail(ChanceNo); //SellPlanBus.GetOrderDetail(PlanNo);
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 = "ChanceNo|Title|ChanceTypeName|CustName|CustTel|CustTypeName|HapSourceName|FindDate|SellerName|DeptName|ProvideMan|Requires|CanViewUserName|RemindTime|RemindMTel|ReceiverName|RemindContent|IntendMoney|IntendDate|CreatorName|CreateDate|ModifiedUserID|ModifiedDate|IsQuotedName|Remark";
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
strDetailFields = "PhaseName|PushDate|EmployeeName|StateName|TypeName|Remark";
}
#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
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_STORAGE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_BORROW;
StorageInitailModel OutSellM_ = new StorageInitailModel();
OutSellM_.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
OutSellM_.ID = this.intMrpID.ToString();
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "借货单编号", "BorrowNo"},
{ "借货单主题 ", "Title"},
{ "借货人", "BorrowerText" },
{ "借货部门", "DeptName" },
{ "借货原因", "Reason"},
{ "借货日期", "BorrowDate"},
{ "借出仓库 ", "SotorageName"},
{ "出库日期 ", "OutDate"},
{ "出库人 ", "OuterText"},
{ "借出部门", "OutDeptName"},
{ "摘要", "Summary"},
{ "借货数量合计 ", "CountTotal"},
{ "借货金额合计 ", "TotalPrice"},
{ "制单人", "CreatorText"},
{ "制单日期", "CreateDate"},
{ "单据状态", "BillStatusText"},
{ "确认人", "ConfirmorText"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserText"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
};
string[,] aDetail = null;
if (!UserInfo.IsMoreUnit)
aDetail = new string[,]{
{ "序号", "SortNo"},
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName" },
{"批次","BatchNo"},
{ "规格", "Specification" },
{ "单位", "CodeName"},
{ "现有存量", "UseCount"},
{ "借出单价 ", "UnitPrice"},
{ "借货数量 ", "ProductCount"},
{ "借货金额 ", "TotalPrice"},
{ "预计返还日期 ", "ReturnDate"},
{ "预计返还数量 ", "ReturnCount"},
{ "已返还数量 ", "RealReturnCount"},
{ "备注", "Remark"},
};
else
aDetail = new string[,] {
{ "序号", "SortNo"},
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName" },
{"批次","BatchNo"},
{ "规格", "Specification" },
{ "基本单位", "CodeName"},
{"基本数量","ProductCount"},
{"单位","UsedUnitName"},
{ "现有存量", "UseCount"},
{ "借出单价 ", "UsedPrice"},
{ "借货数量 ", "UsedUnitCount"},
{ "借货金额 ", "TotalPrice"},
{ "预计返还日期 ", "ReturnDate"},
{ "预计返还数量 ", "ReturnCount"},
{ "已返还数量 ", "RealReturnCount"},
{ "备注", "Remark"},
};
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.StorageBorrow");
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
string No = Request.QueryString["No"].ToString();
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtMRP = StorageBorrowBus.GetStorageBorrowInfo(intMrpID);
DataTable dtDetail = StorageBorrowBus.GetStorageBorrowDetail(OutSellM_.CompanyCD, No);
string strBaseFields = "";
string strDetailFields = "";
if (dbPrint.Rows.Count > 0)
{
#region 设置过打印模板设置时 直接取出表里设置的值
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
#endregion
}
else
{
#region 未设置过打印模板设置 默认显示所有的
isSeted.Value = "0";
/*未设置过打印模板设置时，默认显示的字段 基本信息字段*/
for (int m = 10; m < aBase.Length / 2; m++)
{
strBaseFields = strBaseFields + aBase[m, 1] + "|";
}
/*未设置过打印模板设置时，默认显示的字段 基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "ExtField" + (i + 1) + "|";
}
}
/*未设置过打印模板设置时，默认显示的字段 明细信息字段*/
for (int n = 0; n < aDetail.Length / 2; n++)
{
strDetailFields = strDetailFields + aDetail[n, 1] + "|";
}
#endregion
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("借货申请单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMRP, dtDetail, true);
}
#endregion
#region 3.明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("借货申请单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMRP, dtDetail, false);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel pModel = new PrintParameterSettingModel();
pModel.CompanyCD = UserInfo.CompanyCD;
pModel.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_SUBSTORAGE);
pModel.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_SUBSTORAGEIN;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "入库单编号", "InNo"},
{ "入库单主题", "Title"},
{ "分店名称", "DeptName" },
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "单据状态", "BillStatusName"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
};
string[,] aDetail = {
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName"},
{ "批次", "BatchNo"},
{ "规格", "standard"},
{ "单位", "UnitName"},
{ "入库数量", "SendCount"}
};
if (_isMoreUnit)
{// 启用多计量单位
aDetail = new string[,]
{
{ "序号", "SortNo"},
{ "物品编号", "ProductNo"},
{ "物品名称", "ProductName"},
{ "批次", "BatchNo"},
{ "规格", "standard"},
{ "基本单位", "UnitName" },
{ "基本数量", "SendCount"},
{ "单位", "UsedUnitName"},
{ "入库数量", "UsedUnitCount"}
};
}
#region 扩展属性
DataTable dtExtTable = TableExtFieldsBus.GetAllList(UserInfo.CompanyCD, "", "officedba.SubStorageIn");
int countExt = 0;
for (int i = 0; i < dtExtTable.Rows.Count; i++)
{
aBase[i, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
countExt++;
}
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(pModel);
DataTable dt = SubStorageBus.SubStorageIn(intID);
string deptID = UserInfo.DeptID.ToString();
DataRow dtDeptID = SubStorageDBHelper.GetSubDeptFromDeptID(UserInfo.DeptID.ToString());
if (dtDeptID != null)
{
deptID = dtDeptID["ID"].ToString();
}
DataTable dtDetail = SubStorageBus.Details(intID, deptID);
dtDetail.Columns.Add("SortNo", typeof(string));
for (int i = 0; i < dtDetail.Rows.Count; i++)
{
dtDetail.Rows[i]["SortNo"] = i + 1;
}
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 = GetDefaultFields(aBase);
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields += "|ExtField" + (i + 1);
}
}
strDetailFields = GetDefaultFields(aDetail);
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("分店期初库存", strBaseFields, strDetailFields, aBase, aDetail, dt, dtDetail, true);
}
#endregion
#region 明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("分店期初库存", strBaseFields, strDetailFields, aBase, aDetail, dt, dtDetail, false);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_STORAGE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_TRANSFER;
StorageInitailModel OutSellM_ = new StorageInitailModel();
OutSellM_.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
OutSellM_.ID = this.intMrpID.ToString();
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "调拨单编号", "TransferNo"},
{ "调拨单主题", "Title"},
{ "调拨申请人", "ApplyUserIDName" },
{ "要货部门", "ApplyDeptIDName" },
{ "调入仓库", "InStorageName"},
{ "要求到货日期", "RequireInDate"},
{ "调拨原因 ", "Reason"},
{ "调货部门 ", "OutDeptIDName"},
{ "调出仓库 ", "OutStorageName"},
{ "业务状态", "BusiStatusText"},
{ "摘要", "Summary"},
{ "调拨数量合计 ", "TransferCount"},
{ "调拨金额合计 ", "TransferPrice"},
{ "调拨费用 ", "TransferFeeSum"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "单据状态", "BillStatusText"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
};
string[,] aDetail =null;
if(!UserInfo.IsMoreUnit)
aDetail= new string[,] {
{ "序号", "SortNo"},
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName" },
{"批次","BatchNo"},
{ "规格", "Specification" },
{ "单位", "UnitName"},
{ "调拨单价", "TranPrice"},
{ "调拨数量 ", "TranCount"},
{ "调拨金额 ", "TranPriceTotal"},
{ "已出库数量 ", "OutCount"},
{ "已入库数量 ", "InCount"},
{ "备注 ", "Remark"},
};
else
aDetail = new string[,] {
{ "序号", "SortNo"},
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName" },
{"批次","BatchNo"},
{ "规格", "Specification" },
{ "基本单位", "UnitName"},
{"基本数量","TranCount"},
{ "单位", "UsedUnitName"},
{ "调拨单价", "TranPrice"},
{ "调拨数量 ", "UsedUnitCount"},
{ "调拨金额 ", "TranPriceTotal"},
{ "已出库数量 ", "OutCount"},
{ "已入库数量 ", "InCount"},
{ "备注 ", "Remark"},
};
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.StorageTransfer");
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
string No = Request.QueryString["No"].ToString();
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
XBase.Model.Office.StorageManager.StorageTransfer st = new XBase.Model.Office.StorageManager.StorageTransfer();
st.ID = intMrpID;
XBase.Model.Office.StorageManager.StorageTransferDetail std = new XBase.Model.Office.StorageManager.StorageTransferDetail();
std.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
std.TransferNo = No;
/*读取数据*/
DataTable dtMRP = XBase.Business.Office.StorageManager.StorageTransferBus.GetStorageTransferInfoPrint(st);
DataTable dtDetail = XBase.Business.Office.StorageManager.StorageTransferBus.GetStorageTransferDetailInfo(std);
string strBaseFields = "";
string strDetailFields = "";
if (dbPrint.Rows.Count > 0)
{
#region 设置过打印模板设置时 直接取出表里设置的值
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
#endregion
}
else
{
#region 未设置过打印模板设置 默认显示所有的
isSeted.Value = "0";
/*未设置过打印模板设置时，默认显示的字段 基本信息字段*/
for (int m = 10; m < aBase.Length / 2; m++)
{
strBaseFields = strBaseFields + aBase[m, 1] + "|";
}
/*未设置过打印模板设置时，默认显示的字段 基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "ExtField" + (i + 1) + "|";
}
}
/*未设置过打印模板设置时，默认显示的字段 明细信息字段*/
for (int n = 0; n < aDetail.Length / 2; n++)
{
strDetailFields = strDetailFields + aDetail[n, 1] + "|";
}
#endregion
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("库存调拨单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMRP, dtDetail, true);
}
#endregion
#region 3.明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("库存调拨单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMRP, dtDetail, false);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_PURCHASE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_PROVIDERINFO;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "供应商编号", "CustNo"},
{ "供应商类别", "CustTypeName"},
{ "供应商分类", "CustClassName" },
{ "供应商名称", "CustName" },
{ "供应商简称", "CustNam"},
{ "供应商拼音代码", "PYShort"},
{ "供应商简介", "CustNote"},
{ "国家地区", "CountryName"},
{ "省", "Province"},
{ "市", "City"},
{ "邮编", "Post"},
{ "联系人", "ContactName"},
{ "电话", "Tel"},
{ "传真", "Fax"},
{ "手机", "Mobile"},
{ "邮件", "email"},
{ "在线咨询", "OnLine"},
{ "公司网址", "WebSite"},
{ "交货方式", "TakeTypeName"},
{ "运送方式", "CarryTypeName"},
{ "供应商优先级别", "CreditGradeName"},
{ "热点供应商", "HotIsName"},
{ "启用状态", "UsedStatusName"},
{ "分管采购员", "ManagerName"},
{ "联络期限", "LinkCycle"},
{ "所在地区", "AreaName"},
{ "发货地址", "SendAddress"},
{ "经营范围", "SellArea"},
{ "结算方式", "PayTypeName"},
{ "币种", "CurrencyTypeName"},
{ "开户行", "OpenBank"},
{ "户名", "AccountMan"},
{ "帐号", "AccountNum"},
{ "成立时间", "SetupDate"},
{ "法人代表", "ArtiPerson"},
{ "一般纳税人", "IsTaxName"},
{ "税务登记号", "TaxCD"},
{ "营业执照号", "BusiNumber"},
{ "热度", "HotHowName"},
};
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtProviderInfo = ProviderInfoBus.SelectProviderInfo(this.intMrpID);
string strBaseFields = "";
string strDetailFields = "";
/*第二明细*/
string strDetailSecondFields = "";
if (dbPrint.Rows.Count > 0)
{
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
/*第二明细*/
strDetailSecondFields = dbPrint.Rows[0]["DetailSecondFields"].ToString();
}
else
{
isSeted.Value = "0";
strBaseFields = "CustNo|CustTypeName|CustClassName|CustName|CustNam|PYShort|CustNote|CountryName|Province|City|Post|ContactName|Tel|Fax|Mobile|email|OnLine|WebSite|TakeTypeName|CarryTypeName|CreditGradeName|HotIsName|UsedStatusName|ManagerName|LinkCycle|AreaName|SendAddress|SellArea|PayTypeName|CurrencyTypeName|OpenBank|AccountMan|AccountNum|SetupDate|ArtiPerson|IsTaxName|TaxCD|BusiNumber|HotHowName";
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("供应商档案", strBaseFields, null, aBase, null, dtProviderInfo, null, true);
}
#endregion
//#region 3.明细信息
//if (!string.IsNullOrEmpty(strDetailFields))
//{
// tableDetail.InnerHtml = WritePrintPageTable("物料需求计划", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, false);
//}
//#endregion
///*第二明细*/
//#region 4.明细信息2
//if (!string.IsNullOrEmpty(strDetailSecondFields))
//{
// tableDetail2.InnerHtml = WritePrintPageTable("物料需求计划", strBaseFields, strDetailSecondFields, aBase, aSecondDetail, dtMRP, dtDetail, false);
//}
//#endregion
}
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_ADVERSARYSELL;
AdversarySellModel modelMRP = new AdversarySellModel();
modelMRP.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
modelMRP.CustNo = this.OfferNo;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "对手编号", "CustNo"},
{ "销售机会", "ChanceNo"},
{ "竞争客户", "CustName" },
{ "对手产品报价", "Price" },
{ "竞争产品/方案", "Project"},
{ "竞争能力", "Power"},
{ "竞争优势", "Advantage"},
{ "竞争劣势", "disadvantage"},
{ "应对策略", "Policy"},
{ "制单人", "EmployeeName"},
{ "制单日期", "CreatDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
};
string[,] aDetail = {{"",""}};
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtMRP = AdversarySellBus.GetRepOrder(OfferNo); //SellOfferBus.GetRepOrder(OfferNo);
string strBaseFields = "";
if (dbPrint.Rows.Count > 0)
{
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
}
else
{
isSeted.Value = "0";
strBaseFields = "CustNo|ChanceNo|CustName|Price|Project|Power|Advantage|disadvantage|Policy|EmployeeName|CreatDate|ModifiedUserID|ModifiedDate|Remark";
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("销售竞争分析", strBaseFields, "", aBase, aDetail, dtMRP, null, true);
}
#endregion
#region 明细信息
//if (!string.IsNullOrEmpty(strDetailFields))
//{
// tableDetail.InnerHtml = WritePrintPageTable("销售合同", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, false);
//}
#endregion
}
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_ADVERSARY;
AdversaryInfoModel modelMRP = new AdversaryInfoModel();
modelMRP.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
modelMRP.CustNo = this.PlanNo;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
#region 信息的字段
string[,] aBase = {
{ "对手编号", "CustNo"},
{ "对手类别", "CustTypeName"},
{ "对手细分", "CustClassName" },
{ "对手名称", "CustName" },
{ "对手简称", "ShortNam"},
{ "对手拼音代码", "PYShort"},
{ "对手所在区域", "AreaIDName"},
{ "成立时间", "SetupDate"},
{ "法人代表", "ArtiPerson"},
{ "单位性质", "CompanyTypeName"},
{ "员工总数", "StaffCount"},
{ "注册资本(万元)", "SetupMoney"},
{ "注册地址", "SetupAddress"},
{ "公司网址", "website"},
{ "资产规模(万元)", "CapitalScale"},
{ "经营范围", "SellArea"},
{ "年销售额(万元)", "SaleroomY"},
{ "年利润额(万元)", "ProfitY"},
{ "税务登记号", "TaxCD"},
{ "营业执照号", "BusiNumber"},
{ "一般纳税人", "IsTaxName"},
{ "地址", "Address"},
{ "邮编", "Post"},
{ "联系人", "ContactName"},
{ "电话", "Tel"},
{ "手机", "Mobile"},
{ "邮件", "email"},
{ "对手简介", "CustNote"},
{ "主打产品 ", "Product"},
{ "竞争产品/方案", "Project"},
{ "竞争能力", "Power"},
{ "竞争优势", "Advantage"},
{ "竞争劣势", "disadvantage"},
{ "应对策略", "Policy"},
{ "市场占有率(%)", "Market"},
{ "销售模式", "SellMode"},
{ "启用状态", "UsedStatusName"},
{ "制单人", "EmployeeName"},
{ "制单日期", "CreatDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日", "ModifiedDate"},
{ "备注", "Remark"},
};
string[,] aDetail = {
{ "对手动态", "Dynamic"},
};
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtMRP = AdversaryInfoBus.GetRepOrder(PlanNo); //SellContractBus.GetRepOrder(OfferNo);
DataTable dtDetail = AdversaryInfoBus.GetRepOrderDetail(PlanNo);// SellContractBus.GetRepOrderDetail(OfferNo);
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 = "CustNo|CustTypeName|CustClassName|CustName|ShortNam|PYShort|AreaIDName|SetupDate|ArtiPerson|CompanyTypeName|StaffCount|SetupMoney|" +
"SetupAddress|website|CapitalScale|SellArea|SaleroomY|ProfitY|TaxCD|BusiNumber|IsTaxName|Address|Post|ContactName|Tel|Mobile|email|" +
"CustNote|Product|Project|Power|Advantage|disadvantage|Policy|Market|SellMode|UsedStatusName|EmployeeName|CreatDate|ModifiedUserID|" +
"ModifiedDate|Remark";
strDetailFields = "Dynamic";
}
#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
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_CUSTOMER);
model.PrintTypeFlag = ConstUtil.PRINTBILL_CUSTINFOLINK;
CustInfoModel modelMRP = new CustInfoModel();
modelMRP.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
modelMRP.CustNo = this.CustNo;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "{ExtField11}", "ExtField11"},
{ "{ExtField12}", "ExtField12"},
{ "{ExtField13}", "ExtField13"},
{ "{ExtField14}", "ExtField14"},
{ "{ExtField15}", "ExtField15"},
{ "{ExtField16}", "ExtField16"},
{ "{ExtField17}", "ExtField17"},
{ "{ExtField18}", "ExtField18"},
{ "{ExtField19}", "ExtField19"},
{ "{ExtField20}", "ExtField20"},
{ "{ExtField21}", "ExtField21"},
{ "{ExtField22}", "ExtField22"},
{ "{ExtField23}", "ExtField23"},
{ "{ExtField24}", "ExtField24"},
{ "{ExtField25}", "ExtField25"},
{ "{ExtField26}", "ExtField26"},
{ "{ExtField27}", "ExtField27"},
{ "{ExtField28}", "ExtField28"},
{ "{ExtField29}", "ExtField29"},
{ "{ExtField30}", "ExtField30"},
{ "客户编号", "CustNo"},
{ "客户名称", "CustName"},
{ "客户大类", "BigType" },
{ "拼音缩写", "CustShort"},
{ "客户管理分类", "CustTypeManage"},
{ "客户营销分类", "CustTypeSell"},
{ "客户优质级别", "CreditGradeNm"},
{ "客户时间分类", "CustTypeTime"},
{ "客户细分", "CustClassName"},
{ "客户类别", "CustTypaNm"},
{ "建档人", "CreatorName"},
{ "建档日期", "CreatedDate"},
{ "客户简介", "CustNote"},
{ "国家地区", "CountryName"},
{ "区域", "AreaName"},
{ "业务类型", "BusiType"},
{ "分管业务员 ", "ManagerName"},
{ "联络期限(天)", "LinkCycleNm"},
{ "收货地址", "ReceiveAddress"},
{ "允许延期付款", "CreditManage"},
{ "帐期天数(天)", "MaxCreditDate"},
{ "结算方式", "PayTypeNm"},
{ "关系等级", "RelaGrade"},
{ "启用状态", "UsedStatus"},
{ "最后更新用户", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "可查看该客户档案的人员", "CanViewUserName"},
{ "卡号", "CustNum"},
{ "性别", "Sex"},
{ "联系人类型", "LinkTypeName"},
{ "身份证号", "PaperNum"},
{ "生日", "Birthday"},
{ "电话", "WorkTel"},
{ "手机", "Handset"},
{ "传真", "Fax"},
{ "职务", "Position"},
{ "年龄", "Age"},
{ "邮编", "Post"},
{ "Eamil", "MailAddress"},
{ "籍贯", "HomeTown"},
{ "民族", "NationalName"},
{ "所受教育", "CultureLevelName"},
{ "所学专业", "ProfessionalName"},
{ "年收入情况", "IncomeYear"},
{ "饮食偏好", "FuoodDrink"},
{ "喜欢的音乐", "LoveMusic"},
{ "喜欢的颜色", "LoveColor"},
{ "喜欢的香烟", "LoveSmoke"},
{ "爱喝的酒", "LoveDrink"},
{ "爱喝的茶", "LoveTea"},
{ "喜欢的书籍", "LoveBook"},
{ "喜欢的运动", "LoveSport"},
{ "喜欢的品牌服饰", "LoveClothes"},
{ "喜欢的品牌化妆品", "Cosmetic"},
{ "性格描述", "Nature"},
{ "外表描述", "Appearance"},
{ "健康状况", "AdoutBody"},
{ "家人情况", "AboutFamily"},
{ "开什么车", "Car"},
};
string[,] aDetail = { { "", "" } };
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.CustInfo");
if (dtExtTable.Rows.Count > 0)
{
for (int i = 0; i < dtExtTable.Rows.Count; i++)
{
for (int x = 0; x < (aBase.Length / 2) - 59; x++)
{
if (x == i)
{
aBase[x, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
countExt++;
}
}
}
}
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
//DataTable dtMRP = SellContractBus.GetRepOrder(OfferNo);
DataTable dtMRP = CustInfoBus.GetCustInfoByNo(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, CustBig, CustNo);
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 = "CustNo|CustName|BigType|CustShort|CustTypeManage|CustTypeSell|CreditGradeNm|CustTypeTime|CustClassName|CustTypaNm|CreatorName|" +
"CreatedDate|CustNote|CountryName|AreaName|BusiType|ManagerName|LinkCycleNm|ReceiveAddress|CreditManage|MaxCreditDate|PayTypeNm|RelaGrade|" +
"UsedStatus|ModifiedUserID|ModifiedDate|CanViewUserName|CustNum|Sex|LinkTypeName|PaperNum|Birthday|WorkTel|Handset|Fax|Position|Age|Post|" +
"MailAddress|HomeTown|NationalName|CultureLevelName|ProfessionalName|IncomeYear|FuoodDrink|LoveMusic|LoveColor|LoveSmoke|LoveDrink|LoveTea|" +
"LoveBook|LoveSport|LoveClothes|Cosmetic|Nature|Appearance|AdoutBody|AboutFamily|Car";
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
strDetailFields = "";
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("客户档案", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, null, true);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;//UserInfo.CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_SALE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_SELLBACK;
// /*接受参数*/
string BackNo = Request.QueryString["no"].ToString();
#region 基本信息 明细信息
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = { { "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "单据编号", "BackNo"},
{ "主题", "Title"},
{ "源单类型", "FromTypeText" },
{ "源单编号", "SendNo" },
{ "客户名称", "CustName"},
{ "客户电话", "CustTel"},
{ "业务类型", "BusiTypeName"},
{ "结算方式", "PayTypeName"},
{ "支付方式", "MoneyTypeName"},
{ "运送方式", "CarryTypeName"},
{ "币种", "CurrencyName"},
{ "汇率", "Rate"},
{ "业务员", "SellerName"},
{ "部门", "DeptName"},
{ "发货地址", "SendAddress"},
{ "收货地址", "ReceiveAddress"},
{ "退货日期", "BackDate"},
{ "是否增值税", "isAddTaxName"},
{ "所属项目", "ProjectName"},
{ "金额合计", "TotalPrice"},
{ "税额合计", "Tax"},
{ "含税金额合计", "TotalFee"},
{ "整单折扣(%)", "Discount"},
{ "折后含税金额", "RealTotal"},
{ "折扣金额", "DiscountTotal"},
{ "退货数量合计", "CountTotal"},
{ "抵应收货款", "NotPayTotal"},
{ "单据状态", "BillStatusText"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
{ "建单情况", "IsOpenbillText"},
{ "结算状态", "IsAccText"},
{ "已结算金额", "YAccounts"},
{ "入库情况", "IsSendText"},
};
string[,] aDetail;
//多计量单位
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
aDetail=new string[,] {
//{ "序号", "SortNo"},
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "颜色", "ColorName" },
{ "基本单位", "UnitName" },
//{ "交货期限(天)", "SendTime" },
{ "基本数量", "BackNumber"},
{ "单位", "UsedUnitName" },
{ "退货数量", "UsedUnitCount"},
{ "包装要求", "PackageName"},
{ "单价", "UsedPrice"},
{ "含税价", "TaxPrice"},
{ "折扣(%)", "Discount"},
{ "税率(%)", "TaxRate"},
{ "含税金额", "TotalFee"},
{ "金额", "TotalPrice"},
{ "税额", "TotalTax"},
{ "退货原因", "ReasonName"},
{ "备注", "Remark"},
};
}
else
{
aDetail=new string[,] {
//{ "序号", "SortNo"},
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "颜色", "ColorName" },
{ "单位", "UnitName" },
//{ "交货期限(天)", "SendTime" },
{ "退货数量", "BackNumber"},
{ "包装要求", "PackageName"},
{ "单价", "UnitPrice"},
{ "含税价", "TaxPrice"},
{ "折扣(%)", "Discount"},
{ "税率(%)", "TaxRate"},
{ "含税金额", "TotalFee"},
{ "金额", "TotalPrice"},
{ "税额", "TotalTax"},
{ "退货原因", "ReasonName"},
{ "备注", "Remark"},
};
}
///*第二明细*/
//string[,] aSecondDetail = {
// //{ "序号", "SortNo"},
// { "费用类别", "CodeName"},
// { "金额", "FeeTotal" },
// { "备注", "Remark"},
// };
#endregion
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.SellBack");
if (dtExtTable.Rows.Count > 0)
{
for (int i = 0; i < dtExtTable.Rows.Count; i++)
{
for (int x = 0; x < (aBase.Length / 2) - 40; x++)
{
if (x == i)
{
aBase[x, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
countExt++;
}
}
}
}
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtMain = SellBackBus.GetRepOrder(BackNo);//获取主表数据
DataTable dtDetail = SellBackBus.GetRepOrderDetail(BackNo);//获取明细表数据：退货明细数据
//DataTable dtFee = SellOrderBus.GetRepOrderFee(OrderNo);//获取明细表：销售费用明细数据
string strBaseFields = "";
string strDetailFields = "";
///*第二明细*/
//string strDetailSecondFields = "";
if (dbPrint.Rows.Count > 0)
{
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
///*第二明细*/
//strDetailSecondFields = dbPrint.Rows[0]["DetailSecondFields"].ToString();
}
else
{
isSeted.Value = "0";
strBaseFields = "BackNo|Title|FromTypeText|SendNo|CustName|CustTel|BusiTypeName|PayTypeName|MoneyTypeName|CarryTypeName|CurrencyName|Rate|";
strBaseFields = strBaseFields + "SellerName|DeptName|SendAddress|ReceiveAddress|BackDate|isAddTaxName|ProjectName|TotalPrice|Tax|TotalFee|Discount|";
strBaseFields = strBaseFields + "RealTotal|DiscountTotal|CountTotal|NotPayTotal|BillStatusText|CreatorName|CreateDate|ConfirmorName|ConfirmDate|CloserName|CloseDate|ModifiedUserID|ModifiedDate|Remark|";
strBaseFields = strBaseFields + "IsOpenbillText|IsAccText|YAccounts|IsSendText";
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
//多计量单位
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
/*订单明细SortNo|*/
strDetailFields = "ProdNo|ProductName|Specification|ColorName|UnitName|BackNumber|UsedUnitName|UsedUnitCount|PackageName|UsedPrice|TaxPrice|Discount|TaxRate|TotalFee|TotalPrice|TotalTax|ReasonName|Remark";
}
else
{
/*订单明细SortNo|*/
strDetailFields = "ProdNo|ProductName|Specification|ColorName|UnitName|BackNumber|PackageName|UnitPrice|TaxPrice|Discount|TaxRate|TotalFee|TotalPrice|TotalTax|ReasonName|Remark";
}
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
//第一个是打印页面的正标题,strBaseFields是在PrintParameterSetting表里设置的主表字段,
//strDetailFields是在PrintParameterSetting表里设置的明细表的字段,
//aBase,是打印设置页面上定义取出来的字段及对应的名称,
//aDetail是打印设置页面上定义取出来的字段及对应的名称,
//例如明细中的物品编号,对应的就是物品编号及取数据的字段ProdNo,
//dtMRP是主表的数据集,
//dtDetail是明细表的数据集,最后一个参数,用来区别是主表信息还是明细信息..
tableBase.InnerHtml = WritePrintPageTable("销售退货单", strBaseFields, strDetailFields, aBase, aDetail, dtMain, dtDetail, true);
}
#endregion
#region 3.明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("销售退货单", strBaseFields, strDetailFields, aBase, aDetail, dtMain, dtDetail, false);
}
#endregion
///*第二明细*/
//#region 4.明细信息2
//if (!string.IsNullOrEmpty(strDetailSecondFields))
//{
// tableDetail2.InnerHtml = WritePrintPageTable("销售订单", strBaseFields, strDetailSecondFields, aBase, aSecondDetail, dtMain, dtFee, false);
//}
//#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_PURCHASE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_PurchaseAskPrice;
//PurchaseApplyModel modelMRP = new PurchaseApplyModel();
//PurchaseApplyModel.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
//PurchaseApplyModel.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"},
{ "单据编号", "AskNo"},
{ "主题", "AskTitle"},
{ "采购类别", "TypeName" },
{ "供应商", "ProviderName"},
{ "部门", "DeptName" },
{ "询价员", "AskUserName" },
{ "询价日期", "AskDate" },
{ "源单类型", "FromTypeName" },
{ "币种", "CurrencyName" },
{ "询价次数", "AskOrder" },
{ "汇率", "Rate" },
{ "是否为增值税", "ShowName" },
{ "数量总计", "CountTotal"},
{ "金额总计", "TotalPrice"},
{ "税额合计", "TotalTax"},
{ "含税总额总计", "TotalFee"},
{ "整单折扣", "Discount"},
{ "折扣金额", "DiscountTotal"},
{ "折后含税额", "RealTotal"},
{ "单据状态", "BillStatusName"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
};
string[,] aDetail ;
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
aDetail =new string[,] {
{ "物品名称", "ProductName" },
{ "颜色", "ColorName" },
{ "基本数量", "ProductCount"},
{ "交货日期", "RequireDate" },
{ "基本单位", "UnitName"},
{ "单价", "UsedPrice" },
{ "含税价", "TaxPrice" },
{ "单位", "UsedUnitName" },
{ "计划数量", "UsedUnitCount" },
{ "税率", "TaxRate"},
{ "含税金额", "TotalFee"},
{ "税额", "TotalTax"},
{ "规格", "Specification"},
};
}
else
{
aDetail =new string[,] {
{ "物品名称", "ProductName" },
{ "颜色", "ColorName" },
{ "计划数量", "ProductCount"},
{ "交货日期", "RequireDate" },
{ "单位", "UnitName"},
{ "单价", "UnitPrice" },
{ "含税价", "TaxPrice" },
{ "税率", "TaxRate"},
{ "含税金额", "TotalFee"},
{ "税额", "TotalTax"},
{ "规格", "Specification"},
};
}
/*第二明细*/
//string[,] aSecondDetail = {
// };
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba." + ConstUtil.CODING_RULE_TABLE_PURCHASEASKPRICE);
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 = PurchaseAskPriceBus.GetPurAskPricePriByID(this.intMrpID.ToString());
DataTable dtDetail = PurchaseAskPriceBus.GetPurAskPriceDetail(this.intMrpID.ToString());
//DataTable PurchaseApplyPrimary = PurchaseApplyBus.GetPurchaseApply(ID);
//DataTable PurchaseApplySource = PurchaseApplyBus.GetPurchaseApplySource(ID);
// DataTable PurchaseApplyDetail2 = PurchasePlanBus.GetPurchasePlanDetail(this.intMrpID.ToString());
string strBaseFields = "";
string strDetailFields = "";
/*第二明细*/
string strDetailSecondFields = "";
if (dbPrint.Rows.Count > 0)
{
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
/*第二明细*/
strDetailSecondFields = dbPrint.Rows[0]["DetailSecondFields"].ToString();
}
else
{
isSeted.Value = "0";
strBaseFields = "AskNo|AskTitle|TypeName|ProviderName|ShowName|TotalTax|DeptName|AskUserName|AskDate|TotalFee|CurrencyName|AskOrder|Rate|FromTypeName|CountTotal|TotalPrice|CreatorName|CreateDate|BillStatusName|ConfirmorName|ConfirmDate|CloserName|CloseDate|ModifiedUserID|ModifiedDate|Remark|Discount|DiscountTotal|RealTotal";
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
strDetailFields = "ProductName|ColorName|ProductCount|RequireDate|UsedPrice|UnitName|UsedUnitName|UsedUnitCount|TaxPrice|TotalTax|TaxRate|TotalFee";
/*第二明细*/
strDetailSecondFields = "ProductName|ColorName|ProductCount|RequireDate|TotalTax|ProductCount|RequireDate|UsedPrice|UsedUnitName|UsedUnitCount|TotalPrice|OrderCount|UnitName|TaxPrice|Specification";
}
else{
strDetailFields = "ProductName|ColorName|ProductCount|RequireDate|UnitPrice|UnitName|TaxPrice|TotalTax|TaxRate|TotalFee";
/*第二明细*/
strDetailSecondFields = "ProductName|ColorName|ProductCount|RequireDate|TotalTax|ProductCount|RequireDate|UnitPrice|TotalPrice|OrderCount|UnitName|TaxPrice|Specification";
}
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("采购询价", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, true);
}
#endregion
#region 3.明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("采购询价", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, false);
}
#endregion
/*第二明细*/
#region 4.明细信息2
//if (!string.IsNullOrEmpty(strDetailSecondFields))
//{
// tableDetail2.InnerHtml = WritePrintPageTable("采购询价", strBaseFields, strDetailSecondFields, aBase, aSecondDetail, dtMRP, PurchaseApplyDetail2, false);
//}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_STORAGE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_STORAGECHECK;
StorageCheck StorageCheckM_ = new StorageCheck();
StorageCheckM_.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
StorageCheckM_.ID = this.intMrpID;
StorageCheckM_.CheckNo = hidno.Value.ToString();
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aDetail;
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "盘点单编号", "CheckNo"},
{ "盘点单主题", "Title"},
{ "盘点仓库", "StorageName" },
{ "盘点类型", "CheckTypeName" },
{ "盘点部门", "DeptName"},
{ "盘点开始日期", "CheckStartDate"},
{ "盘点结束日期", "CheckEndDate"},
{ "库存调整人", "CheckUserName"},
{ "经办人", "TransactorName"},
{ "库存调整日期", "CheckDate"},
{ "现有存量合计", "NowCount"},
{ "实盘量合计", "CheckCount"},
{ "差异量合计", "DiffCount"},
{ "现存金额", "NowMoney"},
{ "实盘金额", "CheckMoney"},
{ "差异金额", "DiffMoney"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "单据状态", "BillStatusName"},
{ "备注", "Remark"},
{ "摘要", "Summary"},
};
if (HiddenMoreUnit.Value == "True")
{
aDetail = new string[,]{
{ "序号", "SortNo"},
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName" },
{ "批次", "BatchNo" },
{ "规格", "Specification" },
{ "基本单位", "UnitName" },
{ "基本数量", "CheckCount" },
{ "单位", "UsedUnitName"},
{ "成本单价", "UsedPrice"},
{ "现存数量", "NowCount"},
{ "实盘数量", "UsedUnitCount"},
{ "盈亏类型", "DiffTypeName"},
{ "差异量", "DiffCount"},
{ "备注", "Remark"},
};
}
else
{
aDetail = new string[,]{
{ "序号", "SortNo"},
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName" },
{ "批次", "BatchNo" },
{ "规格", "Specification" },
{ "单位", "UnitName"},
{ "成本单价", "StandardCost"},
{ "现存数量", "NowCount"},
{ "实盘数量", "CheckCount"},
{ "盈亏类型", "DiffTypeName"},
{ "差异量", "DiffCount"},
{ "备注", "Remark"},
};
}
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.StorageCheck");
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 dtMain = StorageCheckBus.StorageCheckGet(StorageCheckM_);
DataTable dtDetail = StorageCheckBus.GetStorageCheckDetail(StorageCheckM_);
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
{
#region 未设置过打印模板设置 默认显示所有的
isSeted.Value = "0";
/*未设置过打印模板设置时，默认显示的字段 基本信息字段*/
for (int m = 10; m < aBase.Length / 2; m++)
{
strBaseFields = strBaseFields + aBase[m, 1] + "|";
}
/*未设置过打印模板设置时，默认显示的字段 基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "ExtField" + (i + 1) + "|";
}
}
/*未设置过打印模板设置时，默认显示的字段 明细信息字段*/
for (int n = 0; n < aDetail.Length / 2; n++)
{
strDetailFields = strDetailFields + aDetail[n, 1] + "|";
}
#endregion
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("期末盘点单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMain, dtDetail, true);
}
#endregion
#region 明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("期末盘点单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMain, dtDetail, false);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = UserInfo.CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_PURCHASE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_PurchaseArrive;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
Dictionary<string, string> dic = new Dictionary<string, string>();
dic.Add("ExtField1", "{ExtField1}");
dic.Add("ExtField2", "{ExtField2}");
dic.Add("ExtField3", "{ExtField3}");
dic.Add("ExtField4", "{ExtField4}");
dic.Add("ExtField5", "{ExtField5}");
dic.Add("ExtField6", "{ExtField6}");
dic.Add("ExtField7", "{ExtField7}");
dic.Add("ExtField8", "{ExtField8}");
dic.Add("ExtField9", "{ExtField9}");
dic.Add("ExtField10", "{ExtField10}");
dic.Add("ArriveNo", "单据编号");
dic.Add("Title", "主题");
dic.Add("TypeIDName", "采购类别");
dic.Add("ProviderName", "供应商");
dic.Add("DeptName", "部门");
dic.Add("CheckUserName", "点收人");
dic.Add("PurchaserName", "采购员");
dic.Add("CheckDate", "点收日期");
dic.Add("FromTypeName", "源单类型");
dic.Add("MoneyTypeName", "支付方式");
dic.Add("SendAddress", "发货地址");
dic.Add("ReceiveOverAddress", "收货地址");
dic.Add("isAddTaxName", "是否为增值税");
dic.Add("TakeTypeName", "交货方式");
dic.Add("CarryTypeName", "运送方式");
dic.Add("PayTypeName", "结算方式");
dic.Add("CurrencyTypeName", "币种");
dic.Add("Rate", "汇率");
dic.Add("ArriveDate", "到货时间");
dic.Add("ProjectName", "所属项目");
dic.Add("CountTotal", "数量总计");
if (UserInfo.IsDisplayPrice)
{// 出入库显示单价
dic.Add("TotalMoney", "金额总计");
dic.Add("TotalTax", "税额合计");
dic.Add("TotalFee", "含税总额总计");
dic.Add("Discount", "整单折扣");
dic.Add("DiscountTotal", "折扣金额");
dic.Add("RealTotal", "折后含税额");
dic.Add("OtherTotal", "其他费用支出合计");
}
dic.Add("BillStatusName", "单据状态");
dic.Add("CreatorName", "制单人");
dic.Add("CreateDate", "制单日期");
dic.Add("ConfirmorName", "确认人");
dic.Add("ConfirmDate", "确认日期");
dic.Add("CloserName", "结单人");
dic.Add("CloseDate", "结单日期");
dic.Add("ModifiedUserID", "最后更新人");
dic.Add("ModifiedDate", "最后更新日期");
dic.Add("Remark", "备注");
string[,] aBase = ConvertDictionaryToString(dic, out _sbase);
dic.Clear();
dic.Add("SortNo", "序号");
dic.Add("ProductNo", "物品编号");
dic.Add("ProductName", "物品名称");
dic.Add("Specification", "规格");
dic.Add("ColorName", "颜色");
if (_isMoreUnit)
{// 启用多计量单位
dic.Add("UnitName", "基本单位");
dic.Add("ProductCount", "基本数量");
dic.Add("UsedUnitName", "单位");
dic.Add("UsedUnitCount", "到货数量");
}
else
{
dic.Add("UnitName", "单位");
dic.Add("ProductCount", "到货数量");
}
if (UserInfo.IsDisplayPrice)
{// 出入库显示单价
dic.Add("TotalPrice", "金额");
dic.Add("UnitPrice", "单价");
dic.Add("TaxPrice", "含税价");
dic.Add("TaxRate", "税率");
dic.Add("TotalFee", "含税金额");
dic.Add("TotalTax", "税额");
}
string[,] aDetail = ConvertDictionaryToString(dic, out _sdetail);
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = TableExtFieldsBus.GetAllList(UserInfo.CompanyCD, "", "officedba." + ConstUtil.CODING_RULE_TABLE_PURCHASEARRIVE);
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 = PurchaseArriveBus.SelectArrive(this.intMrpID);
DataTable dtDetail = PurchaseArriveBus.Details(this.intMrpID);
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 = GetDefaultFields(aBase);
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
strDetailFields = GetDefaultFields(aDetail);
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("采购到货", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, true);
}
#endregion
#region 3.明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("采购到货", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, false);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;//UserInfo.CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_SALE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_SELLSEND;
// /*接受参数*/
string SendNo = Request.QueryString["no"].ToString();
#region 基本信息 明细信息
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = { { "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "单据编号", "SendNo"},
{ "主题", "Title"},
{ "源单类型", "FromTypeText" },
{ "源单编号", "OrderNo" },
{ "客户名称", "CustName"},
{ "业务类型", "BusiTypeName"},
{ "销售类别", "SellTypeName"},
{ "结算方式", "PayTypeName"},
{ "支付方式", "MoneyTypeName"},
{ "交货方式", "TakeTypeName"},
{ "运送方式", "CarryTypeName"},
{ "币种", "CurrencyName"},
{ "汇率", "Rate"},
{ "业务员", "SellerName"},
{ "部门", "DeptName"},
{ "收货人姓名", "Receiver"},
{ "发货人", "SenderName"},
{ "预计发货时间", "IntendSendDate"},
{ "发货地址", "SendAddr"},
{ "收货地址", "ReceiveAddr"},
{ "收货人电话", "Tel"},
{ "收货人移动电话", "Modile"},
{ "收货人邮编", "Post"},
{ "是否增值税", "isAddTaxName"},
{ "所属项目", "ProjectName"},
{ "可查看人员", "CanViewUserName"},
{ "金额合计", "TotalPrice"},
{ "税额合计", "Tax"},
{ "含税金额合计", "TotalFee"},
{ "整单折扣(%)", "Discount"},
{ "折扣含税金额", "RealTotal"},
{ "折扣合计", "DiscountTotal"},
{ "发货数量合计", "CountTotal"},
{ "单据状态", "BillStatusText"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
{ "包装运输说明", "PackTransit"},
{ "付款说明", "PayRemark"},
{ "交付说明", "DeliverRemark"},
{ "运输商", "TransporterName"},
{ "运费合计", "TransportFee"},
{ "运费结算方式", "TransPayTypeName"},
};
string[,] aDetail;
//多计量单位
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
aDetail=new string[,] {
//{ "序号", "SortNo"},
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "颜色", "ColorName" },
{ "基本单位", "UnitName" },
{ "基本数量", "ProductCount"},
{ "单位", "UsedUnitName" },
{ "数量", "UsedUnitCount"},
{ "发货日期", "SendDate" },
{ "包装要求", "PackageName"},
{ "单价", "UsedPrice"},
{ "含税价", "TaxPrice"},
{ "折扣(%)", "Discount"},
{ "税率(%)", "TaxRate"},
{ "含税金额", "TotalFee"},
{ "金额", "TotalPrice"},
{ "税额", "TotalTax"},
{ "备注", "Remark"},
};
}
else
{
aDetail=new string[,] {
//{ "序号", "SortNo"},
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "颜色", "ColorName" },
{ "单位", "UnitName" },
{ "数量", "ProductCount"},
{ "发货日期", "SendDate" },
{ "包装要求", "PackageName"},
{ "单价", "UnitPrice"},
{ "含税价", "TaxPrice"},
{ "折扣(%)", "Discount"},
{ "税率(%)", "TaxRate"},
{ "含税金额", "TotalFee"},
{ "金额", "TotalPrice"},
{ "税额", "TotalTax"},
{ "备注", "Remark"},
};
}
#endregion
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.SellSend");
if (dtExtTable.Rows.Count > 0)
{
for (int i = 0; i < dtExtTable.Rows.Count; i++)
{
for (int x = 0; x < (aBase.Length / 2) - 47; x++)
{
if (x == i)
{
aBase[x, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
countExt++;
}
}
}
}
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtMain = SellSendBus.GetRepOrder(SendNo);//获取主表数据
DataTable dtDetail = SellSendBus.GetRepOrderDetail(SendNo);//获取明细表：订单明细数据
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 = "SendNo|Title|FromTypeText|OrderNo|CustName|BusiTypeName|SellTypeName|PayTypeName|MoneyTypeName|TakeTypeName|CarryTypeName|CurrencyName|Rate|";
strBaseFields = strBaseFields + "SellerName|DeptName|Receiver|SenderName|IntendSendDate|SendAddr|ReceiveAddr|Tel|Modile|Post|isAddTaxName|ProjectName|CanViewUserName|TotalPrice|Tax|TotalFee|Discount|";
strBaseFields = strBaseFields + "RealTotal|DiscountTotal|CountTotal|BillStatusText|CreatorName|CreateDate|ConfirmorName|ConfirmDate|CloserName|CloseDate|ModifiedUserID|ModifiedDate|Remark|";
strBaseFields = strBaseFields + "PackTransit|PayRemark|DeliverRemark|TransporterName|TransportFee|TransPayTypeName";
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
//多计量单位
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
/*订单明细SortNo|*/
strDetailFields = "ProdNo|ProductName|Specification|ColorName|UnitName|ProductCount|UsedUnitName|UsedUnitCount|SendDate|PackageName|UsedPrice|TaxPrice|Discount|TaxRate|TotalFee|TotalPrice|TotalTax|Remark";
}
else
{
/*订单明细SortNo|*/
strDetailFields = "ProdNo|ProductName|Specification|ColorName|UnitName|ProductCount|SendDate|PackageName|UnitPrice|TaxPrice|Discount|TaxRate|TotalFee|TotalPrice|TotalTax|Remark";
}
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
//第一个是打印页面的正标题,strBaseFields是在PrintParameterSetting表里设置的主表字段,
//strDetailFields是在PrintParameterSetting表里设置的明细表的字段,
//aBase,是打印设置页面上定义取出来的字段及对应的名称,
//aDetail是打印设置页面上定义取出来的字段及对应的名称,
//例如明细中的物品编号,对应的就是物品编号及取数据的字段ProdNo,
//dtMRP是主表的数据集,
//dtDetail是明细表的数据集,最后一个参数,用来区别是主表信息还是明细信息..
tableBase.InnerHtml = WritePrintPageTable("销售发货单", strBaseFields, strDetailFields, aBase, aDetail, dtMain, dtDetail, true);
}
#endregion
#region 3.明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("销售发货单", strBaseFields, strDetailFields, aBase, aDetail, dtMain, dtDetail, false);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel pModel = new PrintParameterSettingModel();
pModel.CompanyCD = UserInfo.CompanyCD;
pModel.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_SUBSTORAGE);
pModel.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_SUBSELLBACK;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "单据编号", "BackNo"},
{ "单据主题", "Title"},
{ "销售分店", "DeptName" },
{ "源单类型", "FromType" },
{ "对应分店销售订单", "OrderID" },
{ "发货模式", "SendModeName" },
{ "发货时间", "OutDate"},
{ "发货人", "OutUserIDName"},
{ "是否增值税", "isAddTax"},
{ "客户名称", "CustName"},
{ "客户联系电话", "CustTel"},
{ "客户手机号", "CustMobile"},
{ "币种", "CurrencyTypeName"},
{ "汇率", "Rate"},
{ "业务状态", "BusiStatusName"},
{ "退货时间", "BackDate"},
{ "退货处理人", "SellerName"},
{ "入库时间", "InDate"},
{ "入库人", "InUserIDName"},
{ "结算时间", "SttlDate"},
{ "结算人", "SttlUserIDName"},
{ "客户地址", "CustAddr"},
{ "退货理由描述", "BackReason"},
{ "退货数量合计", "CountTotal"},
{ "金额合计", "TotalPrice"},
{ "税额合计", "Tax"},
{ "含税金额合计", "TotalFee"},
{ "整单折扣(%)", "Discount"},
{ "折扣金额合计", "DiscountTotal"},
{ "折后含税金额", "RealTotal"},
{ "应退货款", "WairPayTotal"},
{ "已退货款", "PayedTotal"},
{ "应退货款余额", "WairPayTotalOverage"},
{ "单据状态", "BillStatusName"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
};
string[,] aDetail = {
{ "序号", "SortNo"},
{ "产品编号", "ProductNo"},
{ "产品名称", "ProductName"},
{ "批次", "BatchNo"},
{ "规格", "standard"},
{ "单位", "UnitName"},
{ "发货数量", "ProductCount"},
{ "退货数量", "BackCount"},
{ "单价", "UnitPrice"},
{ "含税价", "TaxPrice"},
{ "折扣", "Discount"},
{ "税率", "TaxRate"},
{ "金额", "TotalPrice"},
{ "含税金额", "TotalFee"},
{ "仓库", "StorageName"},
{ "备注", "Remark"}
};
if (_isMoreUnit)
{// 启用多计量单位
aDetail = new string[,]
{
{ "序号", "SortNo"},
{ "产品编号", "ProductNo"},
{ "产品名称", "ProductName"},
{ "批次", "BatchNo"},
{ "规格", "standard"},
{ "基本单位", "UnitName" },
{ "基本数量", "BackCount"},
{ "单位", "UsedUnitName"},
{ "发货数量", "ProductCount"},
{ "退货数量", "UsedUnitCount"},
{ "单价", "UnitPrice"},
{ "含税价", "TaxPrice"},
{ "折扣", "Discount"},
{ "税率", "TaxRate"},
{ "金额", "TotalPrice"},
{ "含税金额", "TotalFee"},
{ "仓库", "StorageName"},
{ "备注", "Remark"}
};
}
#region 扩展属性
DataTable dtExtTable = TableExtFieldsBus.GetAllList(UserInfo.CompanyCD, "", "officedba.SubSellBack");
int countExt = 0;
for (int i = 0; i < dtExtTable.Rows.Count; i++)
{
aBase[i, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
countExt++;
}
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(pModel);
DataTable dt = SubSellBackBus.SubSellBack(intID);
ConvertDataTable(dt);
DataTable dtDetail = SubSellBackBus.Details(intID);
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 = GetDefaultFields(aBase);
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields += "|ExtField" + (i + 1);
}
}
strDetailFields = GetDefaultFields(aDetail);
}
#region 主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("销售退货单", strBaseFields, strDetailFields, aBase, aDetail, dt, dtDetail, true);
}
#endregion
#region 明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("销售退货单", strBaseFields, strDetailFields, aBase, aDetail, dt, dtDetail, false);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_STORAGE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_SubDayEnd;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "日结日期", "DailyDate"},
{ "分店", "DeptName"},
{ "品名", "ProductName" },
{ "批次", "BatchNo"},
{ "物品编号", "ProductNo" },
{ "入库总数量 ", "InTotal" },
{ "出库总数量", "OutTotal" },
{ "当日结存量", "TodayCount" },
{ "当日销售金额", "SaleFee" },
{ "当日销售退货金额", "SaleBackFee" },
{ "配送退货出库数量", "SendOutCount" },
{ "期初库存录入数量", "InitInCount" },
{ "配送入库数量", "SendInCount" },
{ "门店调拨入库数量", "DispInCont" },
{ "门店调拨出库数量", "DispOutCount" },
{ "销售出库数量(总店发货模式)", "SaleOutCount" },
{ "销售退货入库数量(总店发货模式)", "SaleBackInCount" },
{ "销售退货入库数量(分店发货模式)", "SubSaleBackInCount" },
{ "销售出库数量(分店发货模式)", "SubSaleOutCount" },
{ "操作人", "CreatorName"},
{ "操作日期", "CreateDate"},
};
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtMRP = SubDayEndBus.GetSubStorageDailyInfo(Convert.ToString(this.intMrpID), this.BatchNo, Convert.ToString(this.DeptID ), this.DailyDate, model.CompanyCD);
string strBaseFields = "";
/*第二明细*/
if (dbPrint.Rows.Count > 0)
{
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
}
else
{
isSeted.Value = "0";
strBaseFields = "DailyDate|DeptName|ProductName|BatchNo|ProductNo|InTotal|OutTotal|TodayCount|SaleFee|SaleBackFee|SendOutCount|InitInCount|SendInCount|DispInCont|DispOutCount|SaleOutCount|SaleBackInCount|SubSaleBackInCount|SubSaleOutCount|CreatorName|CreateDate";
}
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("门店日结明细", strBaseFields, null, aBase, null, dtMRP, null, true);
}
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = UserInfo.CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_PURCHASE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_PurchaseReject;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "单据编号", "RejectNo"},
{ "主题", "Title"},
{ "采购类别", "TypeName" },
{ "供应商", "ProviderName"},
{ "部门", "DeptName" },
{ "采购员", "PurchaserName" },
{ "是否建单", "isOpenbillName" },
{ "收货人", "ReceiveMan" },
{ "收货人联系电话", "ReceiveTel" },
{ "源单类型", "FromTypeName" },
{ "支付方式", "MoneyTypeName" },
{ "发货地址", "SendAddress" },
{ "收货地址", "ReceiveOverAddress" },
{ "是否为增值税", "isAddTaxName" },
{ "交货方式", "TakeTypeName" },
{ "运送方式", "CarryTypeName" },
{ "结算方式", "PayTypeName" },
{ "币种", "CurrencyTypeName" },
{ "汇率", "Rate" },
{ "退货时间", "RejectDate" },
{ "所属项目", "ProjectName" },
{ "数量总计", "CountTotal"},
{ "金额总计", "TotalPrice"},
{ "税额合计", "TotalTax"},
{ "含税总额总计", "TotalFee"},
{ "整单折扣", "Discount"},
{ "折扣金额", "DiscountTotal"},
{ "折后含税额", "RealTotal"},
{ "抵应付帐款", "TotalDyfzk"},
{ "应退货款合计", "TotalYthkhj"},
{ "单据状态", "BillStatusName"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
};
string[,] aDetail = {
{ "序号", "SortNo" },
{ "物品编号", "ProductNo" },
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "颜色", "ColorName" },
{ "单位", "UnitName"},
{ "退货数量", "BackCount"},
{ "金额", "TotalPrice"},
{ "单价", "UnitPrice" },
{ "含税价", "TaxPrice" },
{ "税率", "TaxRate"},
{ "含税金额", "TotalFee"},
{ "税额", "TotalTax"},
};
if (_isMoreUnit)
{// 启用多计量单位
aDetail = new string[,]
{
{ "序号", "SortNo" },
{ "物品编号", "ProductNo" },
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "颜色", "ColorName" },
{ "基本单位", "UnitName" },
{ "基本数量", "BackCount"},
{ "单位", "UsedUnitName"},
{ "退货数量", "UsedUnitCount"},
{ "金额", "TotalPrice"},
{ "单价", "UnitPrice" },
{ "含税价", "TaxPrice" },
{ "税率", "TaxRate"},
{ "含税金额", "TotalFee"},
{ "税额", "TotalTax"},
};
}
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = TableExtFieldsBus.GetAllList(UserInfo.CompanyCD, "", "officedba." + ConstUtil.CODING_RULE_TABLE_PURCHASEREJECT);
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 = PurchaseRejectBus.SelectReject(this.intMrpID);
string formType = string.Empty;
if (dtMRP != null)
{
if (dtMRP.Rows.Count > 0)
{
formType = dtMRP.Rows[0]["FromType"] == null ? "" : dtMRP.Rows[0]["FromType"].ToString();
}
}
DataTable dtDetail = PurchaseRejectBus.Details(this.intMrpID, formType);
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 = GetDefaultFields(aBase);
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
strDetailFields = GetDefaultFields(aDetail);
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("采购退货", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, true);
}
#endregion
#region 3.明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("采购退货", strBaseFields, strDetailFields, aBase, aDetail, dtMRP, dtDetail, false);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_STORAGE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_ADJUST;
StorageInitailModel OutSellM_ = new StorageInitailModel();
OutSellM_.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
OutSellM_.ID = this.intMrpID.ToString();
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aDetail;
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "单据编号", "AdjustNo"},
{ "单据标题", "Title"},
{ "经办人", "Executor" },
{ "调整部门", "DeptID" },
{ "调整仓库", "StorageID"},
{ "调整原因", "ReasonType"},
{ "调整日期 ", "AdjustDate"},
{ "摘要", "Summary"},
{ "调整数量合计 ", "CountTotal"},
{ "调整金额合计 ", "TotalPrice"},
{ "制单人", "Creator"},
{ "制单日期", "CreateDate"},
{ "单据状态", "BillStatus"},
{ "确认人", "Confirmor"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "Closer"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "备注", "Remark"},
};
if (HiddenMoreUnit.Value == "True")
{
aDetail = new string[,]{
{ "物品编号", "ID"},
{ "物品名称", "ProductID" },
{ "批次", "BatchNo" },
{ "单位", "UsedUnitName"},
{ "基本单位", "UnitID" },
{ "基本数量", "AdjustCount" },
{ "调整类型", "AdjustType"},
{ "调整数量 ", "UsedUnitCount"},
{ "成本单价 ", "UsedPrice"},
{ "调整金额 ", "CostPriceTotal"},
{ "备注 ", "Remark"},
};
}
else
{
aDetail = new string[,]{
{ "物品编号", "ID"},
{ "物品名称", "ProductID" },
{ "批次", "BatchNo" },
{ "单位", "UnitID"},
{ "调整类型", "AdjustType"},
{ "调整数量 ", "AdjustCount"},
{ "成本单价 ", "CostPrice"},
{ "调整金额 ", "CostPriceTotal"},
{ "备注 ", "Remark"},
};
}
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = XBase.Business.Office.SupplyChain.TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.StorageAdjust");
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 = XBase.Business.Office.StorageManager.StorageAdjustBus.GetAdjustInfo(intMrpID);
DataTable dtDetail = XBase.Business.Office.StorageManager.StorageAdjustBus.GetAdjustDetailInfo(intMrpID);
string strBaseFields = "";
string strDetailFields = "";
if (dbPrint.Rows.Count > 0)
{
#region 设置过打印模板设置时 直接取出表里设置的值
isSeted.Value = "1";
strBaseFields = dbPrint.Rows[0]["BaseFields"].ToString();
strDetailFields = dbPrint.Rows[0]["DetailFields"].ToString();
#endregion
}
else
{
#region 未设置过打印模板设置 默认显示所有的
isSeted.Value = "0";
/*未设置过打印模板设置时，默认显示的字段 基本信息字段*/
for (int m = 10; m < aBase.Length / 2; m++)
{
strBaseFields = strBaseFields + aBase[m, 1] + "|";
}
/*未设置过打印模板设置时，默认显示的字段 基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "ExtField" + (i + 1) + "|";
}
}
/*未设置过打印模板设置时，默认显示的字段 明细信息字段*/
for (int n = 0; n < aDetail.Length / 2; n++)
{
strDetailFields = strDetailFields + aDetail[n, 1] + "|";
}
#endregion
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
tableBase.InnerHtml = WritePrintPageTable("日常调整单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMRP, dtDetail, true);
}
#endregion
#region 3.明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("日常调整单", strBaseFields.TrimEnd('|'), strDetailFields.TrimEnd('|'), aBase, aDetail, dtMRP, dtDetail, false);
}
#endregion
}
protected void LoadPrintInfo()
{
PrintParameterSettingModel model = new PrintParameterSettingModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;//UserInfo.CompanyCD;
model.BillTypeFlag = int.Parse(ConstUtil.BILL_TYPEFLAG_SALE);
model.PrintTypeFlag = ConstUtil.PRINTBILL_TYPEFLAG_SELLCHANNELSTTL;
// /*接受参数*/
string SttlNo = Request.QueryString["no"].ToString();
#region 基本信息 明细信息
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = { { "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "单据编号", "SttlNo"},
{ "主题", "Title"},
{ "源单类型", "FromTypeText" },
{ "源单编号", "SendNo" },
{ "客户名称", "CustName"},
{ "客户电话", "Tel"},
{ "结算方式", "PayTypeName"},
{ "支付方式", "MoneyTypeName"},
{ "币种", "CurrencyName"},
{ "汇率", "Rate"},
{ "业务员", "SellerName"},
{ "部门", "DeptName"},
{ "结算日期", "SttlDate"},
{ "代销金额", "TotalFee"},
{ "代销提成率(%)", "PushMoneyPercent"},
{ "代销提成额", "PushMoney"},
{ "手续费合计", "HandFeeTotal"},
{ "应结算金额合计", "SttlTotal"},
{ "代销数量合计", "CountTotal"},
{ "单据状态", "BillStatusText"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期", "ModifiedDate"},
{ "建单情况", "IsOpenbillText"},
{ "回款状态", "IsAccText"},
{ "已回款金额", "YAccounts"},
};
string[,] aDetail;
//多计量单位
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
aDetail=new string[,] {
//{ "序号", "SortNo"},
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "基本单位", "UnitName" },
{ "基本数量", "SttlNumber"},
{ "单位", "UsedUnitName" },
{ "代销数量", "ProductCount"},
{ "已结算数量", "SttlCount" },
{ "本次结算数量", "UsedUnitCount"},
{ "单价", "UsedPrice"},
{ "本次结算代销金额", "TotalPrice"},
{ "备注", "Remark"},
};
}
else
{
aDetail=new string[,] {
//{ "序号", "SortNo"},
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName" },
{ "规格", "Specification" },
{ "单位", "UnitName" },
{ "代销数量", "ProductCount"},
{ "已结算数量", "SttlCount" },
{ "本次结算数量", "SttlNumber"},
{ "单价", "UnitPrice"},
{ "本次结算代销金额", "TotalPrice"},
{ "备注", "Remark"},
};
}
#endregion
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.SellChannelSttl");
if (dtExtTable.Rows.Count > 0)
{
for (int i = 0; i < dtExtTable.Rows.Count; i++)
{
for (int x = 0; x < (aBase.Length / 2) - 31; x++)
{
if (x == i)
{
aBase[x, 0] = dtExtTable.Rows[i]["EFDesc"].ToString();
countExt++;
}
}
}
}
#endregion
DataTable dbPrint = XBase.Business.Common.PrintParameterSettingBus.GetPrintParameterSettingInfo(model);
DataTable dtMain = SellChannelSttlBus.GetRepOrder(SttlNo);//获取主表数据
DataTable dtDetail = SellChannelSttlBus.GetRepOrderDetail(SttlNo);//获取明细表数据
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 = "SttlNo|Title|FromTypeText|SendNo|CustName|Tel|PayTypeName|MoneyTypeName|CurrencyName|Rate|";
strBaseFields = strBaseFields + "SellerName|DeptName|SttlDate|TotalFee|PushMoneyPercent|PushMoney|HandFeeTotal|SttlTotal|CountTotal|";
strBaseFields = strBaseFields + "BillStatusText|CreatorName|CreateDate|ConfirmorName|ConfirmDate|CloserName|CloseDate|ModifiedUserID|ModifiedDate|Remark|";
strBaseFields = strBaseFields + "IsOpenbillText|IsAccText|YAccounts";
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
//多计量单位
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
/*订单明细SortNo|*/
strDetailFields = "ProdNo|ProductName|Specification|UnitName|ProductCount|UsedUnitName|UsedUnitCount|SttlCount|SttlNumber|UsedPrice|TotalPrice|Remark";
}
else
{
/*订单明细SortNo|*/
strDetailFields = "ProdNo|ProductName|Specification|UnitName|ProductCount|SttlCount|SttlNumber|UnitPrice|TotalPrice|Remark";
}
}
#region 2.主表信息
if (!string.IsNullOrEmpty(strBaseFields))
{
//第一个是打印页面的正标题,strBaseFields是在PrintParameterSetting表里设置的主表字段,
//strDetailFields是在PrintParameterSetting表里设置的明细表的字段,
//aBase,是打印设置页面上定义取出来的字段及对应的名称,
//aDetail是打印设置页面上定义取出来的字段及对应的名称,
//例如明细中的物品编号,对应的就是物品编号及取数据的字段ProdNo,
//dtMRP是主表的数据集,
//dtDetail是明细表的数据集,最后一个参数,用来区别是主表信息还是明细信息..
tableBase.InnerHtml = WritePrintPageTable("委托代销结算单", strBaseFields, strDetailFields, aBase, aDetail, dtMain, dtDetail, true);
}
#endregion
#region 3.明细信息
if (!string.IsNullOrEmpty(strDetailFields))
{
tableDetail.InnerHtml = WritePrintPageTable("委托代销结算单", strBaseFields, strDetailFields, aBase, aDetail, dtMain, dtDetail, false);
}
#endregion
}
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_SELLCONTRANCT;
SellOfferModel modelMRP = new SellOfferModel();
modelMRP.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
modelMRP.OfferNo = this.OfferNo;
/*此处需注意在模板设置表里的字段和取基本信息的字段是否一致*/
string[,] aBase = {
{ "{ExtField1}", "ExtField1"},
{ "{ExtField2}", "ExtField2"},
{ "{ExtField3}", "ExtField3"},
{ "{ExtField4}", "ExtField4"},
{ "{ExtField5}", "ExtField5"},
{ "{ExtField6}", "ExtField6"},
{ "{ExtField7}", "ExtField7"},
{ "{ExtField8}", "ExtField8"},
{ "{ExtField9}", "ExtField9"},
{ "{ExtField10}", "ExtField10"},
{ "单据编号", "ContractNo"},
{ "主题", "Title"},
{ "源单类型", "FromTypeText" },
{ "源单编号", "OfferNo" },
{ "客户名称", "CustName"},
{ "客户电话", "CustTel"},
{ "业务类型", "BusiTypeName"},
{ "销售类别", "SellTypeName"},
{ "结算方式", "PayTypeName"},
{ "支付方式", "MoneyTypeName"},
{ "交货方式", "TakeTypeName"},
{ "运送方式", "CarryTypeName"},
{ "币种", "CurrencyName"},
{ "汇率", "Rate"},
{ "业务员", "SellerName"},
{ "部门", "DeptName"},
{ "客户方代表", "TheyDelegate"},
{ "我方代表", "OurDelegateName"},
{ "签约时间", "SignDate"},
{ "签约地点", "SignAddr"},
{ "开始日期 ", "StartDate"},
{ "截止日期", "EndDate"},
{ "洽谈进展", "TalkProcess"},
{ "合同状态", "stateText"},
{ "终止原因", "EndNote"},
{ "是否增值税", "isAddTaxName"},
//{ "是否被引用 ", "RealTotal"},
{ "金额合计", "TotalPrice"},
{ "税额合计", "Tax"},
{ "含税金额合计", "TotalFee"},
{ "整单折扣(%) ", "Discount"},
{ "折后含税金额", "RealTotal"},
{ "折扣金额合计", "DiscountTotal"},
{ "合同数量合计", "CountTotal"},
{ "单据状态", "BillStatusText"},
{ "制单人", "CreatorName"},
{ "制单日期", "CreateDate"},
{ "确认人", "ConfirmorName"},
{ "确认日期", "ConfirmDate"},
{ "结单人", "CloserName"},
{ "结单日期", "CloseDate"},
{ "最后更新人", "ModifiedUserID"},
{ "最后更新日期 ", "ModifiedDate"},
{ "备注", "Remark"},
};
string[,] aDetail;
//多计量单位
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
aDetail = new string[,]{
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName"},
{ "规格", "Specification"},
{ "基本单位", "CodeName" },
{ "基本数量", "ProductCount"},
{ "单位", "UsedUnitName" },
{ "数量", "UsedUnitCount"},
{ "交货期限(天)", "SendTime" },
{ "包装要求", "TypeName"},
{ "单价", "UsedPrice"},
{ "含税价", "TaxPrice"},
{ "折扣(%)", "Discount"},
{ "税率(%)", "TaxRate"},
{ "含税金额", "TotalFee"},
{ "金额", "TotalPrice"},
{ "税额", "TotalTax"},
{ "备注 ", "Remark"},
};
}
else
{
aDetail = new string[,]{
{ "物品编号", "ProdNo"},
{ "物品名称", "ProductName"},
{ "规格", "Specification"},
{ "单位", "CodeName" },
{ "数量", "ProductCount"},
{ "交货期限(天)", "SendTime" },
{ "包装要求", "TypeName"},
{ "单价", "UnitPrice"},
{ "含税价", "TaxPrice"},
{ "折扣(%)", "Discount"},
{ "税率(%)", "TaxRate"},
{ "含税金额", "TotalFee"},
{ "金额", "TotalPrice"},
{ "税额", "TotalTax"},
{ "备注 ", "Remark"},
};
}
#region 1.扩展属性
int countExt = 0;
DataTable dtExtTable = TableExtFieldsBus.GetAllList(((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD, "", "officedba.SellContract");
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 = SellContractBus.GetRepOrder(OfferNo); //SellOfferBus.GetRepOrder(OfferNo);
DataTable dtDetail = SellContractBus.GetRepOrderDetail(OfferNo); //SellOfferBus.GetRepOrderDetail(OfferNo);
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 = "ContractNo|Title|FromTypeText|OfferNo|CustName|CustTel|BusiTypeName|SellTypeName|PayTypeName|MoneyTypeName|TakeTypeName|CarryTypeName|" +
"CurrencyName|Rate|SellerName|DeptName|TheyDelegate|OurDelegateName|SignDate|SignAddr|StartDate|EndDate|TalkProcess|stateText|EndNote|isAddTaxName|" +
"TotalPrice|Tax|TotalFee|Discount|RealTotal|DiscountTotal|CountTotal|BillStatusText|CreatorName|CreateDate|ConfirmorName|ConfirmDate|CloserName|" +
"CloseDate|ModifiedUserID|ModifiedDate|Remark";
/*基本信息字段+扩展信息字段*/
if (countExt > 0)
{
for (int i = 0; i < countExt; i++)
{
strBaseFields = strBaseFields + "|" + "ExtField" + (i + 1);
}
}
//多计量单位
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsMoreUnit)
{
strDetailFields = "ProdNo|ProductName|Specification|CodeName|ProductCount|UsedUnitName|UsedUnitCount|SendTime|TypeName|UsedPrice|TaxPrice|Discount|" +
"TaxRate|TotalFee|TotalPrice|TotalTax|Remark";
}
else
{
strDetailFields = "ProdNo|ProductName|Specification|CodeName|ProductCount|SendTime|TypeName|UnitPrice|TaxPrice|Discount|" +
"TaxRate|TotalFee|TotalPrice|TotalTax|Remark";
}
}
#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
}
