protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
PurchaseAskPriceModel PurchaseAskPriceM = new PurchaseAskPriceModel();
PurchaseAskPriceM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
PurchaseAskPriceM.AskNo = txtAskNo.Value;
PurchaseAskPriceM.AskTitle = txtAskTitle.Value;
PurchaseAskPriceM.FromType = ddlFromType.Value;
PurchaseAskPriceM.DeptID = hidDeptID.Value;
PurchaseAskPriceM.AskUserID = hidUserID.Value;
PurchaseAskPriceM.BillStatus = ddlBillStatus.Value;
PurchaseAskPriceM.ProviderID = hidProviderID.Value;
PurchaseAskPriceM.FlowStatus = ddlFlowStatus.Value;
PurchaseAskPriceM.AskDate = StartAskDate.Value;
PurchaseAskPriceM.EndAskDate = EndAskDate.Value;
PurchaseAskPriceM.EFDesc = GetBillExAttrControl1.GetExtTxtValue;
PurchaseAskPriceM.EFIndex = GetBillExAttrControl1.GetExtIndexValue;
string OrderBy = hidOrderBy.Value;
DataTable dt = PurchaseAskPriceBus.GetPurchaseAskPrice(PurchaseAskPriceM, OrderBy);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "询价单编号", "询价单主题", "供应商", "询价日期", "询价员", "当前询价次数", "金额合计", "税额合计", "含税金额合计", "单据状态", "审批状态" },
new string[] { "AskNo", "AskTitle", "ProviderName", "AskDate", "AskUserName", "AskOrder", "TotalPrice", "TotalTax", "TotalFee", "BillStatusName", "FlowStatusName" },
"采购询价单列表");
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
StockAccountModel model = new StockAccountModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.ProductNo = txtProductNo.Value;
model.ProductName = txtProductName.Value;
string AlarmType = sltAlarmType.Value;
string BarCode = HiddenBarCode.Value.Trim();
string orderBy = txtorderBy.Value;
if (!string.IsNullOrEmpty(orderBy))
{
if (orderBy.Split('_')[1] == "a")
{
orderBy = orderBy.Split('_')[0] + " asc";
}
else
{
orderBy = orderBy.Split('_')[0] + " desc";
}
}
DataTable dt = StorageProductAlarmBus.GetStorageProductAlarm(AlarmType, model, orderBy, BarCode);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "物品编号", "物品名称", "物品分类", "规格", "单位", "库存下限", "库存上限", "安全库存", "现有存量", "报警类型" },
new string[] { "ProductNo", "ProductName", "TypeID", "Specification", "UnitID", "MinStockNum", "MaxStockNum", "SafeStockNum", "ProductCount", "AlarmType" },
"库存报警列表");
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "LinkDate"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
string CustID = hiddCustID.Value; //客户ID
string CustLinkMan = txtCustLinkMan.Value; //被联络人
string LinkDateBegin = txtLinkDateBegin.Value;
string LinkDateEnd = txtLinkDateEnd.Value;
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();
DataTable dt = ContactHistoryBus.ExportContactInfo(CanUserID, CustID, CustLinkMan, CompanyCD, LinkDateBegin, LinkDateEnd, ord);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "联络单编号", "联络主题", "客户名称", "我方联络人", "联络时间", "客户联络人" },
new string[] { "ContactNo", "Title", "CustNam", "Linker", "LinkDate", "LinkManName" },
"客户联络列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
PurchaseApplyModel PurchaseApplyM = new PurchaseApplyModel();
PurchaseApplyM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
PurchaseApplyM.ApplyNo = txtapplyno.Value;
PurchaseApplyM.Title = txttitle.Value;
PurchaseApplyM.ApplyUserID = hidApplyID.Value;
PurchaseApplyM.ApplyDeptID = hidDeptID.Value;
PurchaseApplyM.TypeID = ddlTypeID.SelectedValue;
PurchaseApplyM.FromType = ddlfromtype.Value;
PurchaseApplyM.StartApplyDate = txtstartapplydate.Value;
PurchaseApplyM.EndApplyDate = txtendapplydate.Value;
PurchaseApplyM.BillStatus = ddlBillStatus.Value;
PurchaseApplyM.FlowStatus = ddlFlowStatus.Value;
PurchaseApplyM.EFIndex = GetBillExAttrControl1.GetExtIndexValue;
PurchaseApplyM.EFDesc = GetBillExAttrControl1.GetExtTxtValue;
string OrderBy = hidOrderBy.Value;
DataTable dt = PurchaseApplyBus.SelectPurchaseApply(PurchaseApplyM, OrderBy);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "申请单编号", "申请单主题", "采购类别", "源单类型", "申请人", "申请部门", "申请时间", "单据状态", "审批状态" },
new string[] { "ApplyNo", "Title", "TypeName", "FromTypeName", "ApplyUserName", "ApplyDeptName", "ApplyDate", "BillStatusName", "FlowStatusName" },
"采购申请列表");
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
PurchaseOrderModel PurchaseOrderM = new PurchaseOrderModel();
PurchaseOrderM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
PurchaseOrderM.OrderNo = txtOrderNo.Value;
PurchaseOrderM.Title = txtOrderTitle.Value;
PurchaseOrderM.TypeID = ddlTypeID.SelectedValue;
PurchaseOrderM.DeptID = hidDeptID.Value;
PurchaseOrderM.Purchaser = hidPurchaseID.Value;
PurchaseOrderM.FromType = ddlFromType.Value;
PurchaseOrderM.ProviderID = hidProviderID.Value;
PurchaseOrderM.BillStatus = ddlBillStatus.Value;
PurchaseOrderM.FlowStatus = ddlFlowStatus.Value;
PurchaseOrderM.ProjectID = this.hidProjectID.Value;
PurchaseOrderM.EFIndex = GetBillExAttrControl1.GetExtIndexValue;
PurchaseOrderM.EFDesc = GetBillExAttrControl1.GetExtTxtValue;
string OrderBy = hidOrderBy.Value;
DataTable dt = PurchaseOrderBus.GetPurchaseOrder(PurchaseOrderM, OrderBy);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "订单编号", "订单主题", "采购类别", "采购员", "供应商", "金额合计", "税额合计", "含税金额合计", "单据状态", "审批状态", "是否已建单" },
new string[] { "OrderNo", "OrderTitle", "TypeName", "PurchaserName", "ProviderName", "TotalPrice", "TotalTax", "TotalFee", "BillStatusName", "FlowStatusName", "isOpenBillName" },
"采购订单列表");
}
//导出
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "desc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ModifiedDate"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "asc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
CustCallModel CustCallM = new CustCallModel();
CustCallM.CustID = hiddCustID.Value == "" ? 0 : Convert.ToInt32(hiddCustID.Value);
CustCallM.Tel = txtTel.Value;
string DateBegin = txtDateBegin.Value.Trim(); //开始时间
string DateEnd = txtDateEnd.Value.Trim(); //结束时间
CustCallM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
DataTable dt = CustCallBus.GetCustCallByCon(CustCallM, DateBegin, DateEnd, ord);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "客户名称", "来电号码", "来电时间", "来电标题", "来电人", "创建人" },
new string[] { "CustName", "Tel", "CallTime", "Title", "Callor", "EmployeeName" },
"来电记录列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
PurchasePlanModel PurchasePlanM = new PurchasePlanModel();
PurchasePlanM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
PurchasePlanM.PlanNo = txtPlanNo.Value;
PurchasePlanM.Title = txtPlanTitle.Value;
PurchasePlanM.PlanUserID = PlanUserID.Value;
PurchasePlanM.PlanMoney = txtTotalMoneyMin.Value;
PurchasePlanM.TotalMoneyMax = txtTotalMoneyMax.Value;
PurchasePlanM.PlanDeptID = txtDeptID.Value;
PurchasePlanM.PlanDate = txtStartPlanDate.Value;
PurchasePlanM.EndPlanDate = txtEndPlanDate.Value;
PurchasePlanM.BillStatus = ddlFlowStatus.Value;
PurchasePlanM.FlowStatus = ddlFlowStatus.Value;
PurchasePlanM.EFIndex = GetBillExAttrControl1.GetExtIndexValue;
PurchasePlanM.EFDesc = GetBillExAttrControl1.GetExtTxtValue;
string OrderBy = hidOrderBy.Value;
//XElement dsXML = ConvertDataTableToXML(PurchasePlanBus.SelectPurchasePlan(PurchasePlanM));
DataTable dt = PurchasePlanBus.SelectPurchasePlan(PurchasePlanM, OrderBy);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "计划单编号", "计划单主题", "计划员", "预控金额", "计划时间", "单据状态", "审批状态" },
new string[] { "PlanNo", "PlanTitle", "PlanUserName", "PlanMoney", "PlanDate", "BillStatusName", "FlowStatusName" },
"采购计划列表");
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
StorageInProcessModel model = new StorageInProcessModel();
string EnterDateStart = string.Empty;
string EnterDateEnd = string.Empty;
string StorageID = string.Empty;
string FromBillNo = string.Empty;
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.InNo = txtInNo.Value;
model.Title = txtTitle.Value;
model.ProcessDept = txtDeptProcessID.Value;
model.DeptID = txtDeptID.Value;
model.BillStatus = sltBillStatus.Value;
model.Executor = txtExecutorID.Value;
model.Processor = txtProcessorID.Value;
EnterDateStart = txtEnterDateStart.Value;
EnterDateEnd = txtEnterDateEnd.Value;
StorageID = ddlStorageID.SelectedValue;
string BatchNo = txtBatchNo.Value;
FromBillNo = txtFromBillID.Value;
string orderBy = txtorderBy.Value;
if (!string.IsNullOrEmpty(orderBy))
{
if (orderBy.Split('_')[1] == "a")
{
orderBy = orderBy.Split('_')[0] + " asc";
}
else
{
orderBy = orderBy.Split('_')[0] + " desc";
}
}
DataTable dt = StorageInProcessBus.GetStorageInProcessTableBycondition(BatchNo, model, EnterDateStart, EnterDateEnd, StorageID, FromBillNo, orderBy);
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice)
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "单据编号", "单据主题", "生产任务单", "加工类别", "加工单位", "生产负责人", "部门", "入库人", "入库时间", "入库数量", "入库金额", "摘要", "单据状态" },
new string[] { "InNo", "Title", "TaskNo", "ProcessType", "ProcessDeptName", "Processor", "InPutDeptName", "Executor", "EnterDate", "CountTotal", "TotalPrice", "Summary", "BillStatusName" },
"生产完工入库列表");
}
else
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "单据编号", "单据主题", "生产任务单", "加工类别", "加工单位", "生产负责人", "部门", "入库人", "入库时间", "入库数量", "摘要", "单据状态" },
new string[] { "InNo", "Title", "TaskNo", "ProcessType", "ProcessDeptName", "Processor", "InPutDeptName", "Executor", "EnterDate", "CountTotal", "Summary", "BillStatusName" },
"生产完工入库列表");
}
}
protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ID"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
EmployeeSearchModel model = new EmployeeSearchModel(); //获取数据
model.EmployeeNo = txtEmployeeNo.Value.Trim(); //编号
model.EmployeeNum = txtEmployeeNum.Value.Trim(); //工号
model.PYShort = txtPYShort.Value.Trim(); //拼音缩写
model.EmployeeName = txtEmployeeName.Value.Trim(); //姓名
model.ContractKind = ""; //request.QueryString["ContractKind"].Trim();//工种
model.AdminLevelID = ""; // request.QueryString["AdminLevel"].Trim(); //行政等级
model.QuarterID = ddlQuarter_ddlCodeType.SelectedItem.Value; //岗位
model.PositionID = ddlPosition.SelectedValue; //职称
string BeginDate = txtStartDate.Value.Trim(); //入职开始时间
string EndDate = txtEnterEndDate.Value.Trim();
DataTable dt = EmployeeInfoBus.ExportEmployeeWorkInfo(model, BeginDate, EndDate, ord);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "编号", "工号", "姓名", "拼音缩写", "曾用名", "部门", "英文名", "人员分类",
"证件类型", "证件号码", "社保卡号", "应聘职务", "岗位", "职称", "岗位职等",
"所在部门", "入职时间", "性别", "出生日期", "联系电话", "手机号码", "电子邮件", "其他联系方式",
"籍贯", "婚姻状况", "学历", "毕业院校", "专业", "政治面貌", "宗教信仰",
"民族", "户口", "户口性质", "国家地区", "身高(厘米)", "体重", "视力",
"最高学位", "健康状况", "特长", "计算机水平", "参加工作时间", "家庭住址", "外语语种1",
"外语语种2", "外语语种3", "外语水平1", "外语水平2", "外语水平3",
"专业描述" },
new string[] { "EmployeeNo", "EmployeeNum", "EmployeeName", "PYShort", "UsedName", "DeptName", "NameEn", "Flag",
"DocuType", "CardID", "SafeguardCard", "PositionTitle", "QuarterName", "PositionName", "AdminLevelName",
"DeptName", "EnterDate", "Sex", "Birth", "Telephone", "Mobile", "EMail", "OtherContact",
"Origin", "MarriageStatus", "CultureLevel", "GraduateSchool", "Professional", "Landscape", "Religion",
"NationalName", "Account", "AccountNature", "CountryName", "Height", "Weight", "Sight",
"Degree", "HealthStatus", "Features", "ComputerLevel", "WorkTime", "HomeAddress", "ForeignLanguage11",
"ForeignLanguage12", "ForeignLanguage13", "ForeignLanguageLevel1", "ForeignLanguageLevel2", "ForeignLanguageLevel3",
"ProfessionalDes" },
"在职人员列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
StorageOutOtherModel model = new StorageOutOtherModel();
string OutDateStart = string.Empty;
string OutDateEnd = string.Empty;
string SendNo = string.Empty;
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.OutNo = txtOutNo.Value;
model.Title = txtTitle.Value;
model.FromType = sltFromType.Value;
model.ReasonType = ddlReason.SelectedValue;
model.BillStatus = sltBillStatus.Value;
model.Transactor = txtOuterID.Value;
OutDateStart = txtOutDateStart.Value;
OutDateEnd = txtOutDateEnd.Value;
string orderBy = txtorderBy.Value;
if (!string.IsNullOrEmpty(orderBy))
{
if (orderBy.Split('_')[1] == "a")
{
orderBy = orderBy.Split('_')[0] + " asc";
}
else
{
orderBy = orderBy.Split('_')[0] + " desc";
}
}
string IndexValue = GetBillExAttrControl1.GetExtIndexValue;
string TxtValue = GetBillExAttrControl1.GetExtTxtValue;
string BatchNo = this.txtBatchNo.Value.ToString();
string ProjectID = this.HiddenProjectID.Value.ToString();
model.ProjectID = ProjectID;
DataTable dt = StorageOutOtherBus.GetStorageOutOtherTableBycondition(model, IndexValue, TxtValue, OutDateStart, OutDateEnd, BatchNo, orderBy);
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice)
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "出库单编号", "出库单主题", "源单类型", "出库人", "出库时间", "出库原因", "出库数量", "出库金额", "摘要", "单据状态" },
new string[] { "OutNo", "Title", "FromTypeName", "Transactor", "OutDate", "ReasonTypeName", "CountTotal", "TotalPrice", "Summary", "BillStatusName" },
"其他出库库列表");
}
else
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "出库单编号", "出库单主题", "源单类型", "出库人", "出库时间", "出库原因", "出库数量", "摘要", "单据状态" },
new string[] { "OutNo", "Title", "FromTypeName", "Transactor", "OutDate", "ReasonTypeName", "CountTotal", "Summary", "BillStatusName" },
"其他出库库列表");
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
StorageModel model = new StorageModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.StorageNo = txtStorageNo.Value.Trim();
model.StorageName = txtStorageName.Value.Trim();
model.StorageType = sltType.Value;
model.UsedStatus = sltUsedStatus.Value;
string orderBy = txtorderBy.Value;
if (!string.IsNullOrEmpty(orderBy))
{
if (orderBy.Split('_')[1] == "a")
{
orderBy = orderBy.Split('_')[0] + " asc";
}
else
{
orderBy = orderBy.Split('_')[0] + " desc";
}
}
DataTable dt = StorageBus.GetStorageListBycondition(model, orderBy);
foreach (DataRow dr in dt.Rows)
{
if (dr["StorageType"].ToString() == "0")
{
dr["StorageType"] = "一般库";
}
else if (dr["StorageType"].ToString() == "1")
{
dr["StorageType"] = "委托代销库";
}
else if (dr["StorageType"].ToString() == "2")
{
dr["StorageType"] = "贵重物品库";
}
if (dr["UsedStatus"].ToString() == "1")
{
dr["UsedStatus"] = "已启用";
}
else
{
dr["UsedStatus"] = "未启用";
}
}
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "仓库编号", "仓库名称", "仓库类型", "仓库状态", "仓管员", "仓库说明" },
new string[] { "StorageNo", "StorageName", "StorageType", "UsedStatus", "CanViewUserName", "Remark" },
"仓库列表");
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
StorageInRedModel model = new StorageInRedModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string EnterDateStart = string.Empty;
string EnterDateEnd = string.Empty;
model.InNo = txtInNo.Value;
model.Title = txtTitle.Value;
model.ReasonType = ddlReasonType.SelectedValue;
if (hidFromBillID.Value == "undefined")
{
hidFromBillID.Value = "";
}
model.FromBillID = hidFromBillID.Value;
model.DeptID = txtDeptID.Value;
model.BillStatus = sltBillStatus.Value;
model.Executor = txtExecutorID.Value;
model.FromType = sltFromType.Value;
EnterDateStart = txtEnterDateStart.Value;
EnterDateEnd = txtEnterDateEnd.Value;
string BatchNo = txtBatchNo.Value;
string orderBy = txtorderBy.Value;
if (!string.IsNullOrEmpty(orderBy))
{
if (orderBy.Split('_')[1] == "a")
{
orderBy = orderBy.Split('_')[0] + " asc";
}
else
{
orderBy = orderBy.Split('_')[0] + " desc";
}
}
DataTable dt = StorageInRedBus.GetStorageInRedTableBycondition(BatchNo, model, EnterDateStart, EnterDateEnd, orderBy);
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice)
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "单据编号", "单据主题", "源单类型", "源单编号", "入库部门", "入库人", "入库时间", "入库原因", "红冲数量", "红冲金额", "摘要", "单据状态" },
new string[] { "InNo", "Title", "FromType", "FromInNo", "DeptName", "ExecutorName", "EnterDate", "CodeName", "CountTotal", "TotalPrice", "Summary", "BillStatusName" },
"红冲入库列表");
}
else
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "单据编号", "单据主题", "源单类型", "源单编号", "入库部门", "入库人", "入库时间", "入库原因", "红冲数量", "摘要", "单据状态" },
new string[] { "InNo", "Title", "FromType", "FromInNo", "DeptName", "ExecutorName", "EnterDate", "CodeName", "CountTotal", "Summary", "BillStatusName" },
"红冲入库列表");
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
StorageInOtherModel model = new StorageInOtherModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string EnterDateStart = string.Empty;
string EnterDateEnd = string.Empty;
model.InNo = txtInNo.Value;
model.Title = txtTitle.Value;
model.DeptID = txtDeptID.Value;
model.BillStatus = sltBillStatus.Value;
model.Executor = txtExecutorID.Value;
model.Taker = txtTakerID.Value;
model.Checker = txtCheckerID.Value;
EnterDateStart = txtEnterDateStart.Value;
EnterDateEnd = txtEnterDateEnd.Value;
string StorageID = sltStorageID.SelectedValue;
string orderBy = txtorderBy.Value;
string BatchNo = txtBatchNo.Value;
model.ProjectID = HidProjectID.Value;
if (!string.IsNullOrEmpty(orderBy))
{
if (orderBy.Split('_')[1] == "a")
{
orderBy = orderBy.Split('_')[0] + " asc";
}
else
{
orderBy = orderBy.Split('_')[0] + " desc";
}
}
DataTable dt = StorageInOtherBus.GetStorageInOtherTableBycondition(BatchNo, model, StorageID, EnterDateStart, EnterDateEnd, orderBy);
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice)
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "单据编号", "单据主题", "交货人", "验收人", "入库部门", "入库人", "入库日期", "入库原因", "入库数量", "入库金额", "摘要", "单据状态" },
new string[] { "InNo", "Title", "TakerName", "CheckerName", "InPutDept", "ExecutorName", "EnterDate", "ReasonTypeName", "CountTotal", "TotalPrice", "Summary", "BillStatusName" },
"其他入库列表");
}
else
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "单据编号", "单据主题", "交货人", "验收人", "入库部门", "入库人", "入库日期", "入库原因", "入库数量", "摘要", "单据状态" },
new string[] { "InNo", "Title", "TakerName", "CheckerName", "InPutDept", "ExecutorName", "EnterDate", "ReasonTypeName", "CountTotal", "Summary", "BillStatusName" },
"其他入库列表");
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
StorageInPurchaseModel model = new StorageInPurchaseModel();
string EnterDateStart = string.Empty;
string EnterDateEnd = string.Empty;
string StorageID = string.Empty;
string FromBillNo = string.Empty;
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.InNo = txtInNo.Value;
model.Title = txtTitle.Value;
model.Taker = txtTakerID.Value;
model.Executor = txtExecutorID.Value;
model.Checker = txtCheckerID.Value;
model.DeptID = txtDeptID.Value;
StorageID = ddlStorageID.SelectedValue;
model.BillStatus = sltBillStatus.Value;
EnterDateStart = txtEnterDateStart.Value;
EnterDateEnd = txtEnterDateEnd.Value;
FromBillNo = txtFromBillID.Value;
string BatchNo = txtBatchNo.Value;
string orderBy = txtorderBy.Value;
if (!string.IsNullOrEmpty(orderBy))
{
if (orderBy.Split('_')[1] == "a")
{
orderBy = orderBy.Split('_')[0] + " asc";
}
else
{
orderBy = orderBy.Split('_')[0] + " desc";
}
}
DataTable dt = StorageInPurchaseBus.GetStorageInPurchaseTableBycondition(BatchNo, model, EnterDateStart, EnterDateEnd, FromBillNo, StorageID, orderBy);
if (((UserInfoUtil)SessionUtil.Session["UserInfo"]).IsDisplayPrice)
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "入库单编号", "入库单主题", "采购到货单", "交货人", "验货人", "入库部门", "入库人", "入库时间", "入库数量", "入库金额", "摘要", "单据状态" },
new string[] { "InNo", "Title", "ArriveNo", "Taker", "Checker", "DeptName", "Executor", "EnterDate", "CountTotal", "TotalPrice", "Summary", "BillStatus" },
"采购入库单列表");
}
else
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "入库单编号", "入库单主题", "采购到货单", "交货人", "验货人", "入库部门", "入库人", "入库时间", "入库数量", "摘要", "单据状态" },
new string[] { "InNo", "Title", "ArriveNo", "Taker", "Checker", "DeptName", "Executor", "EnterDate", "CountTotal", "Summary", "BillStatus" },
"采购入库单列表");
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
StorageLossModel model = new StorageLossModel();
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string LossDateStart = string.Empty;
string LossDateEnd = string.Empty;
string TotalPriceStart = string.Empty;
string TotalPriceEnd = string.Empty;
string FlowStatus = string.Empty;
model.LossNo = txtLossNo.Value;
model.Title = txtTitle.Value;
model.DeptID = txtDeptID.Value;
model.StorageID = ddlStorage.SelectedValue;
model.Executor = txtExecutorID.Value;
model.ReasonType = ddlReason.SelectedValue;
model.BillStatus = sltBillStatus.Value;
FlowStatus = sltFlowStatus.Value;
LossDateStart = txtLossDateStart.Value;
LossDateEnd = txtLossDateEnd.Value;
TotalPriceStart = txtTotalPriceStart.Value;
TotalPriceEnd = txtTotalPriceEnd.Value;
string orderBy = txtorderBy.Value;
if (!string.IsNullOrEmpty(orderBy))
{
if (orderBy.Split('_')[1] == "a")
{
orderBy = orderBy.Split('_')[0] + " asc";
}
else
{
orderBy = orderBy.Split('_')[0] + " desc";
}
}
string IndexValue = GetBillExAttrControl1.GetExtIndexValue;
string TxtValue = GetBillExAttrControl1.GetExtTxtValue;
string BatchNo = this.txtBatchNo.Value.ToString();
DataTable dt = StorageLossBus.GetStorageLossTableBycondition(model, IndexValue, TxtValue, LossDateStart, LossDateEnd, TotalPriceStart, TotalPriceEnd, FlowStatus, BatchNo, orderBy);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "报损单编号", "报损单主题", "经办人", "报损部门", "报损仓库", "报损时间", "报损原因", "成本金额合计", "单据状态", "审批状态" },
new string[] { "LossNo", "Title", "Executor", "DeptName", "StorageName", "LossDate", "ReasonTypeName", "TotalPrice", "BillStatusName", "FlowStatus" },
"库存报损列表");
}
protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ID"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
//获取数据
TrainingAsseSearchModel searchModel = new TrainingAsseSearchModel();
//设置查询条件
//考核编号
searchModel.AsseNo = txtTrainingAsseNo.Value.Trim();
//培训编号
searchModel.TrainingNo = txtTrainingNo.Value.Trim();
//培训名称
searchModel.TrainingName = txtTrainingName.Value.Trim();
//培训方式
searchModel.TrainingWayID = ddlTrainingWay.SelectedValue;
//考评人
searchModel.CheckPerson = txtCheckPerson.Value.Trim();
//考评时间
searchModel.AsseDate = txtAsseDate.Value.Trim();
searchModel.AsseEndDate = txtAsseEndDate.Value.Trim();
//查询数据
DataTable dt = TrainingAsseBus.SearchTrainingAsseInfo(searchModel);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "考核编号", "培训编号", "培训名称", "培训方式", "培训老师", "考评人", "考核方式", "考评时间" },
new string[] { "AsseNo", "TrainingNo", "TrainingName", "TrainingWayName", "TrainingTeacher", "CheckPerson", "AsseWay", "AsseDate" },
"培训考核列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "LinkDate"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
CustComplainModel CustComplainM = new CustComplainModel();
string CustID = hiddCustID.Value; //客户ID
CustComplainM.ComplainType = Convert.ToInt32(ddlComplainType.SelectedItem.Value); //投诉类型
CustComplainM.Critical = seleCritical.Value; //紧急程度
string ComplainBegin = txtComplainBegin.Value.Trim(); //投诉开始时间
string ComplainEnd = txtComplainEnd.Value.Trim(); //结束时间
CustComplainM.Title = txtTitle.Value.Trim(); //客户投诉主题
string CustLinkMan = txtCustLinkMan.Value.Trim(); //客户联系人
string DestClerk = txtEmplNameL.Value.Trim(); //接待人
CustComplainM.State = seleState.Value; //状态
CustComplainM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();
DataTable dt = ComplainBus.ExportComplainInfo(CanUserID, CustID, CustComplainM, ComplainBegin, ComplainEnd, CustLinkMan, DestClerk, ord);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "投诉单编号", "投诉主题", "客户名称", "投诉时间", "投诉分类", "紧急程度", "接待人", "处理状态" },
new string[] { "ComplainNo", "title", "custNam", "ComplainDate", "typename", "Critical", "EmployeeName", "state" },
"客户投诉列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
PurchaseRequireModel PurchaseRequireM = new PurchaseRequireModel();
PurchaseRequireM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
PurchaseRequireM.ProdTypeID = txtProductTypeID.Value;
PurchaseRequireM.ProdID = txtProductID.Value;
PurchaseRequireM.CreateCondition = ddlCreate.Value;
PurchaseRequireM.RequireDate = txtStartRequireDate.Value;
PurchaseRequireM.EndRequireDate = txtEndRequireDate.Value;
string OrderBy = hidOrderBy.Value;
DataTable dt = PurchaseRequireBus.GetPurchaseRequireInfo(PurchaseRequireM, OrderBy);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "物料需求计划单编号", "物料编码", "物料名称", "物料分类", "规格", "单位", "订单需求量", "现有存量", "需申购数量", "采购提前期", "已计划数量", "需求日期" },
new string[] { "MRPNo", "ProdNo", "ProductName", "ProductTypeName", "Specification", "UnitName", "NeedCount", "HasNum", "WantingNum", "WaitingDays", "OrderCount", "RequireDate" },
"采购需求列表");
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "linkmanname"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string ord = " ORDER BY " + orderBy + " " + order;
LinkManModel LinkManM = new LinkManModel();
string CustID = hiddCustID.Value;//客户ID
LinkManM.LinkManName = txtLinkManName.Value.Trim();
LinkManM.Handset = txtHandset.Value.Trim();
LinkManM.Important = seleImportant.Value;
LinkManM.LinkType = ddlLinkType.SelectedItem.Value == "0" ? 0 : Convert.ToInt32(ddlLinkType.SelectedItem.Value);
string DateBegin = txtDateBegin.Value.Trim();
string DateEnd = txtDateEnd.Value.Trim();
LinkManM.WorkTel = txtWorkTel.Value.Trim();
LinkManM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
LinkManM.CanViewUser = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();//当前用户ID
DataTable dt = LinkManBus.ExportLinkManInfo(CustID, LinkManM, DateBegin, DateEnd, ord);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "联系人姓名", "对应客户", "称谓", "联系人类型", "重要程度", "工作电话", "手机", "QQ", "生日" },
new string[] { "linkmanname", "CustName", "Appellation", "TypeName", "Important", "WorkTel", "Handset", "QQ", "Birthday" },
"联系人列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ID"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
//获取数据
HRProxyModel searchModel = new HRProxyModel();
//设置查询条件
//企业编号
searchModel.ProxyCompanyCD = txtProxyNo.Value.Trim();
//企业名称
searchModel.ProxyCompanyName = txtProxyName.Value.Trim();
//重要程度
searchModel.Important = ddlImportant.SelectedItem.Value;
//合作关系
searchModel.Cooperation = ddlCooperation.SelectedItem.Value;
//启用状态
searchModel.UsedStatus = ddlUsedStatus.SelectedItem.Value;
DataTable dt = HRProxyBus.SearchProxyInfo(searchModel);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "企业编号", "企业名称", "联系人", "固定电话", "移动电话", "网络通讯", "重要程度", "合作关系", "启用状态" },
new string[] { "ProxyCompanyCD", "ProxyCompanyName", "ContactName", "ContactTel", "ContactMobile", "ContactWeb", "Important", "Cooperation", "UsedStatus" },
"人才代理列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "BeginDate"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
//获取检索条件
string CustID = hiddCustID.Value; //客户ID
CustServiceModel CustServiceM = new CustServiceModel();
CustServiceM.ServeType = Convert.ToInt32(ddlServeType.SelectedItem.Value); //服务类型
CustServiceM.Fashion = Convert.ToInt32(ddlFashion.Value); //服务方式
string ServiceDateBegin = txtServiceDateBegin.Value;
string ServiceDateEnd = txtServiceDateEnd.Value; //服务结束时间
CustServiceM.Title = txtTitle.Value.Trim(); //客户服务主题
string Executant = txtExecutant.Value.Trim(); //执行人
string CustLinkMan = txtCustLinkMan.Value.Trim(); //客户联系人
CustServiceM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();
DataTable dt = ServiceBus.ExportServiceInfo(CanUserID, CustID, CustServiceM, ServiceDateBegin, ServiceDateEnd, Executant, CustLinkMan, ord);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "服务单编号", "服务主题", "服务时间", "客户名称", "服务类型", "服务方式", "执行人", "客户联络人" },
new string[] { "ServeNo", "title", "BeginDate", "custnam", "ServeType", "Fashion", "EmployeeName", "LinkManName" },
"客户服务列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "CreatedDate"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
CustTalkModel CustTalkM = new CustTalkModel();
string CustID = hiddCustID.Value;
CustTalkM.TalkType = Convert.ToInt32(ddlTalkType.Value); //类型
CustTalkM.Priority = selePriority.Value; //优先级
string TalkBegin = txtTalkBegin.Value; //== "" ? Convert.ToDateTime("1900-01-01") : Convert.ToDateTime(context.Request.Form["TalkBegin"].ToString());//开始时间
string TalkEnd = txtTalkEnd.Value; //== "" ? Convert.ToDateTime("9999-12-31") : Convert.ToDateTime(context.Request.Form["TalkEnd"].ToString() + " 23:59:59.000");//结束时间
CustTalkM.Title = txtTitle.Value; //主题
CustTalkM.Status = seleStatus.Value; //状态
CustTalkM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();
DataTable dt = TalkBus.ExportTalkInfo(CanUserID, CustID, CustTalkM, TalkBegin, TalkEnd, ord);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "洽谈编号", "洽谈主题", "客户名称", "客户联系人", "优先级", "洽谈方式", "完成期限", "执行人", "状态", "创建人", "创建日期" },
new string[] { "TalkNo", "title", "custnam", "linkmanname", "PriorityName", "typename", "CompleteDate", "LinkerName", "StatusName", "EmployeeName", "CreatedDate" },
"客户洽谈列表信息");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void btnImport_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ModifiedDate"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
//获取数据
EmployeeContractModel searchModel = new EmployeeContractModel();
//设置查询条件
//编号
searchModel.ContractNo = txtContractNo.Text.Trim();
//主题
searchModel.Title = txtTitle.Text.Trim();
//员工
searchModel.EmployeeID = hidEmployeeID.Value;
//查询数据
DataTable dt = EmployeeContractBus.SearchEmployeeContractInfo(searchModel);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "合同编号", "合同名称", "员工编号", "员工姓名", "签约时间", "生效时间", "失效时间" },
new string[] { "ContractNo", "Title", "EmployeeNo", "EmployeeName", "SigningDate", "StartDate", "EndDate" },
"合同列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
StorageInitailModel model = new StorageInitailModel();
string EnterDateStart = string.Empty;
string EnterDateEnd = string.Empty;
model.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
model.InNo = txtInNo.Value;
model.Title = txtTitle.Value;
model.DeptID = txtDeptID.Value;
model.StorageID = sltStorageID.SelectedValue;
model.Executor = txtExecutorID.Value;
model.BillStatus = sltBillStatus.Value;
EnterDateStart = txtEnterDateStart.Value;
EnterDateEnd = txtEnterDateEnd.Value;
string BatchNo = txtBatchNo.Value;
string orderBy = txtorderBy.Value;
if (!string.IsNullOrEmpty(orderBy))
{
if (orderBy.Split('_')[1] == "a")
{
orderBy = orderBy.Split('_')[0] + " asc";
}
else
{
orderBy = orderBy.Split('_')[0] + " desc";
}
}
DataTable dt = StorageInitailBus.GetStorageInitailTableBycondition(BatchNo, model, EnterDateStart, EnterDateEnd, orderBy);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "单据编号", "单据主题", "仓库", "入库部门", "入库人", "入库日期", "入库数量", "入库金额", "单据状态" },
new string[] { "InNo", "Title", "StorageName", "DeptName", "Executor", "EnterDate", "CountTotal", "TotalPrice", "BillStatus" },
"期初库存录入列表");
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "LoveDate"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
CustLoveModel CustLoveM = new CustLoveModel();
string CustID = hiddCustID.Value; //客户ID
CustLoveM.LoveType = Convert.ToInt32(ddlLoveType.SelectedItem.Value); //类型
string LoveBegin = txtLoveBegin.Value.Trim(); //开始时间
string LoveEnd = txtLoveEnd.Value.Trim(); //结束时间
string CustLinkMan = txtCustLinkMan.Value.Trim(); //客户联系人
CustLoveM.Title = txtTitle.Value.Trim(); //主题
CustLoveM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();
DataTable dt = LoveBus.ExportLoveInfo(CanUserID, CustID, CustLoveM, LoveBegin, LoveEnd, CustLinkMan, ord);
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "关怀编号", "关怀主题", "客户名称", "客户联系人", "关怀时间", "关怀类型", "执行人" },
new string[] { "LoveNo", "Title", "CustNam", "LinkManName", "LoveDate", "LoveType", "EmployeeName" },
"客户关怀列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void imgOutput_Click(object sender, ImageClickEventArgs e)
{
StorageBorrow borrow = new StorageBorrow();
borrow.BorrowNo = string.IsNullOrEmpty(tboxBorrowNo.Value.Trim())?string.Empty:("%" + tboxBorrowNo.Value.Trim() + "%");
borrow.Title = string.IsNullOrEmpty(tboxTitle.Value.Trim()) ? string.Empty : ("%" + tboxTitle.Value.Trim() + "%");
borrow.Borrower = Convert.ToInt32(string.IsNullOrEmpty(txtBorrower.Value.Trim())?"-1":txtBorrower.Value.Trim());
borrow.DeptID = Convert.ToInt32(string.IsNullOrEmpty(txtBorrowDeptID.Value.Trim())?"-1":txtBorrowDeptID.Value.Trim());
borrow.OutDeptID = Convert.ToInt32(string.IsNullOrEmpty(txtOutDept.Value.Trim())?"-1":txtOutDept.Value.Trim());
borrow.StorageID = Convert.ToInt32(string.IsNullOrEmpty(ddlDepot.SelectedItem.Value)?"-1":ddlDepot.SelectedItem.Value);
borrow.Transactor = Convert.ToInt32(string.IsNullOrEmpty(txtTransactor.Value.Trim())?"-1":txtTransactor.Value.Trim());
borrow.BillStatus = string.IsNullOrEmpty(ddlBillStatus.SelectedItem.Value)?string.Empty:ddlBillStatus.SelectedItem.Value;
borrow.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
DateTime start = Convert.ToDateTime(string.IsNullOrEmpty(tboxBorrowStartTime.Text.Trim()) ? DateTime.MinValue.ToString() : tboxBorrowStartTime.Text.Trim());
DateTime end = Convert.ToDateTime(string.IsNullOrEmpty(tboxBorrowEndTime.Text.Trim()) ? DateTime.MinValue.ToString() : tboxBorrowEndTime.Text.Trim());
int SubmitStatus = Convert.ToInt32(string.IsNullOrEmpty(ddlSubmitStatus.SelectedItem.Value)?"-1":ddlSubmitStatus.SelectedItem.Value);
string orderString = (string.IsNullOrEmpty(txtOrderBy.Value.Trim()) ? string.Empty : txtOrderBy.Value.Trim()); //排序
string order = "DESC"; //排序：升序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "ID"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_a"))
{
order = "ASC";//排序：降序
}
//扩展属性
string EFIndex = Request.QueryString["EFIndex"];
string EFDesc = Request.QueryString["EFDesc"];
GetBillExAttrControl1.ExtIndex = EFIndex;
GetBillExAttrControl1.ExtValue = EFDesc;
GetBillExAttrControl1.SetExtControlValue();
orderBy = orderBy + " " + order;
DataTable dt = XBase.Business.Office.StorageManager.StorageBorrowBus.GetStorageList(EFIndex, EFDesc, borrow, orderBy, start, end, SubmitStatus);
foreach (DataRow row in dt.Rows)
{
if (row["FlowStatus"] == null || row["FlowStatus"].ToString() == "")
{
row["FlowStatus"] = "";
}
else if (row["FlowStatus"].ToString() == "1")
{
row["FlowStatus"] = "待审批";
}
else if (row["FlowStatus"].ToString() == "2")
{
row["FlowStatus"] = "审批中";
}
else if (row["FlowStatus"].ToString() == "3")
{
row["FlowStatus"] = "审批通过";
}
else if (row["FlowStatus"].ToString() == "4")
{
row["FlowStatus"] = "审批不通过";
}
else if (row["FlowStatus"].ToString() == "5")
{
row["FlowStatus"] = "撤销审批";
}
}
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "借货单编号", "借货单主题", "借货部门", "借货人", "被借部门", "被借仓库", "借货数量", "借货金额", "出库人", "出库时间", "单据状态", "审批状态" },
new string[] { "BorrowNo", "Title", "DeptID", "Borrower", "OutDeptID", "StorageID", "CountTotal", "TotalPrice", "Transactor", "OutDate", "BillStatus", "FlowStatus" },
"借货单列表");
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
int pageIndex = 1;
int pageCount = 10000;
int totalCount = 0;
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
//设置查询条件
string ddlStorage, ProductID, StartDate, EndDate, ProviderID, BatchNo = "";
ddlStorage = Request.QueryString["SID"].Trim().ToString();
ProductID = Request.QueryString["PID"].Trim().ToString();
StartDate = Request.QueryString["SD"].Trim().ToString();
EndDate = Request.QueryString["ED"].Trim().ToString();
ProviderID = Request.QueryString["ProviderID"].Trim().ToString();
BatchNo = Request.QueryString["BNo"].ToString();
DataTable dt = new DataTable();
if (string.IsNullOrEmpty(ProviderID))
{
string QueryStr = " a.CompanyCD='" + CompanyCD + "' ";
if (ddlStorage.Trim().Length > 0 && ddlStorage.Trim().Length > 0)
{
QueryStr += " and a.StorageID= '";
QueryStr += ddlStorage;
QueryStr += "' ";
}
if (ProductID.Trim().Length > 0 && ProductID.Trim().Length > 0)
{
QueryStr += " and a.ProductID= '";
QueryStr += ProductID;
QueryStr += "' ";
}
if (StartDate.Trim().Length > 0)
{
QueryStr += " and a.HappenDate >='";
QueryStr += StartDate + " 00:00:00";
QueryStr += "' ";
}
if (EndDate.Trim().Length > 0)
{
QueryStr += " and a.HappenDate <='";
QueryStr += EndDate + " 23:59:59";
QueryStr += "' ";
}
if (BatchNo != "0")
{
if (BatchNo == "未设置批次" || string.IsNullOrEmpty(BatchNo))
{
QueryStr += " and ( a.BatchNo is null or a.BatchNo='') ";
}
else
{
QueryStr += " and a.BatchNo='" + BatchNo + "' ";
}
}
dt = StrongeJournalBus.GetDetailStrongJournal(QueryStr, pageIndex, pageCount, " ProductID desc ", ref totalCount);
}
else
{
string QueryStr = " and a.CompanyCD='" + CompanyCD + "' and c.ProviderID='" + ProviderID + "' ";
if (ddlStorage.Trim().Length > 0 && ddlStorage.Trim().Length > 0)
{
QueryStr += " and e.StorageID= '";
QueryStr += ddlStorage;
QueryStr += "' ";
}
if (ProductID.Trim().Length > 0 && ProductID.Trim().Length > 0)
{
QueryStr += " and e.ProductID= '";
QueryStr += ProductID;
QueryStr += "' ";
}
if (StartDate.Trim().Length > 0)
{
QueryStr += " and a.EnterDate >='";
QueryStr += StartDate + " 00:00:00";
QueryStr += "' ";
}
if (EndDate.Trim().Length > 0)
{
QueryStr += " and a.EnterDate <='";
QueryStr += EndDate + " 23:59:59";
QueryStr += "' ";
}
if (BatchNo != "0")
{
if (BatchNo == "未设置批次")
{
QueryStr += " and ( e.BatchNo is null or e.BatchNo='') ";
}
else
{
QueryStr += " and e.BatchNo='" + BatchNo + "' ";
}
}
dt = StrongeJournalBus.GetDetailStrongJournalByPro(QueryStr, pageIndex, pageCount, " ProductID desc ", ref totalCount);
}
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "仓库编号", "仓库名称", "批次", "物品编号", "物品名称", "规格型号", "颜色", "尺寸", "产地", "出入库时间", "出入库数量" },
new string[] { "StorageNo", "StorageName", "BatchNo", "ProdNo", "ProductName", "Specification", "ColorName", "ProductSize", "FromAddr", "EnterDate", "ProductCount" },
"库存流水账明细");
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
int pageIndex = 1;
int pageCount = 10000;
int totalCount = 0;
string orderBy = txtorderBy.Value;
if (!string.IsNullOrEmpty(orderBy))
{
if (orderBy.Split('_')[1] == "a")
{
orderBy = orderBy.Split('_')[0] + " asc";
}
else
{
orderBy = orderBy.Split('_')[0] + " desc";
}
}
string EFindex = hiddenEFIndex.Value.Trim();
string EFDesc = hiddenEFDesc.Value.Trim();
string EFName = hiddenEFIndexName.Value;
string extQueryStr = string.Empty;
if (!string.IsNullOrEmpty(EFindex) && !string.IsNullOrEmpty(EFDesc))
{
extQueryStr = " b.ExtField" + EFindex + " LIKE '%" + EFDesc + "%' " + "@b.ExtField" + EFindex;
}
string sidex = "ExtField" + EFindex;
//设置查询条件
string ddlStorage, txtProductNo, ProductID, StartDate, EndDate, ProviderID, ckbIsM, SourceNo = "";
string CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
ddlStorage = this.ddlStorage.SelectedValue;
//txtProductName = this.txtProductName.Value;
txtProductNo = this.txtProductNo.Value;
ProductID = this.hiddenProductID.Value;
StartDate = this.txtStartDate.Text;
EndDate = this.txtEndDate.Text;
ProviderID = this.txtProviderID.Value;
SourceNo = this.txtSourceNo.Text;
if (this.ckbIsM.Checked)
{
ckbIsM = "1";
}
else
{
ckbIsM = "0";
}
string BatchNo = this.ddlBatchNo.SelectedValue;
string ListID = StorageBus.GetStorageIDStr(((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID, ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD);
DataTable dt = new DataTable();
if (string.IsNullOrEmpty(ProviderID))
{
string QueryStr = " and CompanyCD='" + CompanyCD + "' ";
if (ddlStorage.Trim().Length > 0 && ddlStorage.Trim().Length > 0)
{
QueryStr += " and StorageID= '";
QueryStr += ddlStorage;
QueryStr += "' ";
}
if (ProductID.Trim().Length > 0 && ProductID.Trim().Length > 0)
{
QueryStr += " and ProductID= '";
QueryStr += ProductID;
QueryStr += "' ";
}
if (StartDate.Trim().Length > 0)
{
QueryStr += " and HappenDate >='";
QueryStr += StartDate + " 00:00:00";
QueryStr += "' ";
}
if (EndDate.Trim().Length > 0)
{
QueryStr += " and HappenDate <='";
QueryStr += EndDate + " 23:59:59";
QueryStr += "' ";
}
if (BatchNo != "0")
{
if (BatchNo == "未设置批次")
{
QueryStr += " and ( BatchNo is null or BatchNo='') ";
}
else
{
QueryStr += " and BatchNo='" + BatchNo + "' ";
}
}
if (SourceNo.Trim().Length > 0 && SourceNo != "0")
{
if (ckbIsM == "0")
{
QueryStr += " and BillNo= '";
QueryStr += SourceNo;
QueryStr += "' ";
}
else
{
QueryStr += " and BillNo like '%";
QueryStr += SourceNo;
QueryStr += "%' ";
}
}
dt = StrongeJournalBus.GetSumStrongJournal(QueryStr, extQueryStr, pageIndex, pageCount, " ProductID asc ", ref totalCount);
if (!string.IsNullOrEmpty(EFindex) && !string.IsNullOrEmpty(EFDesc))
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "仓库编号", "仓库名称", "批次", "物品编号", "物品名称", "规格型号", "尺寸", "产地", "入库总量", "出库总量", "现有存量", EFName },
new string[] { "StorageNo", "StorageName", "BatchNo", "ProdNo", "ProductName", "Specification", "ProductSize", "FromAddr", "InProductCount", "OutProductCount", "NowProductCount", sidex },
"库存流水账列表");
}
else
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "仓库编号", "仓库名称", "批次", "物品编号", "物品名称", "规格型号", "尺寸", "产地", "入库总量", "出库总量", "现有存量" },
new string[] { "StorageNo", "StorageName", "BatchNo", "ProdNo", "ProductName", "Specification", "ProductSize", "FromAddr", "InProductCount", "OutProductCount", "NowProductCount" },
"库存流水账列表");
}
}
else
{
string QueryStr = " and a.CompanyCD='" + CompanyCD + "' and c.ProviderID='" + ProviderID + "' ";
if (ddlStorage.Trim().Length > 0 && ddlStorage.Trim().Length > 0)
{
QueryStr += " and b.StorageID= '";
QueryStr += ddlStorage;
QueryStr += "' ";
}
if (ProductID.Trim().Length > 0 && ProductID.Trim().Length > 0)
{
QueryStr += " and b.ProductID= '";
QueryStr += ProductID;
QueryStr += "' ";
}
if (StartDate.Trim().Length > 0)
{
QueryStr += " and a.EnterDate >='";
QueryStr += StartDate + " 00:00:00";
QueryStr += "' ";
}
if (EndDate.Trim().Length > 0)
{
QueryStr += " and a.EnterDate <='";
QueryStr += EndDate + " 23:59:59";
QueryStr += "' ";
}
if (BatchNo != "0")
{
if (BatchNo == "未设置批次")
{
QueryStr += " and ( b.BatchNo is null or b.BatchNo='') ";
}
else
{
QueryStr += " and b.BatchNo='" + BatchNo + "' ";
}
}
//查询数据
//DataTable dt = AcountBookBus.GetAcountBookInfo(QueryStr);
dt = StrongeJournalBus.GetStrongJournalByPro(QueryStr, extQueryStr, pageIndex, pageCount, " ProductID asc ", ref totalCount);
if (!string.IsNullOrEmpty(EFindex) && !string.IsNullOrEmpty(EFDesc))
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "仓库编号", "仓库名称", "批次", "物品编号", "物品名称", "规格型号", "尺寸", "产地", "入库总量", EFName },
new string[] { "StorageNo", "StorageName", "BatchNo", "ProdNo", "ProductName", "Specification", "ProductSize", "FromAddr", "ProductCount", sidex },
"库存流水账列表");
}
else
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "仓库编号", "仓库名称", "批次", "物品编号", "物品名称", "规格型号", "尺寸", "产地", "入库总量" },
new string[] { "StorageNo", "StorageName", "BatchNo", "ProdNo", "ProductName", "Specification", "ProductSize", "FromAddr", "ProductCount" },
"库存流水账列表");
}
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
try
{
string orderString = hiddExpOrder.Value.Trim(); //排序
string order = "asc"; //排序：降序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "CustNo"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_d"))
{
order = "desc";//排序：降序
}
string ord = " ORDER BY " + orderBy + " " + order;
CustInfoModel CustInfoM = new CustInfoModel();
CustInfoM.CustNo = txtCustNo.Value.Trim();
CustInfoM.CustNam = txtCustNam.Value;
CustInfoM.CustClass = hiddCustClass.Value.Trim() == "" ? 0 : Convert.ToInt32(hiddCustClass.Value.Trim());
CustInfoM.CustName = txtCustName.Value.Trim();
CustInfoM.CustShort = txtCustShort.Value.Trim();
CustInfoM.AreaID = ddlArea.SelectedItem.Value == "0" ? 0 : Convert.ToInt32(ddlArea.SelectedItem.Value);
CustInfoM.CreditGrade = ddlCreditGrade.SelectedItem.Value == "0" ? 0 : Convert.ToInt32(ddlCreditGrade.SelectedItem.Value);
CustInfoM.RelaGrade = seleRelaGrade.Value;
CustInfoM.UsedStatus = seleUsedStatus.Value;
CustInfoM.Tel = txtTel.Value.Trim();
string Manager = txtManager.Value.Trim();
string CreatedBegin = txtCreatedBegin.Value.Trim();
string CreatedEnd = txtCreatedEnd.Value.Trim();
CustInfoM.CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
string CanUserID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).EmployeeID.ToString();//当前用户ID
DataTable dt = CustInfoBus.ExportCustInfo(CustInfoM, Manager, CanUserID, CreatedBegin, CreatedEnd, ord);
//OutputToExecl.ExportToTableFormat(this, dt,
// new string[] { "客户编号", "客户名称", "客户大类", "拼音缩写", "客户细分", "客户类别", "所在区域", "分管业务员", "客户优质级别", "客户关系等级", "创建人", "创建日期", "启用状态" },
// new string[] { "CustNo", "CustName", "CustBigName", "CustShort", "CodeName", "TypeName", "Area", "Manager", "CreditGrade", "RelaGradeName", "Creator", "CreatedDate", "UsedStatusName" },
// "客户档案列表");
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "客户编号", "客户名称", "客户大类", "客户简称", "拼音缩写", "客户管理分类",
"客户营销分类", "客户优质级别", "客户时间分类", "客户细分", "客户类别", "建档人", "建档日期",
"客户简介", "国家地区", "区域", "省", "市(县)", "业务类型", "分管业务员", "联系人", "电话",
"手机", "传真", "在线咨询", "公司网址", "邮编", "电子邮件", "首次交易日期", "运送方式", "交货方式",
"联络期限(天)", "收货地址", "经营范围", "允许延期付款", "信用额度(元)", "帐期天数(天)", "结算方式",
"结算币种", "发票类型", "支付方式", "开户行", "户名", "账号", "单位性质", "资产规模(万元)",
"成立时间", "注册资本(万元)", "员工总数(个)", "法人代表", "行业", "营业执照号", "注册地址",
"税务登记号", "是否为一般纳税人", "客户来源", "年销售额(万元)", "年利润额(万元)", "销售模式",
"上级客户", "价值评估", "阶段", "热点客户", "热度", "关系等级", "启用状态", "关系描述", "备注",
"最后更新用户", "最后更新日期", "经营理念", "企业口号", "企业文化概述", "发展潜力", "存在问题",
"市场优劣势", "行业地位", "竞争对手", "合作伙伴", "发展计划", "合作方法", "可查看该客户档案的人员" },
new string[] { "CustNo", "CustName", "BigType", "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" },
"客户档案列表");
}
catch
{
ClientScript.RegisterStartupScript(this.GetType(), "Exp", "<script language=javascript>showPopup('../../../Images/Pic/Close.gif','../../../Images/Pic/note.gif','导出发生异常');</script>");
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
StorageProductModel model = new StorageProductModel();
model.CompanyCD = UserInfo.CompanyCD;
string ProductNo = string.Empty;
string ProductName = string.Empty;
string BarCode = string.Empty;
model.StorageID = ddlStorage.SelectedValue;
XBase.Model.Office.SupplyChain.ProductInfoModel pdtModel = new XBase.Model.Office.SupplyChain.ProductInfoModel();
pdtModel.ProdNo = txtProductNo.Value;
pdtModel.ProductName = txtProductName.Value;
pdtModel.BarCode = HiddenBarCode.Value.Trim();
pdtModel.Specification = txtSpecification.Value;
pdtModel.Manufacturer = txtManufacturer.Value;
pdtModel.Material = ddlMaterial.SelectedValue;
pdtModel.FromAddr = txtFromAddr.Value;
pdtModel.ColorID = sel_ColorID.SelectedValue;
pdtModel.TypeID = this.hidTypeID.Value;
string StorageCount = txtStorageCount.Value;
string StorageCount1 = txtStorageCount1.Value;
model.ProductCount = StorageCount;
string BatchNo = this.ddlBatchNo.SelectedValue;
string EFIndex = hiddenEFIndex.Value.Trim();
string EFDesc = hiddenEFDesc.Value.Trim();
string EFName = hiddenEFIndexName.Value.Trim();
string sidex = "ExtField" + EFIndex;
//ProductNo = txtProductNo.Value;
//ProductName = txtProductName.Value;
// BarCode = HiddenBarCode.Value.Trim();
string orderBy = txtorderBy.Value;
if (!string.IsNullOrEmpty(orderBy))
{
if (orderBy.Split('_')[1] == "a")
{
orderBy = orderBy.Split('_')[0] + " asc";
}
else
{
orderBy = orderBy.Split('_')[0] + " desc";
}
}
//DataTable dt = StorageSearchBus.GetProductStorageTableBycondition(model, ProductNo, ProductName, orderBy, BarCode);
DataTable dt = StorageSearchBus.GetProductStorageTableBycondition(model, pdtModel, StorageCount1, EFIndex, EFDesc, orderBy, BatchNo);
if (!string.IsNullOrEmpty(EFIndex) && !string.IsNullOrEmpty(EFDesc))
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "仓库编号", "仓库名称", "批次", "所属部门", "物品编号", "物品名称", "规格", "颜色", "基本单位", "基本数量", "单位", "数量", EFName },
new string[] { "StorageNo", "StorageName", "BatchNo", "DeptName", "ProductNo", "ProductName", "Specification", "ColorName", "UnitID", "ProductCount", "CodeName", "StoreCount", sidex },
"现有库存查询列表");
}
else
{
OutputToExecl.ExportToTableFormat(this, dt,
new string[] { "仓库编号", "仓库名称", "批次", "所属部门", "物品编号", "物品名称", "规格", "颜色", "基本单位", "基本数量", "单位", "数量" },
new string[] { "StorageNo", "StorageName", "BatchNo", "DeptName", "ProductNo", "ProductName", "Specification", "ColorName", "UnitID", "ProductCount", "CodeName", "StoreCount" },
"现有库存查询列表");
}
}