/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 if (string.IsNullOrEmpty(txtName.Text.Trim())) { return(txtName.Label + "不能为空!"); } var sName = StringHelper.Left(txtName.Text, 50); if (UploadTypeBll.GetInstence().Exist(x => x.Name == sName && x.Id != id)) { return(txtName.Label + "已存在!请重新输入!"); } if (string.IsNullOrEmpty(txtTypeKey.Text.Trim())) { return(txtTypeKey.Label + "不能为空!"); } if (string.IsNullOrEmpty(txtExt.Text.Trim())) { return(txtExt.Label + "不能为空!"); } #endregion #region 赋值 //获取实体 var model = new UploadType(x => x.Id == id); //系统默认 //model.IsSys = ConvertHelper.StringToByte(rblIsSys.SelectedValue); //判断是否有改变关键字 var sTypeKey = StringHelper.Left(txtTypeKey.Text, 20); if (id > 0 && model.IsSys == 1 && sTypeKey != model.TypeKey) { return("当前记录为系统默认,不能修改关键字!"); } //设置名称 model.Name = sName; //设置关键字 model.TypeKey = sTypeKey; //扩展名 model.Ext = StringHelper.Left(txtExt.Text, 0); //修改时间与管理员 model.UpdateDate = DateTime.Now; model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId(); model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName(); #endregion //---------------------------------------------------------- //存储到数据库 UploadTypeBll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); string prod_id = hidPROD_ID.Text; if (!String.IsNullOrEmpty(prod_id)) { try { #region 数据验证 var sPRCAREA_ID = PRCAREA_ID.SelectedValue; if (string.IsNullOrEmpty(sPRCAREA_ID) || sPRCAREA_ID == "0") { return(PRCAREA_ID.Label + "不能为空!"); } var sSUP_ID = SUP_ID.SelectedValue; if (string.IsNullOrEmpty(sSUP_ID) || sSUP_ID == "0") { return(SUP_ID.Label + "不能为空!"); } var sTAX_TYPE = TAX_TYPE.SelectedValue; if (string.IsNullOrEmpty(sTAX_TYPE)) { return(TAX_TYPE.Label + "不能为空!"); } var sSEND_TYPE = SEND_TYPE.SelectedValue; if (string.IsNullOrEmpty(sSEND_TYPE) || sSEND_TYPE == "0") { return(SEND_TYPE.Label + "不能为空!"); } var sTax = Tax.Text; if (string.IsNullOrEmpty(sTax)) { return(Tax.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sTax)) { return(Tax.Label + "必须为整数!"); } var sSUP_COST = SUP_COST.Text; if (string.IsNullOrEmpty(sSUP_COST)) { return(SUP_COST.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sSUP_COST)) { return(SUP_COST.Label + "必须为整数!"); } var sSUP_COST1 = SUP_COST1.Text; if (string.IsNullOrEmpty(sSUP_COST1)) { return(SUP_COST1.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sSUP_COST1)) { return(SUP_COST1.Label + "必须为整数!"); } var sSUP_COST2 = SUP_COST2.Text; if (string.IsNullOrEmpty(sSUP_COST2)) { return(SUP_COST2.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sSUP_COST2)) { return(SUP_COST2.Label + "必须为整数!"); } var sSUP_Return = SUP_Return.Text; if (string.IsNullOrEmpty(sSUP_Return)) { return(SUP_Return.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sSUP_Return)) { return(SUP_Return.Label + "必须为整数!"); } var sSUP_Return1 = SUP_Return1.Text; if (string.IsNullOrEmpty(sSUP_Return1)) { return(SUP_Return1.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sSUP_Return1)) { return(SUP_Return1.Label + "必须为整数!"); } var sSUP_Return2 = SUP_Return2.Text; if (string.IsNullOrEmpty(sSUP_Return2)) { return(SUP_Return2.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sSUP_Return2)) { return(SUP_Return2.Label + "必须为整数!"); } var sU_Cost = U_Cost.Text; if (string.IsNullOrEmpty(sU_Cost)) { return(U_Cost.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sU_Cost)) { return(U_Cost.Label + "必须为整数!"); } var sU_Cost1 = U_Cost1.Text; if (string.IsNullOrEmpty(sU_Cost1)) { return(U_Cost1.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sU_Cost1)) { return(U_Cost1.Label + "必须为整数!"); } var sU_Cost2 = U_Cost2.Text; if (string.IsNullOrEmpty(sU_Cost2)) { return(U_Cost2.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sU_Cost2)) { return(U_Cost2.Label + "必须为整数!"); } var sU_Ret_COST = U_Ret_COST.Text; if (string.IsNullOrEmpty(sU_Ret_COST)) { return(U_Ret_COST.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sU_Ret_COST)) { return(U_Ret_COST.Label + "必须为整数!"); } var sU_Ret_COST1 = U_Ret_COST1.Text; if (string.IsNullOrEmpty(sU_Ret_COST1)) { return(U_Ret_COST1.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sU_Ret_COST1)) { return(U_Ret_COST1.Label + "必须为整数!"); } var sU_Ret_COST2 = U_Ret_COST2.Text; if (string.IsNullOrEmpty(sU_Ret_COST2)) { return(U_Ret_COST2.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sU_Ret_COST2)) { return(U_Ret_COST2.Label + "必须为整数!"); } var sT_COST = T_COST.Text; if (string.IsNullOrEmpty(sT_COST)) { return(T_COST.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sT_COST)) { return(T_COST.Label + "必须为整数!"); } var sT_COST1 = T_COST1.Text; if (string.IsNullOrEmpty(sT_COST1)) { return(T_COST1.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sT_COST1)) { return(T_COST1.Label + "必须为整数!"); } var sT_COST2 = T_COST2.Text; if (string.IsNullOrEmpty(sT_COST2)) { return(T_COST2.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sT_COST2)) { return(T_COST2.Label + "必须为整数!"); } var sT_Ret_COST = T_Ret_COST.Text; if (string.IsNullOrEmpty(sT_Ret_COST)) { return(T_Ret_COST.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sT_Ret_COST)) { return(T_Ret_COST.Label + "必须为整数!"); } var sT_Ret_COST1 = T_Ret_COST1.Text; if (string.IsNullOrEmpty(sT_Ret_COST1)) { return(T_Ret_COST1.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sT_Ret_COST1)) { return(T_Ret_COST1.Label + "必须为整数!"); } var sT_Ret_COST2 = T_Ret_COST2.Text; if (string.IsNullOrEmpty(sT_Ret_COST2)) { return(T_Ret_COST2.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sT_Ret_COST2)) { return(T_Ret_COST2.Label + "必须为整数!"); } var sCOST = COST.Text; if (string.IsNullOrEmpty(sCOST)) { return(COST.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sCOST)) { return(COST.Label + "必须为整数123!"); } var sCOST1 = COST1.Text; if (string.IsNullOrEmpty(sCOST1)) { return(COST1.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sCOST1)) { return(COST1.Label + "必须为整数!"); } var sCOST2 = COST2.Text; if (string.IsNullOrEmpty(sCOST2)) { return(COST2.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sCOST2)) { return(COST2.Label + "必须为整数!"); } var sENABLE = ENABLE.SelectedValue; if (string.IsNullOrEmpty(sENABLE)) { return(ENABLE.Label + "不能为空!"); } var sVISIBLE = VISIBLE.SelectedValue; if (string.IsNullOrEmpty(sVISIBLE)) { return(VISIBLE.Label + "不能为空!"); } #endregion if (PRODUCT01Bll.GetInstence().Exist(x => x.PRCAREA_ID == sPRCAREA_ID && x.PROD_ID == prod_id) && id == 0) { return(PRCAREA_ID.Label + "已存在!请重新输入!"); } #region 赋值 var model = new PRODUCT01(x => x.Id == id); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); model.PRCAREA_ID = sPRCAREA_ID; model.PROD_ID = prod_id; model.SUP_ID = sSUP_ID; model.SEND_TYPE = ConvertHelper.StringToByte(sSEND_TYPE); model.TAX_TYPE = ConvertHelper.StringToByte(sTAX_TYPE); model.Tax = ConvertHelper.Cint0(sTax); model.SUP_COST = ConvertHelper.Cint0(sSUP_COST); model.SUP_COST1 = ConvertHelper.Cint0(sSUP_COST1); model.SUP_COST2 = ConvertHelper.Cint0(sSUP_COST2); model.SUP_Return = ConvertHelper.Cint0(sSUP_Return); model.SUP_Return1 = ConvertHelper.Cint0(sSUP_Return1); model.SUP_Return2 = ConvertHelper.Cint0(sSUP_Return2); model.U_Cost = ConvertHelper.Cint0(sU_Cost); model.U_Cost1 = ConvertHelper.Cint0(sU_Cost1); model.U_Cost2 = ConvertHelper.Cint0(sU_Cost2); model.U_Ret_COST = ConvertHelper.Cint0(sU_Ret_COST); model.U_Ret_COST1 = ConvertHelper.Cint0(sU_Ret_COST1); model.U_Ret_COST2 = ConvertHelper.Cint0(sU_Ret_COST2); model.T_COST = ConvertHelper.Cint0(sT_COST); model.T_COST1 = ConvertHelper.Cint0(sT_COST1); model.T_COST2 = ConvertHelper.Cint0(sT_COST2); model.T_Ret_COST = ConvertHelper.Cint0(sT_Ret_COST); model.T_Ret_COST1 = ConvertHelper.Cint0(sT_Ret_COST1); model.T_Ret_COST2 = ConvertHelper.Cint0(sT_Ret_COST2); model.COST = ConvertHelper.Cint0(sCOST); model.COST1 = ConvertHelper.Cint0(sCOST1); model.COST2 = ConvertHelper.Cint0(sCOST2); model.VISIBLE = ConvertHelper.StringToByte(VISIBLE.SelectedValue); model.ENABLE = ConvertHelper.StringToByte(ENABLE.SelectedValue); if (id == 0) { model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.CRT_USER_ID = OlUser.Manager_LoginName; } else { model.CRT_DATETIME = model.CRT_DATETIME; model.CRT_USER_ID = model.CRT_USER_ID; } //model.CRT_USER_ID = ""; model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.MOD_USER_ID = OlUser.Manager_LoginName; //model.MOD_USER_ID = ""; model.LAST_UPDATE = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.STATUS = 0; #endregion ////---------------------------------------------------------- ////存储到数据库 PRODUCT01Bll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } } else { result = "保存失败,商品编码为空"; } return(result); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 if (string.IsNullOrEmpty(txtName.Text.Trim())) { return(txtName.Label + "不能为空!"); } var sName = StringHelper.Left(txtName.Text, 50); if (BranchBll.GetInstence().Exist(x => x.Name == sName && x.Id != id)) { return(txtName.Label + "已存在!请重新输入!"); } #endregion #region 赋值 //定义是否更新其他关联表变量 bool isUpdate = false; //获取实体 var model = new Branch(x => x.Id == id); //判断是否有改变名称 if (id > 0 && sName != model.Name) { isUpdate = true; } //修改时间与管理员 model.UpdateDate = DateTime.Now; model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId(); model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName(); //设置名称 model.Name = sName; //对应的父类id model.ParentId = ConvertHelper.Cint0(txtParent.Text); //设置备注 model.Notes = StringHelper.Left(txtNotes.Text, 100); //由于限制了编辑时不能修改父节点,所以这里只对新建记录时处理 if (id == 0) { //设定当前的深度与设定当前的层数级 if (model.ParentId == 0) { //设定当前的层数 model.Depth = 0; } else { //设定当前的层数级 model.Depth = ConvertHelper.Cint0(BranchBll.GetInstence().GetFieldValue(ConvertHelper.Cint0(ddlParentId.SelectedValue), BranchTable.Depth)) + 1; } } //设置排序 if (txtSort.Text == "0") { model.Sort = BranchBll.GetInstence().GetSortMax(model.ParentId) + 1; } else { model.Sort = ConvertHelper.Cint0(txtSort.Text); } //新创建部门时,生成对应的部门编码 if (id == 0) { model.Code = SPs.P_Branch_GetMaxBranchCode(model.Depth + 1, model.ParentId).ExecuteScalar().ToString(); } #endregion //---------------------------------------------------------- //存储到数据库 BranchBll.GetInstence().Save(this, model); //如果本次修改改变了相关名称,则同步更新其他关联表的对应名称 if (isUpdate) { PositionBll.GetInstence().UpdateValue_For_Branch_Id(this, model.Id, PositionTable.Branch_Name, model.Name); ManagerBll.GetInstence().UpdateValue_For_Branch_Id(this, model.Id, ManagerTable.Branch_Name, model.Name); } } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 从IIS缓存中获取Rank表记录 /// </summary> /// <param name="isCache">是否从缓存中读取</param> public IList <DataAccess.Model.Rank> GetList(bool isCache = true) { try { //判断是否使用缓存 if (CommonBll.IsUseCache() && isCache) { //检查指定缓存是否过期——缓存当天有效,第二天自动清空 if (CommonBll.CheckCacheIsExpired(const_CacheKey_Date)) { //删除缓存 DelAllCache(); } //从缓存中获取DataTable var obj = CacheHelper.GetCache(const_CacheKey); //如果缓存为null,则查询数据库 if (obj == null) { var list = GetList(false); //将查询出来的数据存储到缓存中 CacheHelper.SetCache(const_CacheKey, list); //存储当前时间 CacheHelper.SetCache(const_CacheKey_Date, DateTime.Now); return(list); } //缓存中存在数据,则直接返回 else { return((IList <DataAccess.Model.Rank>)obj); } } else { //定义临时实体集 IList <DataAccess.Model.Rank> list = null; //获取全表缓存加载条件表达式 var exp = GetExpression <Rank>(); //如果条件为空,则查询全表所有记录 if (exp == null) { //从数据库中获取所有记录 var all = Rank.All(); list = all == null ? null : Transform(all.ToList()); } else { //从数据库中查询出指定条件的记录,并转换为指定实体集 var all = Rank.Find(exp); list = all == null ? null : Transform(all); } return(list); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取Rank表记录时出现异常", e); } return(null); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 if (string.IsNullOrEmpty(STOCK_ID.Text.Trim())) { return(STOCK_ID.Label + "不能为空!"); } if (string.IsNullOrEmpty(STOCK_NAME.Text.Trim())) { return(STOCK_NAME.Label + "不能为空!"); } var sIsDefBill = IsDefBill.Text.Trim(); if (string.IsNullOrEmpty(sIsDefBill)) { return(IsDefBill.Label + "不能为空!"); } if (string.IsNullOrEmpty(SHOP_ID.SelectedValue) || SHOP_ID.SelectedValue == "0") { return(SHOP_ID.Label + "不能为空!"); } var sSHOP_ID = StringHelper.Left(SHOP_ID.Text, 50); var sSTOCK_ID = StringHelper.Left(STOCK_ID.Text, 50); if (STOCKBll.GetInstence().Exist(x => x.SHOP_ID == sSHOP_ID && x.STOCK_ID == sSTOCK_ID) && id == 0) { return(SHOP_ID.Label + "+" + STOCK_ID.Text + "已存在!请重新输入!"); } //var sMeno = StringHelper.Left(UNIT_MENO.Text, 40); //if (UNIT_MENO.Text.Trim().Length > 40) //{ // return UNIT_MENO.Label + "超长!"; //} #endregion #region 赋值 var model = new STOCK(x => x.Id == id); //var OlUser = new OnlineUsers(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == OnlineUsersBll.GetInstence().GetUserHashKey()); //var OlUser = OnlineUsers.SingleOrDefault(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); model.SHOP_ID = SHOP_ID.SelectedValue; model.STOCK_ID = STOCK_ID.Text; model.STOCK_NAME = STOCK_NAME.Text; model.IsDefBill = ConvertHelper.StringToByte(IsDefBill.Text); model.Memo = Memo.Text; if (id == 0) { model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.CRT_USER_ID = OlUser.Manager_LoginName; } else { model.CRT_DATETIME = model.CRT_DATETIME; model.CRT_USER_ID = model.CRT_USER_ID; } //model.CRT_USER_ID = ""; model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.MOD_USER_ID = OlUser.Manager_LoginName; //model.MOD_USER_ID = ""; model.LAST_UPDATE = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); #endregion ////---------------------------------------------------------- ////存储到数据库 STOCKBll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 汇整进货单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void ArchiveButton_Click(object sender, EventArgs e) { DatePicker dpStart = archiveWindow.FindControl("archiveDatePanel").FindControl("inStartDate") as DatePicker; DatePicker dpEnd = archiveWindow.FindControl("archiveDatePanel").FindControl("inEndDate") as DatePicker; //1.查询总部进货表TAKEIN10 // 1)进货单状态为 2=核准 // 2)进货单类型为一般进货 TAKEIN_TYPE=1 // 3)SHOP_ID = 当前登录用户的总部编号 // 4)在指定日期范围内 //2.遍历结果 //3.更新出货单状态为5=月结(关单), 并且锁定出货单(LOCKED=1) //4.更新成功后查询出货单明细更新到应收明细表 //5.保存应收主信息 List <ConditionFun.SqlqueryCondition> wheres = QueryTakeinListCondition(shopId, dpStart.Text, dpEnd.Text); List <TAKEIN10> inList = selectHelper.Select <TAKEIN10>(false, 0, null, 1, 2000, wheres).ExecuteTypedList <TAKEIN10>(); if (inList == null || inList.Count == 0) { Alert.Show("选定时间段未查询到数据!"); return; } List <DueMain> payList = new List <DueMain>(); //遍历进货单 foreach (TAKEIN10 row in inList) { try { //更新进货单 //int retValue = updaterHelper.Update(string.Format("update TAKEIN10 set STATUS = 5, LOCKED = 1 where Id = {0}", row.Id)); //更新成功 则汇整进入总店应付账单表 List <ConditionFun.SqlqueryCondition> conditions = new List <ConditionFun.SqlqueryCondition>(); conditions.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "SHOP_ID", Comparison.Equals, row.SHOP_ID, false, false)); conditions.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, "TAKEIN_ID", Comparison.Equals, row.TAKEIN_ID, false, false)); //查询进货单明细 List <TAKEIN11> itemList = selectHelper.Select <TAKEIN11>(false, 0, null, conditions).ExecuteTypedList <TAKEIN11>(); if (itemList == null || itemList.Count == 0) { CommonBll.WriteLog(string.Format("进货单{0}未查询到明细", row.TAKEIN_ID), null); continue; } //采购总金额 decimal amount = 0; //税额 decimal tax = 0; // foreach (TAKEIN11 item in itemList) { DUE01 payItem = new DUE01(); //批次号 payItem.BAT_NO = item.BAT_NO; //采购金额 payItem.COST = item.STD_PRICE * item.STD_QUAN; //税额 payItem.TAX = item.Tax; //采购金额 amount += payItem.COST; tax += payItem.TAX; } DueMain payMain = new DueMain(); payMain.Id = row.Id; //进货单审核日期 payMain.APP_DATETIME = row.APP_DATETIME; //进货单审核人 payMain.APP_USER = row.APP_USER; //应付账单创建日期 payMain.CRT_DATETIME = DateTime.Now; //应付账单创建人 payMain.CRT_USER_ID = userId; //进货单日期 payMain.INPUT_DATE = row.INPUT_DATE; //发票 payMain.INVOICE_ID = row.INVOICE_ID; //应付账单最后修改日期 payMain.LAST_UPDATE = DateTime.Now; //备注 payMain.Memo = row.Memo; //更新时间 payMain.MOD_DATETIME = DateTime.Now; //修改人 payMain.MOD_USER_ID = userId; //预付款 payMain.PRE_PAY = row.PRE_PAY; //预付款单号 payMain.PRE_PAY_ID = row.PRE_PAY_ID; //关联ID payMain.RELATE_ID = row.RELATE_ID; //进货分店编号 payMain.SHOP_ID = row.SHOP_ID; //待核准状态 payMain.STATUS = 1; //供应商编号 payMain.SUP_ID = row.SUP_ID; //进货单号 payMain.TAKEIN_ID = row.TAKEIN_ID; //进货类型 payMain.TAKEIN_TYPE = 1; //一般进货 //进货单金额 payMain.TOT_AMOUNT = amount; //进货单数量 payMain.TOT_QTY = row.TOT_QTY; //税额 payMain.TOT_TAX = tax; payMain.USER_ID = userId; //保存主信息 //payMain.Save(); payList.Add(payMain); //供应商关系已经存在 if (supDic.ContainsKey(payMain.SUP_ID)) { continue; } try { //查询供应商 var sup = selectHelper.SelectSingle <SUPPLIERS>(false, null, new List <ConditionFun.SqlqueryCondition>() { new ConditionFun.SqlqueryCondition(ConstraintType.Where, "SUP_ID", Comparison.Equals, payMain.SUP_ID) }); if (sup != null) { //缓存供应商 supDic[sup.SUP_ID] = sup.SUP_NAME; //分店和供应商关系 SHOP_SUPPLIER_RELATION relation = new SHOP_SUPPLIER_RELATION(); relation.CRT_DATETIME = DateTime.Now; relation.MEMO = "来源汇整进货单"; relation.SHOP_ID = payMain.SHOP_ID; relation.SUP_ID = sup.SUP_ID; relation.SUP_NAME = sup.SUP_NAME; //保存关联关系 relation.Save(); // supList.Add(relation); supDropdown.DataBind(); } } catch (Exception ex) { CommonBll.WriteLog("查询供应商出错", ex); } // } catch (Exception ex) { CommonBll.WriteLog(string.Format("汇整进货单{0}发生异常", row.TAKEIN_ID), ex); } } Grid previewGrid = archivePreviewWindow.FindControl("previewDataPanel").FindControl("previewDataGrid") as Grid; previewGrid.DataSource = payList; previewGrid.DataBind(); archivePreviewWindow.Hidden = false; }
/// <summary> /// 从IIS缓存中获取指定条件的记录 /// </summary> /// <param name="conditionColName">条件列名</param> /// <param name="value">条件值</param> /// <returns>DataAccess.Model.Rank</returns> public DataAccess.Model.Rank GetModelForCache(string conditionColName, object value) { try { //从缓存中获取List var list = GetList(); DataAccess.Model.Rank model = null; Expression <Func <Rank, bool> > expression = null; //返回指定条件的实体 switch (conditionColName) { case "Id": model = list.SingleOrDefault(x => x.Id == (long)value); expression = x => x.Id == (long)value; break; case "RankLevel": model = list.SingleOrDefault(x => x.RankLevel == (string)value); expression = x => x.RankLevel == (string)value; break; case "RankCName": model = list.SingleOrDefault(x => x.RankCName == (string)value); expression = x => x.RankCName == (string)value; break; case "RankEName": model = list.SingleOrDefault(x => x.RankEName == (string)value); expression = x => x.RankEName == (string)value; break; default: return(null); } if (model == null) { //从数据库中读取 var tem = Rank.SingleOrDefault(expression); if (tem == null) { return(null); } else { //对查询出来的实体进行转换 model = Transform(tem); SetModelForCache(model); return(model); } } else { return(model); } } catch (Exception e) { //记录日志 CommonBll.WriteLog("从IIS缓存中获取Rank表记录时出现异常", e); return(null); } }
/// <summary> /// 退货单处理 /// </summary> /// <param name="id">退货单id</param> /// <param name="userId">登陆用户id</param> /// <returns></returns> private bool ProcessBackBill(long id, string userId) { try { //更新核准状态的退货单 int retvalue = updaterHelper.Update(string.Format("update IN_BACK00 set STATUS = 5, LOCKED = 1 where id = {0} and STATUS = 2", id)); if (retvalue == 1) { //账单更新成功 List <ConditionFun.SqlqueryCondition> backCondition = new List <ConditionFun.SqlqueryCondition>(); backCondition.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "Id", Comparison.Equals, id, false, false)); //根据id更新 IN_BACK00 back00 = selectHelper.SelectSingle <IN_BACK00>(false, null, backCondition); if (back00 != null) { List <ConditionFun.SqlqueryCondition> itemConditionList = new List <ConditionFun.SqlqueryCondition>(); itemConditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "SHOP_ID", Comparison.Equals, back00.SHOP_ID, false, false)); itemConditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, "IB_ID", Comparison.Equals, back00.IB_ID, false, false)); //执行查询 List <IN_BACK01> backItemList = selectHelper.Select <IN_BACK01>(false, 0, null, itemConditionList, new List <string>() { "SNo" }).ExecuteTypedList <IN_BACK01>(); if (backItemList == null || backItemList.Count == 0) { CommonBll.WriteLog(string.Format("退货单{0}未查询到明细", back00.IB_ID), null); return(false); } //出货价格 decimal price = 0; //出货成本 decimal cost = 0; //遍历出货单明细插入 foreach (IN_BACK01 item in backItemList) { //累加出货价 price += item.STD_PRICE; //累加成本 cost += item.COST; } RECEIVABLES00 receiveMain = new RECEIVABLES00(); receiveMain.BILL_TYPE = (int)BillType.BackBill; //建档时间 receiveMain.CRT_DATETIME = DateTime.Now; //建档人员 receiveMain.CRT_USER_ID = userId; //出货单日期 receiveMain.INPUT_DATE = back00.INPUT_DATE; //分店编号 receiveMain.IN_SHOP = back00.SHOP_ID; //最后修改日期 receiveMain.LAST_UPDATE = DateTime.Now; //备注 receiveMain.MEMO = back00.Memo; //修改时间 receiveMain.MOD_DATETIME = DateTime.Now; //修改人 receiveMain.MOD_USER_ID = userId; //出货单号 receiveMain.BILL_ID = back00.IB_ID; //总店编号 receiveMain.SHOP_ID = back00.OUT_SHOP; //新建存档状态 receiveMain.STATUS = 1; //出货单的建单人 receiveMain.USER_ID = back00.USER_ID; //出货总价 receiveMain.BILL_AMOUNT = price; //出货总成本 receiveMain.BILL_COST = cost; //5.保存应收账单 receiveMain.Save(); return(true); } } } catch (Exception ex) { CommonBll.WriteLog(string.Format("更新账单发生异常,账单id:{0}", id), ex); } return(false); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 if (string.IsNullOrEmpty(txtName.Text.Trim())) { return(txtName.Label + "不能为空!"); } var sName = StringHelper.Left(txtName.Text, 20); if (InformationClassBll.GetInstence().Exist(x => x.Name == sName && x.Id != id)) { return(txtName.Label + "已存在!请重新输入!"); } #endregion #region 赋值 //定义是否更新其他关联表变量 bool isUpdate = false; var oldParentId = ConvertHelper.Cint0(txtParent.Text); //获取实体 var model = new InformationClass(x => x.Id == id); //判断是否有改变名称 if (id > 0 && sName != model.Name) { isUpdate = true; } //修改时间与管理员 model.UpdateDate = DateTime.Now; model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId(); model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName(); //设置名称 model.Name = sName; //对应的父类id model.ParentId = oldParentId; //设置备注 model.Notes = StringHelper.Left(txtNotes.Text, 100); //由于限制了编辑时不能修改父节点,所以这里只对新建记录时处理 if (id == 0) { //设定当前的深度与设定当前的层数级 if (model.ParentId == 0) { //设定当前的层数级 model.Depth = 0; //父Id为0时,根Id也为0 model.RootId = 0; } else { //设定当前的层数 model.Depth = ConvertHelper.Cint0(InformationClassBll.GetInstence().GetFieldValue(ConvertHelper.Cint0(ddlParentId.SelectedValue), InformationClassTable.Depth)) + 1; //获取父类的父Id model.RootId = ConvertHelper.Cint0(InformationClassBll.GetInstence().GetFieldValue(model.ParentId, InformationClassTable.ParentId)); } //限制分类层数只能为3层 if (model.Depth > 3) { return("信息分类只能创建3层分类!"); } } //设置排序 model.Sort = ConvertHelper.Cint0(txtSort.Text); if (model.Sort == 0) { model.Sort = InformationClassBll.GetInstence().GetSortMax(model.ParentId) + 1; } //设定当前项是否显示 model.IsShow = ConvertHelper.StringToByte(rblIsShow.SelectedValue); //设定当前项是否单页 model.IsPage = ConvertHelper.StringToByte(rblIsPage.SelectedValue); //SEO model.SeoTitle = StringHelper.Left(txtSeoTitle.Text, 100); model.SeoKey = StringHelper.Left(txtSeoKey.Text, 100); model.SeoDesc = StringHelper.Left(txtSeoDesc.Text, 200); #endregion #region 图片 //上传分类大图 if (this.fuClassImg.HasFile && this.fuClassImg.FileName.Length > 3) { int vid = 2; //2 信息(新闻)分类图 //--------------------------------------------------- var upload = new UploadFile(); result = new UploadFileBll().Upload_AspNet(this.fuClassImg.PostedFile, vid, RndKey, OnlineUsersBll.GetInstence().GetManagerId(), OnlineUsersBll.GetInstence().GetManagerCName(), upload); this.fuClassImg.Dispose(); //--------------------------------------------------- if (result.Length == 0)//上传成功 { model.ClassImg = upload.Path; } else { CommonBll.WriteLog("上传出错:" + result, null);//收集异常信息 return("上传出错!" + result); } } //如果是修改,检查用户是否重新上传过新图片,如果是删除旧的图片 if (model.Id > 0) { UploadFileBll.GetInstence().Upload_DiffFile(InformationClassTable.Id, InformationClassTable.ClassImg, InformationClassTable.TableName, model.Id, model.ClassImg); //同步UploadFile上传表 UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, InformationClassTable.TableName, model.Id); } #endregion //---------------------------------------------------------- //存储到数据库 InformationClassBll.GetInstence().Save(this, model); #region 步更新上传图片表绑定Id if (id == 0) { //同步UploadFile上传表记录,绑定刚刚上传成功的文件Id为当前记录Id UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, InformationClassTable.TableName, model.Id); } #endregion //如果本次修改改变了相关名称,则同步更新其他关联表的对应名称 if (isUpdate) { InformationBll.GetInstence().UpdateValue_For_InformationClass_Id(this, model.Id, InformationTable.InformationClass_Name, model.Name); InformationBll.GetInstence().UpdateValue_For_InformationClass_Root_Id(this, model.Id, InformationTable.InformationClass_Root_Name, model.Name); } } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 查询应收账单 /// </summary> /// <param name="startDate">开始日期</param> /// <param name="endDate">结束日期</param> /// <param name="userId"></param> /// <returns></returns> private List <ReceiveBillMain> QueryOutBill(string startDate, string endDate, string userId) { //拼接查询条件 List <ConditionFun.SqlqueryCondition> conditionList = QueryOutListCondition(shopId, startDate, endDate); //1.查询总部出货表OUT00 // 1)出货单状态为 2=核准 // 2)SHOP_ID = 当前登录用户的总部编号 // 3)在指定日期范围内 //2.遍历结果 计算成本和价格 //3.显示预览界面 List <ReceiveBillMain> previewList = new List <ReceiveBillMain>(); //1.查询满足条件的出货单 DataTable dataTable = OUT00Bll.GetInstence().GetDataTable(false, 5000, null, 0, 5000, conditionList, null); if (dataTable == null || dataTable.Rows.Count == 0) { return(previewList); } //2.遍历查询结果 foreach (DataRow row in dataTable.Rows) { try { //4.查询出货单明细 //明细查询条件 List <ConditionFun.SqlqueryCondition> itemConditionList = new List <ConditionFun.SqlqueryCondition>(); itemConditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "SHOP_ID", Comparison.Equals, row["SHOP_ID"], false, false)); itemConditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, "OUT_ID", Comparison.Equals, row["OUT_ID"], false, false)); //执行查询 List <OUT01> outItemList = selectHelper.Select <OUT01>(false, 0, null, itemConditionList, new List <string>() { "SNo" }).ExecuteTypedList <OUT01>(); if (outItemList == null || outItemList.Count == 0) { CommonBll.WriteLog(string.Format("出货单{0}未查询到明细", row["OUT_ID"]), null); continue; } //出货价格 decimal price = 0; //出货成本 decimal cost = 0; //遍历出货单明细插入 foreach (OUT01 item in outItemList) { //累加出货价 price += item.STD_PRICE; //累加成本 cost += item.COST; } ReceiveBillMain receiveMain = new ReceiveBillMain(); receiveMain.Id = Convert.ToInt32(row["Id"].ToString()); receiveMain.BILL_TYPE = (int)BillType.OutBill; //建档时间 receiveMain.CRT_DATETIME = DateTime.Now; //建档人员 receiveMain.CRT_USER_ID = userId; //出货单日期 receiveMain.INPUT_DATE = (DateTime)row["INPUT_DATE"]; //分店编号 receiveMain.IN_SHOP = row["IN_SHOP"].ToString(); //最后修改日期 receiveMain.LAST_UPDATE = DateTime.Now; //备注 receiveMain.MEMO = row["Memo"].ToString(); //修改时间 receiveMain.MOD_DATETIME = DateTime.Now; //修改人 receiveMain.MOD_USER_ID = userId; //出货单号 receiveMain.BILL_ID = row["OUT_ID"].ToString(); //总店编号 receiveMain.SHOP_ID = row["SHOP_ID"].ToString(); //新建存档状态 receiveMain.STATUS = 1; //出货单的建单人 receiveMain.USER_ID = row["USER_ID"].ToString(); //出货总价 receiveMain.BILL_AMOUNT = price; //出货总成本 receiveMain.BILL_COST = cost; previewList.Add(receiveMain); } catch (Exception ex) { CommonBll.WriteLog(string.Format("汇整出货单{0}发生错误。", row["OUT_ID"]), ex); } } return(previewList); }
/// <summary> /// 查询退货账单 /// </summary> /// <param name="startDate"></param> /// <param name="endDate"></param> /// <param name="userId"></param> /// <returns></returns> private List <ReceiveBillMain> QueryBackBill(string startDate, string endDate, string userId) { List <ReceiveBillMain> previewList = new List <ReceiveBillMain>(); List <ConditionFun.SqlqueryCondition> conditionList = new List <ConditionFun.SqlqueryCondition>(); //查询总店的所有应收出货单 conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, OUT00Table.SHOP_ID, Comparison.Equals, shopId, false, false)); //退货单时间 conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, OUT00Table.INPUT_DATE, Comparison.GreaterOrEquals, startDate, false, false)); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, OUT00Table.INPUT_DATE, Comparison.LessOrEquals, endDate, false, false)); //退货单状态为2=核准 conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, OUT00Table.STATUS, Comparison.Equals, 2, false, false)); List <IN_BACK00> backList = selectHelper.Select <IN_BACK00>(true, 5000, null, 0, 5000, conditionList, new List <string>() { "SHOP_ID" }).ExecuteTypedList <IN_BACK00>(); if (backList == null || backList.Count == 0) { return(previewList); } foreach (IN_BACK00 back00 in backList) { try { //查询退货单明细 //明细查询条件 List <ConditionFun.SqlqueryCondition> itemConditionList = new List <ConditionFun.SqlqueryCondition>(); itemConditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "SHOP_ID", Comparison.Equals, back00.SHOP_ID, false, false)); itemConditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, "IB_ID", Comparison.Equals, back00.IB_ID, false, false)); //执行查询 List <IN_BACK01> outItemList = selectHelper.Select <IN_BACK01>(false, 0, null, itemConditionList, new List <string>() { "SNo" }).ExecuteTypedList <IN_BACK01>(); if (outItemList == null || outItemList.Count == 0) { CommonBll.WriteLog(string.Format("出货单{0}未查询到明细", back00.IB_ID, null)); continue; } //出货价格 decimal price = 0; //出货成本 decimal cost = 0; //遍历出货单明细插入 foreach (IN_BACK01 item in outItemList) { //累加出货价 price += item.STD_PRICE; //累加成本 cost += item.COST; } ReceiveBillMain receiveMain = new ReceiveBillMain(); receiveMain.Id = back00.Id; receiveMain.BILL_TYPE = (int)BillType.BackBill; //建档时间 receiveMain.CRT_DATETIME = DateTime.Now; //建档人员 receiveMain.CRT_USER_ID = userId; //出货单日期 receiveMain.INPUT_DATE = back00.INPUT_DATE; //分店编号 receiveMain.IN_SHOP = back00.SHOP_ID; //最后修改日期 receiveMain.LAST_UPDATE = DateTime.Now; //备注 receiveMain.MEMO = back00.Memo; //修改时间 receiveMain.MOD_DATETIME = DateTime.Now; //修改人 receiveMain.MOD_USER_ID = userId; //退货单号 receiveMain.BILL_ID = back00.IB_ID; //总店编号 receiveMain.SHOP_ID = back00.OUT_SHOP; //新建存档状态 receiveMain.STATUS = 1; //出货单的建单人 receiveMain.USER_ID = back00.USER_ID; //退货总价 receiveMain.BILL_AMOUNT = price; //退货总成本 receiveMain.BILL_COST = cost; previewList.Add(receiveMain); } catch (Exception ex) { CommonBll.WriteLog(string.Format("汇整退货单{0}发生错误。", back00.IB_ID, ex)); } } return(previewList); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 //if (string.IsNullOrEmpty(txtAREA_NAME.Text.Trim())) //{ // return txtAREA_NAME.Label + "不能为空!"; //} //var sName = StringHelper.Left(txtName.Text, 50); //if (BranchBll.GetInstence().Exist(x => x.Name == sName && x.Id != id)) //{ // return txtName.Label + "已存在!请重新输入!"; //} //if (string.IsNullOrEmpty(txtId.Text.Trim())) //{ // return txtId.Label + "不能为空!"; //} //var sUrl = StringHelper.Left(txtUrl.Text, 400); //if (BranchBll.GetInstence().Exist(x => x.Url == sUrl && x.Id != id)) //{ // return txtUrl.Label + "已存在!请重新输入!"; //} #endregion #region 赋值 //读取资料 var model = new ORDER00(x => x.Id == id); model.SHOP_ID = txtSHOP_ID.Text; model.ORDER_ID = txtORDER_ID.Text; model.INPUT_DATE = DateTime.Now; // ConvertHelper.StringToDatetime(txtINPUT_DATE.Text); model.ORD_USER = txtORD_USER.Text; model.EXPECT_DATE = DateTime.Now; // ConvertHelper.StringToDatetime(txtEXPECT_DATE.Text); model.STATUS = ConvertHelper.Cint0(ddlStatus.SelectedValue); model.ORD_TYPE = ConvertHelper.Cint0(ddlORD_TYPE.SelectedValue); model.OUT_SHOP = ddlOUT_SHOP.SelectedValue; model.EXPORTED_ID = txtEXPORTED_ID.Text; model.EXPORTED = ConvertHelper.StringToByte(txtEXPORTED.Text); model.APP_USER = txtAPP_USER.Text; model.APP_DATE = DateTime.Now;//ConvertHelper.StringToDatetime(txtAPP_DATE.Text); model.Memo = txtMemo.Text; model.LOCKED = ConvertHelper.StringToByte(cbLOCKED.Checked.ToString()); model.ORD_DEP_ID = ddlBranch.SelectedValue; model.CRT_DATETIME = DateTime.Now; //ConvertHelper.StringToDatetime(txtCRT_DATETIME.Text); model.CRT_USER_ID = txtCRT_USER_ID.Text; model.MOD_DATETIME = DateTime.Now; //ConvertHelper.StringToDatetime(txtMOD_DATETIME.Text); model.MOD_USER_ID = txtMOD_USER_ID.Text; model.LAST_UPDATE = DateTime.Now; //ConvertHelper.StringToDatetime(txtLAST_UPDATE.Text); model.Trans_STATUS = ConvertHelper.StringToByte(txtTrans_STATUS.Text); #endregion //---------------------------------------------------------- //存储到数据库 ORDER00Bll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// Grid点击事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Grid1_RowCommand(object sender, FineUI.GridCommandEventArgs e) { GridRow gr = Grid1.Rows[e.RowIndex]; //获取当前点击列的主键ID object id = gr.DataKeys[0]; //因为要记录修改人,修改时间跟最后更新时间,所以将单字段更新换成多字段更新 switch (e.CommandName) { case "ENABLE": try { var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("ENABLE", ConvertHelper.StringToByte(e.CommandArgument)); dic.Add("MOD_DATETIME", ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"))); dic.Add("MOD_USER_ID", OlUser.Manager_LoginName); dic.Add("LAST_UPDATE", ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"))); PROD_KINDBll.GetInstence().UpdateValue(this, ConvertHelper.Cint0(id), dic); LoadData(); //PROD_KINDBll.GetInstence().Save(this, model); } catch (Exception err) { //出现异常,保存出错日志信息 CommonBll.WriteLog("保存失败", err); } //更新状态 //PROD_KINDBll.GetInstence().UpdateENABLE(this, ConvertHelper.Cint0(id), ConvertHelper.Cint0(e.CommandArgument)); //重新加载 //LoadData(); break; case "ISBOM": try { var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); Dictionary <string, object> dic = new Dictionary <string, object>(); dic.Add("ISBOM", ConvertHelper.StringToByte(e.CommandArgument)); dic.Add("MOD_DATETIME", ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"))); dic.Add("MOD_USER_ID", OlUser.Manager_LoginName); dic.Add("LAST_UPDATE", ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff"))); PROD_KINDBll.GetInstence().UpdateValue(this, ConvertHelper.Cint0(id), dic); LoadData(); //PROD_KINDBll.GetInstence().Save(this, model); } catch (Exception err) { //出现异常,保存出错日志信息 CommonBll.WriteLog("保存失败", err); } //更新状态 //PROD_KINDBll.GetInstence().UpdateISBOM(this, ConvertHelper.Cint0(id), ConvertHelper.Cint0(e.CommandArgument)); //重新加载 //LoadData(); break; case "ButtonEdit": //打开编辑窗口 Window1.IFrameUrl = "ProdKindEdit.aspx?Id=" + id + "&" + MenuInfoBll.GetInstence().PageUrlEncryptStringNoKey(id + ""); Window1.Hidden = false; break; } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Preview_Ok_Click(object sender, EventArgs e) { //获取登录用户 var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); //登录名 string userId = OlUser.Manager_LoginName; Grid previewGrid = archivePreviewWindow.FindControl("previewDataPanel").FindControl("previewDataGrid") as Grid; int[] seelctedRows = previewGrid.SelectedRowIndexArray; if (seelctedRows == null || seelctedRows.Length == 0) { Alert.Show("请选择需要确认的账单!"); return; } int total = 0; foreach (int rowIndex in seelctedRows) { long id = (long)previewGrid.DataKeys[rowIndex][0]; try { int retValue = updaterHelper.Update(string.Format("update TAKEIN10 set STATUS = 5, LOCKED = 1 where Id = {0}", id)); if (retValue == 1) { //查询进货单主信息 List <ConditionFun.SqlqueryCondition> where = new List <ConditionFun.SqlqueryCondition>(); where.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "Id", Comparison.Equals, id, false, false)); TAKEIN10 tAKEIN10 = selectHelper.SelectSingle <TAKEIN10>(true, null, where, null); if (tAKEIN10 == null) { CommonBll.WriteLog("", null); continue; } List <ConditionFun.SqlqueryCondition> condition = new List <ConditionFun.SqlqueryCondition>(); condition.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "TAKEIN_ID", Comparison.Equals, id, false, false)); List <TAKEIN11> itemList = selectHelper.Select <TAKEIN11>(false, 5000, null, 0, 5000, condition, null).ExecuteTypedList <TAKEIN11>(); decimal amount = 0; decimal tax = 0; // foreach (TAKEIN11 item in itemList) { DUE01 payItem = new DUE01(); //批次号 payItem.BAT_NO = item.BAT_NO; //采购金额 payItem.COST = item.STD_PRICE * item.STD_QUAN; //税额 payItem.TAX = item.Tax; //采购金额 amount += payItem.COST; tax += payItem.TAX; } DUE00 payMain = new DUE00(); //进货单审核日期 payMain.APP_DATETIME = tAKEIN10.APP_DATETIME; //进货单审核人 payMain.APP_USER = tAKEIN10.APP_USER; //应付账单创建日期 payMain.CRT_DATETIME = DateTime.Now; //应付账单创建人 payMain.CRT_USER_ID = userId; //进货单日期 payMain.INPUT_DATE = tAKEIN10.INPUT_DATE; //发票 payMain.INVOICE_ID = tAKEIN10.INVOICE_ID; //应付账单最后修改日期 payMain.LAST_UPDATE = DateTime.Now; //备注 payMain.Memo = tAKEIN10.Memo; //更新时间 payMain.MOD_DATETIME = DateTime.Now; //修改人 payMain.MOD_USER_ID = userId; //预付款 payMain.PRE_PAY = tAKEIN10.PRE_PAY; //预付款单号 payMain.PRE_PAY_ID = tAKEIN10.PRE_PAY_ID; //关联ID payMain.RELATE_ID = tAKEIN10.RELATE_ID; //进货分店编号 payMain.SHOP_ID = tAKEIN10.SHOP_ID; //待核准状态 payMain.STATUS = 1; //供应商编号 payMain.SUP_ID = tAKEIN10.SUP_ID; //进货单号 payMain.TAKEIN_ID = tAKEIN10.TAKEIN_ID; //进货类型 payMain.TAKEIN_TYPE = 1; //一般进货 //进货单金额 payMain.TOT_AMOUNT = amount; //进货单数量 payMain.TOT_QTY = tAKEIN10.TOT_QTY; //税额 payMain.TOT_TAX = tax; payMain.USER_ID = userId; //保存主信息 payMain.Save(); total++; } } catch (Exception ex) { CommonBll.WriteLog(string.Format("处理进货单[{0}]发生异常", id), ex); } Alert.Show(string.Format("汇整完成,总共{0}条,成功{1}条", seelctedRows.Length, total)); } }
//#region 页面控件绑定 ///// <summary>下拉列表改变事件 ///// </summary> ///// <param name="sender"></param> ///// <param name="e"></param> //protected void ddlParentId_SelectedIndexChanged(object sender, EventArgs e) //{ // //初始化路径值 // //获取当前节点的父节点Id // // txtParent.Text = ddlParentId.SelectedValue; // if (!ddlParentId.SelectedValue.Equals("0")) // { // try // { // //获取当前节点的父节点url // txtUrl.Text = MenuInfoBll.GetInstence().GetFieldValue(ConvertHelper.Cint0(ddlParentId.SelectedValue), MenuInfoTable.Url) + ""; // } // catch // { // } // } //} //#endregion #region 保存 /// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); // int Branch_Id = int.Parse(ddlParentId.SelectedValue); try { #region 数据验证 if (string.IsNullOrEmpty(txtPosition.Text.Trim())) { return(txtPosition.Label + "不能为空!"); } if (txtPosition.Text.Trim() == "请选择菜单") { return(txtPosition.Label + "不能为请选择菜单!"); } #endregion #region 赋值 //读取指定部门资料 var model = new Solution.DataAccess.DataModel.Position(x => x.Id == id); //设置名称 model.Name = txtPosition.Text; //连接地址 model.Branch_Id = 100; // int.Parse(ddlParentId.SelectedValue); model.Branch_Code = "0100"; // +ddlParentId.SelectedValue; model.Branch_Name = ""; //ddlParentId.SelectedText; ////设定当前的深度与设定当前的层数级 //if (model.ParentId == 0) //{ // //设定当前的层数级 // model.Depth = 0; //} //else //{ // try // { // //设定当前的层数级 // model.Depth = ConvertHelper.Cint0(MenuInfoBll.GetInstence().GetFieldValue(ConvertHelper.Cint0(ddlParentId.SelectedValue), MenuInfoTable.Depth)) + 1; // } // catch // { // model.Depth = 0; // } //} ////设置排序 //if (txtSort.Text == "0") //{ // //model.Sort = ConvertHelper.Cint0(SPs.P_All_GetOrderId(MenuInfoTable.TableName, MenuInfoTable.ParentId, model.ParentId.ToString(), MenuInfoTable.Sort).ExecuteScalar()) + 1; //} //else //{ // model.Sort = ConvertHelper.Cint0(txtSort.Text); //} ////设定当前项属于菜单还是页面 //model.IsMenu = ConvertHelper.StringToByte(rblIsMenu.SelectedValue); ////设定当前项是否显示 //model.IsDisplay = ConvertHelper.StringToByte(rblIsDisplay.SelectedValue); #endregion //---------------------------------------------------------- //存储到数据库 PositionBll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 更新 /// </summary> /// <returns></returns> public string Product00Update() { string result = "0"; string _id = GridViewHelper.GetSelectedKey(Grid1, true); int id = ConvertHelper.Cint0(_id); try { #region 数据验证 var sPROD_ID = PROD_ID.Text.Trim(); if (string.IsNullOrEmpty(PROD_ID.Text.Trim())) { PROD_ID.ShowRedStar = true; return(PROD_ID.Label + "不能为空!"); } if (string.IsNullOrEmpty(PROD_NAME1.Text.Trim())) { return(PROD_NAME1.Label + "不能为空!"); } var sPROD_KIND = PROD_KIND.SelectedValue; if (string.IsNullOrEmpty(sPROD_KIND) || sPROD_KIND == "0") { return(PROD_KIND.Label + "不能为空!"); } var sPROD_DEP = PROD_DEP.SelectedValue; if (string.IsNullOrEmpty(sPROD_DEP) || sPROD_DEP == "0") { return(PROD_DEP.Label + "不能为空!"); } var sPROD_TYPE = PROD_TYPE.SelectedValue; if (string.IsNullOrEmpty(sPROD_DEP)) { return(PROD_TYPE.Label + "不能为空!"); } var sPROD_Source = PROD_Source.SelectedValue; if (string.IsNullOrEmpty(sPROD_Source)) { return(PROD_Source.Label + "不能为空!"); } var sINV_TYPE = INV_TYPE.SelectedValue; if (string.IsNullOrEmpty(sINV_TYPE) || sINV_TYPE == "0") { return(INV_TYPE.Label + "不能为空!"); } var sSTOCK_TYPE = STOCK_TYPE.SelectedValue; if (string.IsNullOrEmpty(sSTOCK_TYPE) || sSTOCK_TYPE == "0") { return(STOCK_TYPE.Label + "不能为空!"); } var sBOM_TYPE = BOM_TYPE.SelectedValue; if (string.IsNullOrEmpty(sBOM_TYPE) || sBOM_TYPE == "0") { return(BOM_TYPE.Label + "不能为空!"); } var sMarginControl = MarginControl.SelectedValue; if (string.IsNullOrEmpty(sMarginControl) || sMarginControl == "0") { return(MarginControl.Label + "不能为空!"); } var sPROD_RangTYPE = PROD_RangTYPE.SelectedValue; if (string.IsNullOrEmpty(sPROD_RangTYPE) || sPROD_RangTYPE == "0") { return(PROD_RangTYPE.Label + "不能为空!"); } var sPROD_iRang = PROD_iRang.Text; if (string.IsNullOrEmpty(sPROD_iRang)) { return(PROD_iRang.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sPROD_iRang)) { return(PROD_iRang.Label + "必须为整数123!"); } var sPROD_UNIT = PROD_UNIT.SelectedValue; if (string.IsNullOrEmpty(sPROD_UNIT) || sPROD_UNIT == "0") { return(PROD_UNIT.Label + "不能为空!"); } var sPROD_CONVERT1 = PROD_CONVERT1.Text; if (string.IsNullOrEmpty(sPROD_CONVERT1)) { return(PROD_CONVERT1.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sPROD_CONVERT1)) { return(PROD_CONVERT1.Label + "必须为整数!"); } var sPROD_UNIT1 = PROD_UNIT1.SelectedValue; if (string.IsNullOrEmpty(sPROD_UNIT1) || sPROD_UNIT1 == "0") { return("包装单位不能为空!"); } var sPROD_CONVERT2 = PROD_CONVERT2.Text; if (string.IsNullOrEmpty(sPROD_CONVERT2)) { return(PROD_CONVERT2.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sPROD_CONVERT2)) { return(PROD_CONVERT2.Label + "必须为整数!"); } var sPROD_UNIT2 = PROD_UNIT2.SelectedValue; if (string.IsNullOrEmpty(sPROD_UNIT2) || sPROD_UNIT2 == "0") { return("外箱单位不能为空!"); } var sReport_UNIT = Report_UNIT.SelectedValue; if (string.IsNullOrEmpty(sReport_UNIT) || sReport_UNIT == "0") { return(Report_UNIT.Label + "不能为空!"); } sPROD_ID = StringHelper.Left(sPROD_ID, 50); if (!PRODUCT00Bll.GetInstence().Exist(x => x.PROD_ID == sPROD_ID) && id != 0) { return(PROD_ID.Label + "不存在!请重新输入!"); } string sPROD_NAME1 = PROD_NAME1.Text.Trim(); if (PRODUCT00Bll.GetInstence().Exist(x => x.PROD_NAME1 == sPROD_NAME1 && x.PROD_ID != sPROD_ID) && id != 0) { return(PROD_NAME1.Label + "与其他商品重复!请重新输入!"); } #endregion #region 赋值 var model = new PRODUCT00(x => x.PROD_ID == sPROD_ID); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); //if (model.PROD_ID == sPROD_ID) //{ // model.SetIsNew(false); //} //else //{ // model.SetIsNew(true); //} model.PROD_ID = sPROD_ID; model.PROD_NAME1 = PROD_NAME1.Text; model.PROD_NAME1_SPELLING = PROD_NAME1_SPELLING.Text; model.PROD_NAME2 = PROD_NAME2.Text; model.PROD_KIND = sPROD_KIND; model.PROD_DEP = sPROD_DEP; model.PROD_CATE = PROD_CATE.SelectedValue; model.PROD_TYPE = ConvertHelper.StringToByte(PROD_TYPE.SelectedValue); model.DIV_ID = DIV_ID.SelectedValue; model.INV_TYPE = ConvertHelper.Cint(sINV_TYPE); model.STOCK_TYPE = ConvertHelper.Cint(sSTOCK_TYPE); model.BOM_TYPE = ConvertHelper.Cint(sBOM_TYPE); model.MarginControl = ConvertHelper.Cint(sMarginControl); model.PROD_RangTYPE = ConvertHelper.Cint(sPROD_RangTYPE); model.PROD_iRang = ConvertHelper.Cint(sPROD_iRang); model.PROD_SPEC = PROD_SPEC.Text; model.PROD_Margin = PROD_Margin.Text; model.PROD_BARCODE = PROD_BARCODE.Text; model.PROD_UNIT = sPROD_UNIT; model.PROD_UNIT1 = sPROD_UNIT1; model.PROD_CONVERT1 = ConvertHelper.Cint(sPROD_CONVERT1); model.PROD_UNIT2 = sPROD_UNIT2; model.PROD_CONVERT2 = ConvertHelper.Cint(sPROD_CONVERT2); model.Report_UNIT = ConvertHelper.Cint(sReport_UNIT); model.PROD_MEMO = PROD_MEMO.Text; if (id == 0) { model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.CRT_USER_ID = OlUser.Manager_LoginName; } else { model.CRT_DATETIME = model.CRT_DATETIME; model.CRT_USER_ID = model.CRT_USER_ID; } //model.CRT_USER_ID = ""; model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.MOD_USER_ID = OlUser.Manager_LoginName; //model.MOD_USER_ID = ""; model.LAST_UPDATE = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.STATUS = 0; #endregion ////---------------------------------------------------------- ////存储到数据库 model.SetIsNew(false); //PRODUCT00Bll.GetInstence().Save(this, model, null, false, true); result = result + "\r\n" + Product01Update(); if (!String.IsNullOrEmpty(result)) { PRODUCT00Bll.GetInstence().Save(this, model); PRODUCT00Bll.GetInstence().Insert_PRODUCT01(sPROD_ID, model.CRT_USER_ID); result = "商品资料更新成功"; LoadData(); LoadData2(sPROD_ID); } } catch (Exception e) { result = "更新失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
///// <summary> ///// 更换分店事件 ///// </summary> ///// <param name="sender"></param> ///// <param name="e"></param> //protected void shopIdDropdown_SelectedIndexChanged(object sender, EventArgs e) //{ // LoadData(); //} /// <summary> /// 汇整出货单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Archive_Click(object sender, EventArgs e) { archiveWindow.Hidden = true; //获取登录用户 var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); //登录名 string userId = OlUser.Manager_LoginName; //获取用户所属shop shopId = OlUser.SHOP_ID; DatePicker dpStart = archiveWindow.FindControl("archiveDatePanel").FindControl("outStartDate") as DatePicker; DatePicker dpEnd = archiveWindow.FindControl("archiveDatePanel").FindControl("outEndDate") as DatePicker; //拼接查询条件 List <ConditionFun.SqlqueryCondition> conditionList = QueryOutListCondition(shopId, dpStart.Text, dpEnd.Text); //1.查询总部出货表 // 1)出货单状态为 2=核准 // 2)SHOP_ID = 当前登录用户的总部编号 // 3)在指定日期范围内 //2.遍历结果 //3.更新出货单状态为5=月结(关单), 并且锁定出货单(LOCKED=1) //4.更新成功后查询出货单明细更新到应收明细表 //5.保存应收主信息 //6.保存应收明细 int total = 0; //循环查询 while (true) { //1.查询满足条件的出货单 DataTable dataTable = OUT00Bll.GetInstence().GetDataTable(false, 100, null, 0, 100, conditionList, null); if (dataTable == null || dataTable.Rows.Count == 0) { break; } //2.遍历查询结果 foreach (DataRow row in dataTable.Rows) { try { //3.更新出货单状态为5=月结(关单) int retValue = updaterHelper.Update(string.Format("update OUT00 set STATUS = 5, LOCKED = 1 where id = {0} and STATUS = 2", row["Id"])); //更新成功 汇整出货单 if (retValue == 1) { //4.查询出货单明细 //明细查询条件 List <ConditionFun.SqlqueryCondition> itemConditionList = new List <ConditionFun.SqlqueryCondition>(); itemConditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "SHOP_ID", Comparison.Equals, row["SHOP_ID"], false, false)); itemConditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.And, "OUT_ID", Comparison.Equals, row["OUT_ID"], false, false)); //执行查询 List <OUT01> outItemList = selectHelper.Select <OUT01>(false, 0, null, itemConditionList, new List <string>() { "SNo" }).ExecuteTypedList <OUT01>(); if (outItemList == null || outItemList.Count == 0) { CommonBll.WriteLog(string.Format("出货单{0}未查询到明细", row["OUT_ID"]), null); continue; } //出货价格 decimal price = 0; //出货成本 decimal cost = 0; //遍历出货单明细插入 foreach (OUT01 item in outItemList) { //累加出货价 price += item.STD_PRICE; //累加成本 cost += item.COST; //应收明细 RECEIVABLES01 receiveItem = new RECEIVABLES01(); //出货批号 receiveItem.BAT_NO = item.BAT_NO; //出货成本 receiveItem.COST = item.COST; //明细备注 receiveItem.MEMO = item.MEMO; //出货单ID receiveItem.OUT_ID = item.OUT_ID; //商品编号 receiveItem.PROD_ID = item.PROD_ID; //验收量 receiveItem.QUAN1 = item.QUAN1; //取消量 receiveItem.QUAN2 = item.QUAN2; //总店编号 receiveItem.SHOP_ID = item.SHOP_ID; //明细序号 receiveItem.SNo = item.SNo; //出货价格 receiveItem.STD_PRICE = item.STD_PRICE; //出货量 receiveItem.STD_QUAN = item.STD_QUAN; //出货单位 receiveItem.STD_UNIT = item.STD_UNIT; //6.保存明细 receiveItem.Save(); } RECEIVABLES00 receiveMain = new RECEIVABLES00(); //receiveMain.APP_DATETIME //receiveMain.APP_USER = ""; //建档时间 receiveMain.CRT_DATETIME = DateTime.Now; //建档人员 receiveMain.CRT_USER_ID = userId; //出货单日期 receiveMain.INPUT_DATE = (DateTime)row["INPUT_DATE"]; //分店编号 receiveMain.IN_SHOP = row["IN_SHOP"].ToString(); //最后修改日期 receiveMain.LAST_UPDATE = DateTime.Now; //备注 receiveMain.MEMO = row["Memo"].ToString(); //修改时间 receiveMain.MOD_DATETIME = DateTime.Now; //修改人 receiveMain.MOD_USER_ID = userId; //出货单号 receiveMain.OUT_ID = row["OUT_ID"].ToString(); //总店编号 receiveMain.SHOP_ID = row["SHOP_ID"].ToString(); //新建存档状态 receiveMain.STATUS = 1; //出货单的建单人 receiveMain.USER_ID = row["USER_ID"].ToString(); //出货总价 receiveMain.BILL_AMOUNT = price; //出货总成本 receiveMain.BILL_COST = cost; //5.保存应收账单 receiveMain.Save(); total++; } } catch (Exception ex) { CommonBll.WriteLog(string.Format("汇整出货单{0}发生错误。", row["OUT_ID"]), ex); } } //已处理到最后一页 if (dataTable.Rows.Count < 100) { break; } //等待2秒 Thread.Sleep(2000); } Thread.Sleep(5000); Alert.Show(string.Format("汇整完成,共汇整{0}条出货单.", total)); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 if (string.IsNullOrEmpty(txtSHOP_NAME1.Text.Trim())) { return(txtSHOP_NAME1.Label + "不能为空!"); } if (ddlSHOP_Price_Area.SelectedText.Trim() == "请选择价格区域") { ddlSHOP_Price_Area.Label = "价格区域不能为空"; } //var sName = StringHelper.Left(txtName.Text, 50); //if (BranchBll.GetInstence().Exist(x => x.Name == sName && x.Id != id)) //{ // return txtName.Label + "已存在!请重新输入!"; //} //if (string.IsNullOrEmpty(txtId.Text.Trim())) //{ // return txtId.Label + "不能为空!"; //} //var sUrl = StringHelper.Left(txtUrl.Text, 400); //if (BranchBll.GetInstence().Exist(x => x.Url == sUrl && x.Id != id)) //{ // return txtUrl.Label + "已存在!请重新输入!"; //} #endregion #region 赋值 //读取资料 var model = new SHOP00(x => x.Id == id); model.SHOP_ID = txtSHOP_ID.Text; model.SHOP_NAME1 = txtSHOP_NAME1.Text; model.SHOP_NAME2 = txtSHOP_NAME2.Text; model.SHOP_KIND = ConvertHelper.Cint0(txtSHOP_KIND.Text.ToString()); model.SHOP_Area_ID = ConvertHelper.Cint0(txtSHOP_Area_ID.SelectedValue.ToString()); model.SHOP_Price_Area = ddlSHOP_Price_Area.SelectedValue.ToString(); model.SHOP_ADD = txtSHOP_ADD.Text; model.SHOP_TEL = txtSHOP_TEL.Text; model.SHOP_EMAIL = txtSHOP_EMAIL.Text; model.SHOP_CONTECT = txtSHOP_CONTECT.Text; model.SHOP_MEMO = txtSHOP_MEMO.Text; model.SHOP_STATUS = ConvertHelper.StringToByte(txtSHOP_STATUS.Text); model.SHOP_Limited = ConvertHelper.Cint0(txtSHOP_Limited.Text); model.CRT_DATETIME = ConvertHelper.StringToDatetime(txtCRT_DATETIME.Text); model.CRT_USER_ID = txtCRT_USER_ID.Text; model.CRT_DATETIME = ConvertHelper.StringToDatetime(txtCRT_DATETIME.Text); model.MOD_USER_ID = txtMOD_USER_ID.Text; model.MOD_DATETIME = ConvertHelper.StringToDatetime(txtMOD_DATETIME.Text); model.LAST_UPDATE = ConvertHelper.StringToDatetime(txtLAST_UPDATE.Text); model.STATUS = ConvertHelper.StringToByte(txtSTATUS.Text); #endregion //---------------------------------------------------------- //存储到数据库 SHOP00Bll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }