protected void Page_Load(object sender, EventArgs e)
{
this.GetBillExAttrControl1.TableName = "officedba.SubSellBack";
if (!Page.IsPostBack)
{
//新建修改门店销售退货单模块ID
hidModuleID.Value = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSELLBACKADD;
//HidDeptID.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString();
//DeptDeptID.Text = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptName;
DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString());
if (dt != null)
{
if (dt["ID"] != null && dt["ID"].ToString() != "")
{
HidDeptID.Value = dt["ID"].ToString();
}
else
{
HidDeptID.Value = "0";
}
DeptDeptID.Text = dt["DeptName"].ToString();
}
else
{
HidDeptID.Value = "0";
}
}
}
public static bool ConfirmSubStorageIn(SubStorageInModel Model, string DetailProductID, string DetailSendCount, string DetailUnitPrice, string DetailBatchNo, string length)
{
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(Model.InNo);
logModel.Element = ConstUtil.LOG_PROCESS_CONFIRM;
logModel.ModuleID = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSTORAGEINIT;
succ = SubStorageDBHelper.ConfirmSubStorageIn(Model, DetailProductID, DetailSendCount, DetailUnitPrice, DetailBatchNo, length);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (System.Exception ex)
{
throw ex;
}
}
public static bool UpdateSubStorageIn(SubStorageInModel model, string DetailProductID, string DetailSendCount, string DetailUsedUnitID, string DetailUsedUnitCount, string DetailUsedPrice, string DetailExRate, string DetailBatchNo, string length, string no, Hashtable htExtAttr)
{
UserInfoUtil userInfo = (UserInfoUtil)SessionUtil.Session["UserInfo"];
if (model.ID <= 0)
{
return(false);
}
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(no);
logModel.Element = ConstUtil.LOG_PROCESS_UPDATE;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSTORAGEINIT;
succ = SubStorageDBHelper.UpdateSubStorageIn(model, DetailProductID, DetailSendCount, DetailUsedUnitID, DetailUsedUnitCount, DetailUsedPrice, DetailExRate, DetailBatchNo, length, no, htExtAttr);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (System.Exception ex)
{
throw ex;
}
}
public static bool InsertSubStorageIn(SubStorageInModel model, string DetailProductID, string DetailSendCount, string DetailUsedUnitID, string DetailUsedUnitCount, string DetailUsedPrice, string DetailExRate, string DetailBatchNo, string length, out string ID, Hashtable htExtAttr)
{
try
{
bool succ = false;
LogInfoModel logModel = InitLogInfo(model.InNo);
logModel.Element = ConstUtil.LOG_PROCESS_INSERT;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSTORAGEINIT;
succ = SubStorageDBHelper.InsertSubStorageIn(model, DetailProductID, DetailSendCount, DetailUsedUnitID, DetailUsedUnitCount, DetailUsedPrice, DetailExRate, DetailBatchNo, length, out ID, htExtAttr);
if (!succ)
{
logModel.Remark = ConstUtil.LOG_PROCESS_FAILED;
}
else
{
logModel.Remark = ConstUtil.LOG_PROCESS_SUCCESS;
}
LogDBHelper.InsertLog(logModel);
return(succ);
}
catch (System.Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
CompanyCD = UserInfo.CompanyCD;
this.txtIndentityID.Value = this.intMasterSubStorageInID.ToString();
if (!Page.IsPostBack)
{
// 批次
BatchRuleControl1.CodingType = ConstUtil.CODING_RULE_TYPE_ZERO;
BatchRuleControl1.ItemTypeID = ConstUtil.CODING_RULE_BATCH_NO;
hidModuleID.Value = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSTORAGEINITLIST;
UserID.Value = UserInfo.EmployeeID.ToString();
UserName.Value = UserInfo.EmployeeName;
SystemTime.Value = DateTime.Now.ToString("yyyy-MM-dd");
txtCreateDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
txtModifiedDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
txtCreator.Value = UserInfo.EmployeeID.ToString();
UserInfoUtil userInfo = UserInfo;
usernametemp.Value = userInfo.UserName;
txtCreatorReal.Value = userInfo.EmployeeName;
datetemp.Value = DateTime.Now.ToString("yyyy-MM-dd");
txtCreateDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
txtModifiedUserID.Value = UserInfo.UserID.ToString();
txtModifiedUserIDReal.Value = UserInfo.UserID.ToString();
txtModifiedDate2.Value = DateTime.Now.ToString("yyyy-MM-dd");
txtModifiedUserID2.Value = UserInfo.UserID.ToString();
DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(UserInfo.DeptID.ToString());
if (dt != null)
{
HidDeptID.Value = dt["ID"].ToString();
HidDeptID2.Value = dt["ID"].ToString();
txtDeptName.Text = dt["DeptName"].ToString();
}
btnGetGoods.Visible = userInfo.IsBarCode;
unbtnGetGoods.Visible = userInfo.IsBarCode;
#region 门店入库单单据规则
CodingRuleControl1.CodingType = ConstUtil.CODING_RULE_SUBSTORE;
CodingRuleControl1.ItemTypeID = ConstUtil.CODING_RULE_SUBSTORE_SUBSTORAGEIN;
#endregion
if (userInfo.IsMoreUnit)
{
txtIsMoreUnit.Value = "1";
BasicUnitTd.Visible = true;
BasicNumTd.Visible = true;
}
else
{
txtIsMoreUnit.Value = "0";
BasicUnitTd.Visible = false;
BasicNumTd.Visible = false;
}
}
//小数点位数
hidSelPoint.Value = UserInfo.SelPoint;
}
/// <summary>
/// 门店销售数量产品分析-导出明细
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="BeginDate"></param>
/// <param name="EndDate"></param>
/// <param name="DeptID"></param>
/// <param name="OrderBy"></param>
/// <returns></returns>
public static DataTable GetSubSellListByProduct(string CompanyCD, string BeginDate, string EndDate, string ProductID, string DeptID)
{
SqlCommand comm = SubStorageDBHelper.GetSubSellInfoByProduct(CompanyCD, BeginDate, EndDate, ProductID, DeptID);
//执行查询
return(SqlHelper.ExecuteSearch(comm));
}
/// <summary>
/// 门店销售数量产品分析-查看详细信息
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="BeginDate"></param>
/// <param name="EndDate"></param>
/// <param name="ProductID"></param>
/// <param name="DeptID"></param>
/// <param name="OrderBy"></param>
/// <param name="PageIndex"></param>
/// <param name="PageCount"></param>
/// <param name="TotalCount"></param>
/// <returns></returns>
public static DataTable GetSubSellDetailByProduct(string CompanyCD, string BeginDate, string EndDate, string ProductID, string DeptID, string OrderBy, int PageIndex, int PageCount, ref int TotalCount)
{
SqlCommand comm = SubStorageDBHelper.GetSubSellInfoByProduct(CompanyCD, BeginDate, EndDate, ProductID, DeptID);
//执行查询
return(SqlHelper.PagerWithCommand(comm, PageIndex, PageCount, OrderBy, ref TotalCount));
}
/// <summary>
/// 门店销售额按部门分析-导出明细
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="BeginDate"></param>
/// <param name="EndDate"></param>
/// <param name="DeptID"></param>
/// <param name="OrderBy"></param>
/// <returns></returns>
public static DataTable GetSubSellList(string CompanyCD, string BeginDate, string EndDate, string DeptID)
{
SqlCommand comm = SubStorageDBHelper.SelectSubSellOrder(CompanyCD, BeginDate, EndDate, DeptID, "");
//执行查询
return(SqlHelper.ExecuteSearch(comm));
}
protected void Page_Load(object sender, EventArgs e)
{
hidCompanyCD.Value = UserInfo.CompanyCD;
if (!IsPostBack)
{
string ID = Request.QueryString["ID"];
if ((ID == "0") || (ID == "") || (ID == null))
{//新建页面
BindOrderNo();
#region 绑定销售分店
DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(UserInfo.DeptID.ToString());
if (dt != null)
{
hidDeptID.Value = dt["ID"].ToString();
txtDeptName.Value = dt["DeptName"].ToString();
}
else
{
hidDeptID.Value = "";
txtDeptName.Value = "";
}
#endregion
BindUserInfo();
//下单日期缺省为当前日期
txtOrderDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
btnGetGoods.Visible = UserInfo.IsBarCode;
unbtnGetGoods.Visible = UserInfo.IsBarCode;
}
if (UserInfo.IsMoreUnit)
{
txtIsMoreUnit.Value = "1";
BasicUnitTd.Visible = true;
BasicNumTd.Visible = true;
}
else
{
txtIsMoreUnit.Value = "0";
BasicUnitTd.Visible = false;
BasicNumTd.Visible = false;
}
BindCurrencyType();
BindOrderMethod();
BindTakeType();
BindPayType();
BindMoneyType();
BindCarrayType();
BindStorage();
//小数点位数
hidSelPoint.Value = UserInfo.SelPoint;
}
}
public static DataTable SelectStorageProduct(int pageIndex, int pageCount, string orderBy, ref int TotalCount, string StorageID, string ProductID, string ProductName, string BatchNo)
{
try
{
return(SubStorageDBHelper.SelectStorageProduct(pageIndex, pageCount, orderBy, ref TotalCount, StorageID, ProductID, ProductName, BatchNo));
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable Details(int ID, string DeptID)
{
try
{
return(SubStorageDBHelper.Details(ID, DeptID));
}
catch
{
return(null);
}
}
public static DataTable SubStorageIn(int ID)
{
try
{
return(SubStorageDBHelper.SubStorageIn(ID));
}
catch
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
userInfo = SessionUtil.Session["UserInfo"] as UserInfoUtil;
// 小数位数
_selPoint = int.Parse(userInfo.SelPoint);
if (!Page.IsPostBack)
{
DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString());
if (dt != null)
{
HidDeptID.Value = dt["ID"].ToString();
}
}
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
string companyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
SubSellCustInfoModel model = new SubSellCustInfoModel();
model.CompanyCD = companyCD;
model.DeptID = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString();
DataRow dt1 = SubStorageDBHelper.GetSubDeptFromDeptID(((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString());
if (dt1 != null)
{
model.DeptID = dt1["ID"].ToString();
}
model.CustName = hiddenOrderCustName.Value;
model.CustTel = hiddenOrderCustTel.Value;
model.CustMobile = hiddenOrderCustMobile.Value;
model.CustAddr = hiddenOrderCustAddr.Value;
int TotalCount = 0;
string myOrder = " ID asc";
if (this.hiddenOrder.Value != "0")
{
string[] myOrder1 = this.hiddenOrder.Value.Split('_');
if (myOrder1[1] == "a")
{
myOrder = myOrder1[0] + " asc ";
}
else
{
myOrder = myOrder1[0] + " desc ";
}
}
DataTable dt = SubSellOrderBus.GetAllCustInfo(model, "out", 1, 1, myOrder, ref TotalCount);
//导出标题
string headerTitle = "客户名称|客户电话|客户手机号|客户地址";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "CustName|CustTel|CustMobile|CustAddr";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "分店客户列表");
}
/// <summary>
/// 门店销售数量产品分析
/// </summary>
/// <param name="Querytime"></param>
/// <returns></returns>
public static DataTable GetSubSellInfoByProduct(DateTime Querytime, DateTime QueryEndtime, string DepID)
{
if (Querytime == null)
{
return(null);
}
string strCompanyCD = string.Empty;
try
{
strCompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
}
catch
{
}
return(SubStorageDBHelper.GetSubSellInfoByProduct(Querytime, QueryEndtime, strCompanyCD, DepID));
}
protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
string orderString = hidOrderby.Value.Trim(); //排序
string order = "DESC"; //排序：升序
string orderBy = (!string.IsNullOrEmpty(orderString)) ? orderString.Substring(0, orderString.Length - 2) : "CreateDate"; //要排序的字段，如果为空，默认为"ID"
if (orderString.EndsWith("_a"))
{
order = "ASC";//排序：降序
}
if (string.IsNullOrEmpty(hidPageCount.Value.Trim()))
{
}
else
{
int pageCount = int.Parse(hidPageCount.Value.Trim()); //每页显示记录数
int pageIndex = int.Parse(hidPageIndex.Value.Trim()); //当前页
int skipRecord = (pageIndex - 1) * pageCount; //跳过记录数
string day = txtStartPlanDate.Value.Trim();
int TotalCount = 0;
UserInfoUtil user = ((UserInfoUtil)SessionUtil.Session["UserInfo"]);
string _deptID = "";
DataRow dtSong = SubStorageDBHelper.GetSubDeptFromDeptID(user.DeptID.ToString());
if (dtSong != null)
{
_deptID = dtSong["ID"].ToString();
}
orderBy = orderBy + " " + order;
DataTable dt = SubDayEndBus.SelectDayInfo(pageIndex, pageCount, orderBy, ref TotalCount, day, _deptID);
//导出标题
string headerTitle = "日期|物品编号|品名|规格|批次|门店|入库总数量|出库总数量|当日结存量";
string[] header = headerTitle.Split('|');
//导出标题所对应的列字段名称
string columnFiled = "DailyDate|ProductNo|ProductName|Specification|BatchNo|DeptName|InTotal|OutTotal|TodayCount";
string[] field = columnFiled.Split('|');
XBase.Common.OutputToExecl.ExportToTable(this.Page, dt, header, field, "库存日结列表");
}
}
/// <summary>
/// 根据销售时间，产品编号生成报表(打印)
/// </summary>
/// <param name="Querytime"></param>
/// <param name="strCompanyCD"></param>
/// <param name="ProID"></param>
/// <returns></returns>
public static DataTable GetSubProductSellInfo(DateTime Querytime, DateTime Endtime, string proid, string ordercolumn, string ordertype)
{
if (Querytime == null)
{
return(null);
}
string strCompanyCD = string.Empty;
try
{
strCompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
}
catch
{
strCompanyCD = "AAAAAA";
}
return(SubStorageDBHelper.GetSubProductSellInfo(Querytime, Endtime, strCompanyCD, proid, ordercolumn, ordertype));
}
/// <summary>
/// 收款员业务明细（打印）
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
public static DataTable GetSellerBusDetail(DateTime Querytime, DateTime Endtime, string Dept, string Seller, string ordercolumn, string ordertype)
{
if (Querytime == null)
{
return(null);
}
string strCompanyCD = string.Empty;
try
{
strCompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
}
catch
{
strCompanyCD = "AAAAAA";
}
return(SubStorageDBHelper.GetSellerBusDetail(Querytime, Endtime, strCompanyCD, Dept, Seller, ordercolumn, ordertype));
}
/// <summary>
/// 收款员业务明细(查询)
/// </summary>
/// <param name="?"></param>
/// <returns></returns>
public static DataTable GetSellerBusDetail(DateTime Querytime, DateTime Endtime, string Dept, string Seller, int pageIndex, int pageCount, string OrderBy, ref int totalCount)
{
if (Querytime == null)
{
return(null);
}
string strCompanyCD = string.Empty;
try
{
strCompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
}
catch
{
strCompanyCD = "AAAAAA";
}
return(SubStorageDBHelper.GetSellerBusDetail(Querytime, Endtime, strCompanyCD, Dept, Seller, pageIndex, pageCount, OrderBy, ref totalCount));
}
protected void Page_Load(object sender, EventArgs e)
{
this.GetBillExAttrControl1.TableName = "officedba.SubSellOrder";
if (!IsPostBack)
{
DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString());
if (dt != null)
{
hidDeptID.Value = dt["ID"].ToString();
DeptName.Value = dt["DeptName"].ToString();
}
else
{
hidDeptID.Value = "0";
DeptName.Value = "";
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//分店期初库存录入模块ID
hidModuleID.Value = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSTORAGEINIT;
UserInfoUtil userInfo = ((UserInfoUtil)SessionUtil.Session["UserInfo"]);
//HidDeptID.Value = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString();
DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(((UserInfoUtil)SessionUtil.Session["UserInfo"]).DeptID.ToString());
if (dt != null)
{
HidDeptID.Value = dt["ID"].ToString();
}
}
this.GetBillExAttrControl1.TableName = "officedba.SubStorageIn";
//小数点位数
hidSelPoint.Value = UserInfo.SelPoint;
}
public static bool DeleteSubStorageIn(string IDs, string InNos, string CompanyCD)
{
var BIANHAO = InNos.Replace("'", "");//此方法当编号规则里不存在'时可以
LogInfoModel logModel = InitLogInfo(BIANHAO);
logModel.Element = ConstUtil.LOG_PROCESS_DELETE;
//设置模块ID 模块ID请在ConstUtil中定义，以便维护
logModel.ModuleID = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSTORAGEINITLIST;
ArrayList lstDelete = new ArrayList();
SqlCommand deletePri = SubStorageDBHelper.DeleteSubStorageIn(IDs);
lstDelete.Add(deletePri);
SqlCommand deleteDeteil = SubStorageDBHelper.DeleteSubStorageInDetail(InNos, CompanyCD);
lstDelete.Add(deleteDeteil);
bool isSucc = SqlHelper.ExecuteTransWithArrayList(lstDelete);
string remark;
//成功时
if (isSucc)
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_SUCCESS;
logModel.Remark = remark;
}
else
{
//设置操作成功标识
remark = ConstUtil.LOG_PROCESS_FAILED;
logModel.Remark = remark;
}
LogDBHelper.InsertLog(logModel);
return(isSucc);
}
/// <summary>
/// 批量导入数据
/// </summary>
/// <param name="dt">数据集</param>
/// <param name="userInfo">登录信息</param>
/// <returns></returns>
public static bool ImportData(DataTable dt, UserInfoUtil userInfo)
{
return(SubStorageDBHelper.ImportData(dt, userInfo));
}
/// <summary>
/// 门店销数量走势-导出
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="Method"></param>
/// <param name="BeginDate"></param>
/// <param name="EndDate"></param>
/// <param name="DeptID"></param>
/// <param name="OrderBy"></param>
/// <param name="XValue"></param>
/// <returns></returns>
public static DataTable GetSubSellCountTenDetailOut(string CompanyCD, string Method, string BeginDate, string EndDate, string DeptID, string OrderBy, string XValue)
{
SqlCommand comm = SubStorageDBHelper.GetSubSellCountTenDetail(CompanyCD, Method, BeginDate, EndDate, DeptID, OrderBy, XValue);
return(SqlHelper.ExecuteSearch(comm));
}
/// <summary>
/// 门店销数量走势-查看明细
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="Method"></param>
/// <param name="BeginDate"></param>
/// <param name="EndDate"></param>
/// <param name="DeptID"></param>
/// <param name="OrderBy"></param>
/// <param name="XValue"></param>
/// <returns></returns>
public static DataTable GetSubSellCountTenDetail(string CompanyCD, string Method, string BeginDate, string EndDate, string DeptID, string OrderBy, string XValue, int PageIndex, int PageCount, ref int TotalCount)
{
SqlCommand comm = SubStorageDBHelper.GetSubSellCountTenDetail(CompanyCD, Method, BeginDate, EndDate, DeptID, OrderBy, XValue);
return(SqlHelper.PagerWithCommand(comm, PageIndex, PageCount, OrderBy, ref TotalCount));
}
/// <summary>
/// 门店销数量走势
/// </summary>
/// <param name="CompanyCD"></param>
/// <param name="Method"></param>
/// <param name="BeginDate"></param>
/// <param name="EndDate"></param>
/// <param name="DeptID"></param>
/// <returns></returns>
public static DataTable GetSubSellCountTen(string CompanyCD, string Method, string BeginDate, string EndDate, string DeptID)
{
return(SubStorageDBHelper.GetSubSellCountTen(CompanyCD, Method, BeginDate, EndDate, DeptID));
}
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 Page_Load(object sender, EventArgs e)
{
this.txtIndentityID.Value = this.intMasterSubSellBackID.ToString();
CompanyCD = ((UserInfoUtil)SessionUtil.Session["UserInfo"]).CompanyCD;
if (!Page.IsPostBack)
{
hidModuleID.Value = ConstUtil.MODULE_ID_SUBSTOREMANAGER_SUBSELLBACKLIST;
BinddrpCurrencyType(); //绑定币种
BinddrpStorageID(); //绑定仓库
UserInfoUtil userInfo = ((UserInfoUtil)SessionUtil.Session["UserInfo"]);
hidCompanyCD.Value = userInfo.CompanyCD;
UserID.Value = userInfo.EmployeeID.ToString();
UserName.Value = userInfo.EmployeeName;
SystemTime.Value = DateTime.Now.ToString("yyyy-MM-dd");
SystemTime2.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
txtCreateDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
txtCreator.Value = userInfo.EmployeeID.ToString();
usernametemp.Value = userInfo.UserName;
txtCreatorReal.Value = userInfo.EmployeeName;
datetemp.Value = DateTime.Now.ToString("yyyy-MM-dd");
txtCreateDate.Value = DateTime.Now.ToString("yyyy-MM-dd");
txtModifiedDate.Text = DateTime.Now.ToString("yyyy-MM-dd");
txtModifiedDate2.Value = DateTime.Now.ToString("yyyy-MM-dd");
txtModifiedUserID2.Value = userInfo.UserID.ToString();
txtModifiedUserID.Value = userInfo.UserID.ToString();
txtModifiedUserIDReal.Value = userInfo.UserID.ToString();
DataRow dt = SubStorageDBHelper.GetSubDeptFromDeptID(userInfo.DeptID.ToString());
if (dt != null)
{
HidDeptID.Value = dt["ID"].ToString();
HidDeptID2.Value = dt["ID"].ToString();
txtDeptName.Text = dt["DeptName"].ToString();
}
//计量单位
if (UserInfo.IsMoreUnit)
{
txtIsMoreUnit.Value = "1";
BasicUnitTd.Visible = true;
BasicNumTd.Visible = true;
}
else
{
txtIsMoreUnit.Value = "0";
BasicUnitTd.Visible = false;
BasicNumTd.Visible = false;
}
btnGetGoods.Visible = userInfo.IsBarCode;
unbtnGetGoods.Visible = userInfo.IsBarCode;
//小数点位数
hidSelPoint.Value = UserInfo.SelPoint;
#region 门店销售退货单据规则
CodingRuleControl1.CodingType = ConstUtil.CODING_RULE_SUBSTORE;
CodingRuleControl1.ItemTypeID = ConstUtil.CODING_RULE_SUBSTORE_SUBSELLBACK;
usernametemp.Value = userInfo.UserName;
datetemp.Value = DateTime.Now.ToString("yyyy-MM-dd");
#endregion
}
}
/// <summary>
/// 绑定门店仓库
/// </summary>
/// <returns>DataTable</returns>
public static DataTable GetdrpStorageName()
{
DataTable dt = SubStorageDBHelper.GetdrpStorageName();
return(dt);
}
