/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 if (string.IsNullOrEmpty(txtTitle.Text.Trim())) { return(txtTitle.Label + "不能为空!"); } if (ddlInformationClass_Id.SelectedValue == "0") { return(ddlInformationClass_Id.Label + "为必选项,请选择!"); } //判断是否重复 var sTitle = StringHelper.FilterSql(txtTitle.Text, true); var icId = ConvertHelper.Cint0(ddlInformationClass_Id.SelectedValue); if ( DataAccess.DataModel.Information.Exists( x => x.Title == sTitle && x.InformationClass_Id == icId && x.Id != id)) { return(txtTitle.Label + "已存在!请重新输入!"); } #endregion #region 赋值 //获取实体 var model = new Information(x => x.Id == id); //------------------------------------------ //设置名称 model.Title = StringHelper.Left(txtTitle.Text, 100); //取得分类 model.InformationClass_Id = ConvertHelper.Cint0(ddlInformationClass_Id.SelectedValue); model.InformationClass_Root_Id = ConvertHelper.Cint0(InformationClassBll.GetInstence() .GetFieldValue(model.InformationClass_Id, InformationClassTable.ParentId)); if (model.InformationClass_Root_Id > 0) { model.InformationClass_Root_Name = InformationClassBll.GetInstence() .GetName(this, model.InformationClass_Root_Id); } model.InformationClass_Name = StringHelper.Left(ddlInformationClass_Id.SelectedText, 20); //重定向 model.RedirectUrl = StringHelper.Left(txtRedirectUrl.Text, 250); //------------------------------------------ //编辑器 model.Content = StringHelper.Left(txtText.Text, 0, true, false); model.Upload = StringHelper.Left(txtUpload.Text, 0, true, false); //这里必须用回前端存放的Key,不然删除时无法同步删除编辑器上传的图片 RndKey = StringHelper.Left(txtRndKey.Text, 0); //检查用户上传的文件和最后保存的文件是否有出入, //如果上传的文件大于保存的文件,把不保存,但本次操作已经上传的文件删除。 model.Upload = UploadFileBll.GetInstence().FCK_BatchDelPic(model.Content, model.Upload); //------------------------------------------ //其它值 model.NewsTime = dpNewsTime.SelectedDate ?? DateTime.Now; model.AddYear = model.NewsTime.Year; model.AddMonth = model.NewsTime.Month; model.AddDay = model.NewsTime.Day; model.Notes = StringHelper.Left(txtNotes.Text, 200); model.Keywords = StringHelper.Left(txtKeywords.Text, 50); model.Author = StringHelper.Left(txtAuthor.Text, 50); model.FromName = StringHelper.Left(txtFromName.Text, 50); model.SeoTitle = StringHelper.Left(txtSeoTitle.Text, 100); model.SeoKey = StringHelper.Left(txtSeoKey.Text, 100); model.SeoDesc = StringHelper.Left(txtSeoDesc.Text, 200); model.Sort = 0; //设定当前项是否显示 model.IsDisplay = ConvertHelper.StringToByte(rblIsDisplay.SelectedValue); model.IsHot = ConvertHelper.StringToByte(rblIsHot.SelectedValue); model.IsTop = ConvertHelper.StringToByte(rblIsTop.SelectedValue); //------------------------------------------ //判断是否是新增 if (model.Id == 0) { //添加时间与用户 model.AddDate = DateTime.Now; //修改时间与用户 model.UpdateDate = DateTime.Now; } else { //修改时间与用户 model.UpdateDate = DateTime.Now; } model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId(); model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName(); #endregion //------------------------------------------ #region 图片 if (this.filePhoto.HasFile && this.filePhoto.FileName.Length > 3) { int vid = 3; //3 文章封面 //--------------------------------------------------- var upload = new UploadFile(); result = new UploadFileBll().Upload_AspNet(this.filePhoto.PostedFile, vid, RndKey, OnlineUsersBll.GetInstence().GetManagerId(), OnlineUsersBll.GetInstence().GetManagerCName(), upload); this.filePhoto.Dispose(); //--------------------------------------------------- if (result.Length == 0) //上传成功 { model.FrontCoverImg = upload.Path; } else { CommonBll.WriteLog("上传出错:" + result); //收集异常信息 return("上传出错!" + result); } } //如果是修改,检查用户是否重新上传过封面图片,如果是删除旧的图片 if (model.Id > 0) { UploadFileBll.GetInstence() .Upload_DiffFile(InformationTable.Id, InformationTable.FrontCoverImg, InformationTable.TableName, model.Id, model.FrontCoverImg); //同步UploadFile上传表 UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, InformationTable.TableName, model.Id); } #endregion //---------------------------------------------------------- //存储到数据库 InformationBll.GetInstence().Save(this, model); #region 步更新上传图片表绑定Id if (id == 0) { //同步UploadFile上传表记录,绑定刚刚上传成功的文件Id为当前记录Id UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, InformationTable.TableName, model.Id); } #endregion } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
protected void btnImport_Click(object sender, EventArgs e) { //判断 FineUI.RadioButton RaddpUp_Date = Window2.FindControl("A").FindControl("RaddpUp_Date") as FineUI.RadioButton; FineUI.RadioButton RadEXPECT_DATE = Window2.FindControl("B").FindControl("RadEXPECT_DATE") as FineUI.RadioButton; if (RaddpUp_Date.Checked == false && RadEXPECT_DATE.Checked == false) { Alert.Show("请选择时间"); return; } string Start_Time = ""; string End_Time = ""; //参数 Random ran = new Random(); string SHOP_ID = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); string COL_ID = SHOP_ID + "CL" + DateTime.Now.ToString("yyyy-MM-dd") + +ran.Next(1000, 9999); string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名 int IsTime = 1; if (RaddpUp_Date.Checked) { //获取时间 DatePicker dpUp_DateBeg = Window2.FindControl("A").FindControl("dpUp_DateBeg") as DatePicker; DateTime dt_up_date_bg = ConvertHelper.StringToDatetime(dpUp_DateBeg.SelectedDate.ToString()); DatePicker dpUp_DateEnd = Window2.FindControl("A").FindControl("dpUp_DateEnd") as DatePicker; DateTime dt_up_date_end = ConvertHelper.StringToDatetime(dpUp_DateEnd.SelectedDate.ToString()); IsTime = 0; Start_Time = dt_up_date_bg.ToString(); End_Time = dt_up_date_end.ToString(); } if (RadEXPECT_DATE.Checked) { DatePicker dpEXPECT_DATEBeg = Window2.FindControl("B").FindControl("dpEXPECT_DATEBeg") as DatePicker; DateTime dt_expect_date_bg = ConvertHelper.StringToDatetime(dpEXPECT_DATEBeg.SelectedDate.ToString()); DatePicker dpEXPECT_DATEEnd = Window2.FindControl("B").FindControl("dpEXPECT_DATEEnd") as DatePicker; DateTime dt_expect_date_end = ConvertHelper.StringToDatetime(dpEXPECT_DATEEnd.SelectedDate.ToString()); IsTime = 1; Start_Time = dt_expect_date_bg.ToString(); End_Time = dt_expect_date_end.ToString(); } int ex_int = TAKEIN00Bll.GetInstence().LeadIntoProductPlanList(Start_Time, End_Time, IsTime.ToString(), SHOP_ID, manager_LoginName); if (ex_int == 0) { Alert.Show("引入成功!"); } else { Alert.Show("引入失败!请重新引入!"); } LoadData(); }
/// <summary> /// 主表保存 /// </summary> /// <returns></returns> public string MAINEdit() { string _TAKEIN_ID = tbxTAKEIN_ID.Text; try { var model = new TAKEIN10(x => x.TAKEIN_ID == _TAKEIN_ID); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); string _SHOP_ID = ddlSHOP_NAME.SelectedValue; if (String.IsNullOrEmpty(_TAKEIN_ID)) { model.SetIsNew(true); model.CRT_DATETIME = DateTime.Now; model.CRT_USER_ID = OlUser.Manager_LoginName; DataTable dt = new DataTable(); dt = (DataTable)SPs.Get_ORDER_SEED(_SHOP_ID, "TAKEIN10").ExecuteDataTable(); _TAKEIN_ID = dt.Rows[0]["PLANE_ID"].ToString(); tbxTAKEIN_ID.Text = _TAKEIN_ID; //var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == _Pur00_id); } model.SHOP_ID = _SHOP_ID; model.TAKEIN_ID = _TAKEIN_ID.ToString(); model.STATUS = ConvertHelper.Cint(ddlStatus.SelectedValue); model.INPUT_DATE = ConvertHelper.StringToDatetime(dpINPUT_DATE.SelectedDate.ToString()); if (String.IsNullOrEmpty(ddlSUP_ID.SelectedValue)) { model.SUP_ID = ""; } else { model.SUP_ID = ddlSUP_ID.SelectedValue; } model.STOCK_ID = ddlSTOCK_ID.SelectedValue; model.USER_ID = OlUser.Manager_LoginName; model.APP_USER = OlUser.Manager_LoginName; model.APP_DATETIME = tbxAPP_DATETIME.Text == "" ? DateTime.Parse("1900-01-01 00:00:00") : DateTime.Now; string _RELATE_ID = tbxRELATE_ID.Text; model.RELATE_ID = _RELATE_ID; //if (!String.IsNullOrEmpty(_RELATE_ID)) //{ // var modelOrder = new OUT_BACK00(x => x.BK_ID == _RELATE_ID); // modelOrder.Exported = 1; // modelOrder.Exported_ID = _TAKEIN_ID; // modelOrder.Save(); //} model.Memo = tbxMemo.Text; model.LOCKED = ConvertHelper.StringToByte(ckLOCKED.Checked ? "1" : "0"); model.MOD_DATETIME = DateTime.Now; model.MOD_USER_ID = OlUser.Manager_LoginName; model.LAST_UPDATE = DateTime.Now; model.Trans_STATUS = 0; TAKEIN10Bll.GetInstence().Save(this, model); LoadMAIN(); } catch (Exception err) { return(err.Message); } return(""); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 if (string.IsNullOrEmpty(CATE_ID.Text.Trim())) { return(CATE_ID.Label + "不能为空!"); } if (string.IsNullOrEmpty(CATE_NAME.Text.Trim())) { return(CATE_NAME.Label + "不能为空!"); } if (string.IsNullOrEmpty(DEP_ID.SelectedValue) || DEP_ID.SelectedValue == "0") { return(DEP_ID.Label + "不能为空!"); } var sCate_id = StringHelper.Left(CATE_ID.Text, 50); if (PROD_CateBll.GetInstence().Exist(x => x.CATE_ID == sCate_id) && id == 0) { return(CATE_ID.Label + "已存在!请重新输入!"); } //var sMeno = StringHelper.Left(UNIT_MENO.Text, 40); //if (UNIT_MENO.Text.Trim().Length > 40) //{ // return UNIT_MENO.Label + "超长!"; //} #endregion #region 赋值 var model = new PROD_Cate(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.CATE_ID = CATE_ID.Text; model.CATE_NAME = CATE_NAME.Text; model.CATE_MEMO = CATE_MEMO.Text; model.ENABLE = ConvertHelper.StringToByte(ENABLE.SelectedValue); model.DEP_ID = DEP_ID.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 = false; #endregion ////---------------------------------------------------------- ////存储到数据库 PROD_CateBll.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); try { #region 数据验证 if (string.IsNullOrEmpty(txtLoginName.Text.Trim())) { return(txtLoginName.Label + "不能为空!"); } if (SHOPdll.SelectedText.Trim() == "请选择分店") { return(SHOPdll.Label + "不能为空!"); } var sName = StringHelper.Left(txtLoginName.Text, 50); if (ManagerBll.GetInstence().Exist(x => x.LoginName == sName && x.Id != id)) { return(txtLoginName.Label + "已存在!请重新输入!"); } if (string.IsNullOrEmpty(txtPwd.Text.Trim())) { return(txtPwd.Label + "不能为空!"); } #endregion #region 赋值 //读取指定部门资料 var model = new Manager(x => x.Id == id); model.LoginName = txtLoginName.Text; model.LoginPass = model.LoginPass == txtPwd.Text.Trim()?model.LoginPass: Encrypt.Md5(Encrypt.Md5(txtPwd.Text));//:model.LoginPass; model.LoginPass == null? model.LoginTime = DateTime.Now; model.LoginIp = "1::"; model.LoginCount = 1; model.CreateTime = DateTime.Now; model.UpdateTime = DateTime.Now; int branch_id = ConvertHelper.Cint0(Brachddl.SelectedValue); var model_b = BranchBll.GetInstence().GetModelForCache(x => x.Id == branch_id); model.Branch_Id = model_b.Id; model.Branch_Code = model_b.Code; model.Branch_Name = model_b.Name; model.IsMultiUser = ConvertHelper.StringToByte(rblIsMultiUser.SelectedValue.ToString()); model.IsWork = ConvertHelper.StringToByte(rblIsWork.SelectedValue); model.IsEnable = ConvertHelper.StringToByte(rblIsEnable.SelectedValue); var model_p = PositionBll.GetInstence().GetModelForCache(x => x.Id == ConvertHelper.Cint0(Positionddl.SelectedValue)); model.Position_Id = model_p.Id.ToString(); model.Position_Name = model_p.Name; model.CName = txtCName.Text; model.EName = txtEName.Text; model.Sex = rblSex.SelectedValue.ToString(); model.PhotoImg = ""; model.Birthday = Birthday.SelectedDate.ToString(); model.NativePlace = txtNativePlace.Text; model.NationalName = txtNationalName.Text; model.Record = txtRecord.Text; model.GraduateCollege = txtGraduateCollege.Text; model.GraduateSpecialty = txtGraduateSpecialty.Text; model.Tel = txtTel.Text; model.Tel = txtMobile.Text; model.Email = txtEmail.Text; model.Qq = txtQq.Text; model.Msn = ""; model.Address = txtAddress.Text; model.Content = txtContent.Text; model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId(); model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName(); model.SHOP_ID = SHOPdll.SelectedValue; model.SHOP_NAME1 = SHOPdll.SelectedText; #endregion //---------------------------------------------------------- //存储到数据库 ManagerBll.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 == OnlineUsersBll.GetInstence().GetUserHashKey()); 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"))); if (ConvertHelper.Cint0(id) > 0) { PROD_DEPBll.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 "ButtonEdit": //打开编辑窗口 Window1.IFrameUrl = "ProdDepEdit.aspx?Id=" + id + "&" + MenuInfoBll.GetInstence().PageUrlEncryptStringNoKey(id + ""); Window1.Hidden = false; break; } }
public void btnEditCon_Click(Object sender, EventArgs e) { try { //int Grid3RowIndex = ConvertHelper.Cint(Grid3Rowindex.Text); string _CONTRACT_ID = tbxCONTRACT_ID.Text.ToString(); if (String.IsNullOrEmpty(_CONTRACT_ID)) { FineUI.Alert.ShowInParent("未选择商品", FineUI.MessageBoxIcon.Information); return; } FineUI.Grid Grid4 = Window3.FindControl("PanelGrid4").FindControl("Grid4") as FineUI.Grid; int[] selections = Grid4.SelectedRowIndexArray; if (selections.Length == 0) { FineUI.Alert.ShowInParent("请选择一行", FineUI.MessageBoxIcon.Information); return; } foreach (int i in selections) { int _Id = ConvertHelper.Cint(Grid4.DataKeys[i][0].ToString()); if (_Id > 0) { JObject defaultObj = new JObject(); var model = new PRODUCT00(x => x.Id == _Id); //暂时保留后期可能优化 string _UserHashKey = Session[OnlineUsersTable.UserHashKey].ToString(); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); DataSet dsCom = (DataSet)SPs.Get_CONTRACT01_PRODUCT01(_UserHashKey, model.PROD_ID).ExecuteDataSet(); if (dsCom.Tables.Count > 0) { if (dsCom.Tables[0].Rows.Count > 0) { defaultObj.Add("Id01", 0); defaultObj.Add("CONTRACT_ID01", _CONTRACT_ID); defaultObj.Add("PROD_ID01", model.PROD_ID); defaultObj.Add("PROD_NAME01", model.PROD_NAME1); defaultObj.Add("CONTRACT_PRICE01", dsCom.Tables[0].Rows[0]["COST"].ToString()); defaultObj.Add("CONTRACT_PRICE101", dsCom.Tables[0].Rows[0]["COST1"].ToString()); defaultObj.Add("CONTRACT_PRICE201", dsCom.Tables[0].Rows[0]["COST2"].ToString()); defaultObj.Add("USABLE01", true); defaultObj.Add("Meno01", ""); defaultObj.Add("CRT_USER_ID01", OlUser.Manager_LoginName); defaultObj.Add("CRT_DATETIME01", DateTime.Now.ToString()); defaultObj.Add("MOD_USER_ID01", OlUser.Manager_LoginName); defaultObj.Add("MOD_DATETIME01", DateTime.Now.ToString()); Grid2.AddNewRecord(defaultObj, true); } else { FineUI.Alert.ShowInParent("添加失败", FineUI.MessageBoxIcon.Information); } } else { FineUI.Alert.ShowInParent("添加失败", FineUI.MessageBoxIcon.Information); } } } } catch (Exception err) { FineUI.Alert.ShowInParent("添加失败:" + err.Message, FineUI.MessageBoxIcon.Information); } }
public void ProcessRequest(HttpContext context) { //--------------------------------------------------- var m_r = new UploadFile(); int vid = 0, userId = 0; const int userType = 1; string key = "", msg = "", userName = ""; //--------------------------------------------------- bool isSwf = (RequestHelper.PostText("swf", 1) == "1"); if (isSwf) { vid = RequestHelper.PostInt0("vid"); key = RequestHelper.PostText("key", 20); if (!StringHelper.IsRndKey(key)) { key = ""; } if (vid < 1 || key.Length < 10) { ShowMsg_Swf("缺少参数:key或sid"); return; } //--------------------------------------------------- #region 判断权限 userId = RequestHelper.PostInt0("uid"); if (userId < 1) { ShowMsg_Swf("缺少参数:uid"); return; } string uk = RequestHelper.PostText("uk", 32); if (uk.Length < 10) { ShowMsg_Swf("缺少参数:uk"); return; } string userKey = OnlineUsersBll.GetInstence().GetMd5(ConvertHelper.Cint0(userId)); if (userKey != uk) { ShowMsg_Swf("还未登陆,权限不足!"); return; } userName = OnlineUsersBll.GetInstence().GetManagerCName(ConvertHelper.Cint0(userId)); #endregion //--------------------------------------------------- msg = new UploadFileBll().Upload_Web(vid, key, userId, userName, m_r, "imgFile", userType, false, true); //--------------------------------------------------- if (msg.Length > 0) { ShowMsg_Swf(msg); } else { //上传成功,输出结果 ShowMsg_Swf("", 0, ConvertHelper.Cint0(m_r.Id), m_r.Name, m_r.Path, m_r.Src); } } else { //--------------------------------------------------- bool isEditor = (RequestHelper.GetQueryString("act") == "edit"); vid = RequestHelper.GetInt0("vid"); key = RequestHelper.GetKeyChar("key", 20); if (vid < 1 || key.Length < 10) { ShowMsg_Swf("缺少参数:key或sid"); return; } //--------------------------------------------------- #region 判断权限 if (SessionHelper.GetSession("UserHashKey") != null) { var uinfo = OnlineUsersBll.GetInstence().GetOnlineUsersModel(); userId = uinfo.Manager_Id; userName = uinfo.Manager_CName; } else { msg = "还未登陆,权限不足!"; if (isEditor)//编辑器 (ke4) { ShowMsg_Editor(msg); } else { //RequestHelper.AlertUtf8(msg, 3, ""); FineUI.Alert.Show(msg, "提示", MessageBoxIcon.Warning, "history.back();"); } return; } #endregion //--------------------------------------------------- msg = new UploadFileBll().Upload_Web(vid, key, userId, userName, m_r, "imgFile", userType, isEditor, false); if (msg.Length > 0) { if (isEditor)//编辑器 (ke4) { ShowMsg_Editor(msg); } else { //RequestHelper.AlertUtf8(msg, 3, ""); FineUI.Alert.Show(msg, "提示", MessageBoxIcon.Warning, "history.back();"); } } else { //上传成功,输出结果 if (isEditor)//编辑器 (ke4) { ShowMsg_Editor("上传成功", m_r.Path); } else { //RequestHelper.AlertUtf8("window.parent.OnUploadCompleted('" + m_r.Name + "','" + m_r.Path + "'," + m_r.Id.ToString() + ",'" + m_r.Src + "');", 7, ""); FineUI.Alert.Show("上传失败", "提示", MessageBoxIcon.Warning, "window.parent.OnUploadCompleted('" + m_r.Name + "','" + m_r.Path + "'," + m_r.Id.ToString() + ",'" + m_r.Src + "');"); } } } Write("系统暂时禁止上传文件!"); return; }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; string order_id = hidId.Text; try { #region 数据验证 // FineUI.DropDownList dddlPROD_NAME1 = Window2.FindControl("ddlPROD_NAME1") as FineUI.DropDownList; if (ddlPROD_NAME1.SelectedText == "请选择") { return(ddlPROD_NAME1.Label + "请选择!"); } // FineUI.TextBox ttxtPROD_ID = Window2.FindControl("txtPROD_ID") as FineUI.TextBox; if (string.IsNullOrEmpty(txtPROD_ID.Text.Trim())) { return(txtPROD_ID.Label + "不能为空!"); } // FineUI.TextBox ttxtPROD_UNIT = Window2.FindControl("txtPROD_UNIT") as FineUI.TextBox; if (string.IsNullOrEmpty(txtPROD_UNIT.Text.Trim())) { return(txtPROD_UNIT.Label + "不能为空!"); } // FineUI.TextBox ttxtTotal = Window2.FindControl("txtTotal") as FineUI.TextBox; if (string.IsNullOrEmpty(txtTotal.Text.Trim())) { return(txtTotal.Label + "不能为空!"); } // FineUI.TextBox ttxtU_Cost = Window2.FindControl("txtU_Cost") as FineUI.TextBox; if (string.IsNullOrEmpty(txtU_Cost.Text.Trim())) { return(txtU_Cost.Label + "不能为空!"); } // FineUI.TextBox ttxtOrder_QUAN = Window2.FindControl("txtOrder_QUAN") as FineUI.TextBox; if (string.IsNullOrEmpty(txtOrder_QUAN.Text.Trim())) { return(txtOrder_QUAN.Label + "不能为空!"); } // FineUI.TextBox ttxtON_QUAN = Window2.FindControl("txtON_QUAN") as FineUI.TextBox; if (string.IsNullOrEmpty(txtON_QUAN.Text.Trim()) || txtON_QUAN.Text == "0") { return(txtON_QUAN.Label + "不能为空或者0!"); } // FineUI.TextBox ttxtMemo = Window2.FindControl("txtMemo") as FineUI.TextBox; #endregion #region 赋值 int id = ConvertHelper.Cint0(SNo.Text); //读取资料 var model_0 = new ORDER00(x => x.ORDER_ID == order_id); //序号 conditionList = new List <ConditionFun.SqlqueryCondition>(); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER01Table.ORDER_ID, Comparison.Equals, order_id, false, false)); if (IsEdit) { id = ConvertHelper.Cint0(GridViewHelper.GetSelectedKey(Grid2, true)); } else { id = ORDER01Bll.GetInstence().GetRecordCount(conditionList) + 1; } var model = new ORDER01(x => x.ORDER_ID == order_id && x.SNo == id); model.SHOP_ID = model_0.SHOP_ID;//分店编号 model.SNo = id; model.PROD_ID = txtPROD_ID.Text.Trim(); model.ORDER_ID = order_id; model.ON_QUAN = ConvertHelper.StringToDecimal(txtON_QUAN.Text.Trim()); model.QUAN1 = ConvertHelper.StringToDecimal(txtTotal.Text); model.QUAN2 = 0; model.COST_PRICE = 0; model.STD_UNIT = txtPROD_UNIT.Text; model.STD_CONVERT = 0; model.QUANTITY = model.STD_QUAN * model.STD_CONVERT; model.STD_QUAN = ConvertHelper.StringToDecimal(txtON_QUAN.Text); model.STD_PRICE = ConvertHelper.StringToDecimal(txtU_Cost.Text); model.Memo = txtMemo.Text; model.CRT_DATETIME = DateTime.Now; model.CRT_USER_ID = OnlineUsersBll.GetInstence().GetManagerCName(); model.MOD_DATETIME = DateTime.Now; model.MOD_USER_ID = OnlineUsersBll.GetInstence().GetManagerCName(); #endregion //---------------------------------------------------------- //存储到数据库 ORDER01Bll.GetInstence().Save(this, model); // Window2.Hidden = true; BindGrid2(); MessageBox.Show(this, "保存成功!"); // PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } 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); 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 + "不能为空!"); } var sOrder_UNIT = Order_UNIT.SelectedValue; if (string.IsNullOrEmpty(sOrder_UNIT) || sOrder_UNIT == "0") { return(Order_UNIT.Label + "不能为空!"); } var sOrder_Quan = Order_QUAN.Text; if (string.IsNullOrEmpty(sOrder_Quan) || sOrder_Quan == "0") { return(Order_QUAN.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sOrder_Quan)) { return(Order_QUAN.Label + "必须为整数!"); } var sPurchase_UNIT = Purchase_UNIT.SelectedValue; if (string.IsNullOrEmpty(sPurchase_UNIT) || sPurchase_UNIT == "0") { return(Purchase_UNIT.Label + "不能为空!"); } var sPurchase_QUAN = Purchase_QUAN.Text; if (string.IsNullOrEmpty(sPurchase_QUAN)) { return(Purchase_QUAN.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sPurchase_QUAN)) { return(Purchase_QUAN.Label + "必须为整数!"); } var sSAFE_QUAN = SAFE_QUAN.Text; if (string.IsNullOrEmpty(sSAFE_QUAN)) { return(SAFE_QUAN.Label + "不能为空!"); } if (!ConvertHelper.IsInt(sSAFE_QUAN)) { return(SAFE_QUAN.Label + "必须为整数!"); } sPROD_ID = StringHelper.Left(sPROD_ID, 50); if (PRODUCT00Bll.GetInstence().Exist(x => x.PROD_ID == sPROD_ID) && id == 0) { return(PROD_ID.Label + "已存在!请重新输入!"); } //var sMeno = StringHelper.Left(UNIT_MENO.Text, 40); //if (UNIT_MENO.Text.Trim().Length > 40) //{ // return UNIT_MENO.Label + "超长!"; //} #endregion #region 赋值 var model = new PRODUCT00(x => x.Id == id); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); model.PROD_ID = sPROD_ID; model.PROD_NAME1 = PROD_NAME1.Text; model.PROD_NAME2 = PROD_NAME2.Text; model.PROD_KIND = sPROD_KIND; model.PROD_DEP = sPROD_DEP; model.PROD_CATE = PROD_CATE.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 ////---------------------------------------------------------- ////存储到数据库 PRODUCT00Bll.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); try { #region 数据验证 if (string.IsNullOrEmpty(txtLoginName.Text.Trim())) { return(txtLoginName.Label + "不能为空!"); } var logName = StringHelper.Left(txtLoginName.Text, 20); if (Manager.Exists(x => x.LoginName == logName && x.Id != id)) { return(txtLoginName.Label + "已存在!请重新输入!"); } //新增用户时,密码不能为空 if (id == 0 && string.IsNullOrEmpty(txtLoginPass.Text.Trim())) { return("密码不能为空!"); } //密码长度不能短于6位 if (!string.IsNullOrEmpty(txtLoginPass.Text.Trim()) && txtLoginPass.Text.Trim().Length < 6) { return("密码长度必须6位以上,请重新输入!"); } if (!txtLoginPass.Text.Equals(txtLoginPassaAgin.Text)) { return("两次输入的密码不一样,请重新输入!"); } if (string.IsNullOrEmpty(txtCName.Text.Trim())) { return(txtCName.Label + "不能为空!"); } //所属部门 if (ConvertHelper.Cint0(ddlBranch_Id.SelectedValue) < 1) { return(ddlBranch_Id.Label + "为必选项,请选择!"); } //所属职位 if (string.IsNullOrEmpty(hidPositionId.Text)) { return(txtPosition.Label + "为必选项,请选择!"); } #endregion #region 赋值 //获取实体 var model = new Manager(x => x.Id == id); model.LoginName = logName; //如果是添加管理员 if (id == 0) { model.CreateTime = DateTime.Now; model.UpdateTime = DateTime.Now; model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId(); model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName(); model.LoginPass = Encrypt.Md5(Encrypt.Md5(txtLoginPass.Text)); model.IsWork = 1; } else { //修改时间与管理员 model.UpdateTime = DateTime.Now; model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId(); model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName(); //修改用户时,填写了密码,则更新密码 if (txtLoginPass.Text.Trim().Length >= 6) { model.LoginPass = Encrypt.Md5(Encrypt.Md5(txtLoginPass.Text)); } } model.Branch_Id = ConvertHelper.Cint0(ddlBranch_Id.SelectedValue); var branch = BranchBll.GetInstence().GetModelForCache(x => x.Id == model.Branch_Id); if (branch != null) { model.Branch_Code = branch.Code; model.Branch_Name = branch.Name; } model.Position_Id = StringHelper.Left(hidPositionId.Text, 100); model.Position_Name = StringHelper.Left(txtPosition.Text, 500); model.CName = StringHelper.Left(txtCName.Text, 20); model.EName = StringHelper.Left(txtEName.Text, 50); model.Sex = StringHelper.Left(rblSex.SelectedValue, 4); model.Birthday = StringHelper.Left(dpBirthday.Text, 20); model.Record = StringHelper.Left(txtRecord.Text, 25); model.GraduateCollege = StringHelper.Left(txtGraduateCollege.Text, 30); model.GraduateSpecialty = StringHelper.Left(txtGraduateSpecialty.Text, 50); model.Tel = StringHelper.Left(txtTel.Text, 30); model.Mobile = StringHelper.Left(txtMobile.Text, 30); model.Email = StringHelper.Left(txtEmail.Text, 50); model.Qq = StringHelper.Left(txtQq.Text, 30); model.Msn = StringHelper.Left(txtMsn.Text, 30); model.Address = StringHelper.Left(txtAddress.Text, 100); model.IsEnable = ConvertHelper.Ctinyint(rblIsEnable.SelectedValue); model.IsMultiUser = ConvertHelper.Ctinyint(rblIsMultiUser.SelectedValue); model.Content = StringHelper.Left(txtContent.Text, 0); model.NationalName = StringHelper.Left(txtNationalName.Text, 50); model.NativePlace = StringHelper.Left(txtNativePlace.Text, 100); #region 图片 if (this.fuSinger_AvatarPath.HasFile && this.fuSinger_AvatarPath.FileName.Length > 3) { int vid = 1; //1 管理员头像(头像图片) //--------------------------------------------------- var upload = new UploadFile(); result = new UploadFileBll().Upload_AspNet(this.fuSinger_AvatarPath.PostedFile, vid, RndKey, OnlineUsersBll.GetInstence().GetManagerId(), OnlineUsersBll.GetInstence().GetManagerCName(), upload); this.fuSinger_AvatarPath.Dispose(); //--------------------------------------------------- if (result.Length == 0)//上传成功 { model.PhotoImg = upload.Path; } else { CommonBll.WriteLog("上传管理员头像图片未成功:" + result, null);//收集异常信息 return("上传管理员头像图片未成功!" + result); } } //如果是修改,检查用户是否重新上传过封面图片,如果是删除旧的图片 if (model.Id > 0) { UploadFileBll.GetInstence().Upload_DiffFile(ManagerTable.Id, ManagerTable.PhotoImg, ManagerTable.TableName, model.Id, model.PhotoImg); //同步UploadFile上传表 UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, ManagerTable.TableName, model.Id); } #endregion #endregion //---------------------------------------------------------- //存储到数据库 ManagerBll.GetInstence().Save(this, model); #region 步更新上传图片表绑定Id if (id == 0) { //同步UploadFile上传表记录,绑定刚刚上传成功的文件Id为当前记录Id UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, ManagerTable.TableName, model.Id); } #endregion } 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); try { #region 数据验证 if (string.IsNullOrEmpty(txtName.Text.Trim())) { return(txtName.Label + "不能为空!"); } var sName = StringHelper.Left(txtName.Text, 50); if (AdvertisingPositionBll.GetInstence().Exist(x => x.Name == sName && x.Id != id)) { return(txtName.Label + "已存在!请重新输入!"); } if (string.IsNullOrEmpty(txtKey.Text.Trim())) { return(txtKey.Label + "不能为空!"); } var sKeyword = StringHelper.Left(txtKey.Text, 50); if (AdvertisingPositionBll.GetInstence().Exist(x => x.Keyword == sKeyword && x.Id != id)) { return(txtKey.Label + "已存在!请重新输入!"); } #endregion #region 赋值 //定义是否更新其他关联表变量 bool isUpdate = false; //读取当前地址信息 var model = new AdvertisingPosition(x => x.Id == id); //判断是否更新关联表 if (model.Id > 0 && sName != model.Name) { isUpdate = true; } //设置名称 model.Name = StringHelper.Left(txtName.Text, 50); //KEY model.Keyword = StringHelper.Left(txtKey.Text, 50); //对应的父类id model.ParentId = ConvertHelper.Cint0(txtParent.Text); //由于限制了编辑时不能修改父节点,所以这里只对新建记录时处理 if (id == 0) { //设定当前的深度与设定当前的层数级 if (model.ParentId == 0) { //设定当前的层数级 model.Depth = 0; } else { //设定当前的层数 model.Depth = ConvertHelper.Cint0(AdvertisingPositionBll.GetInstence().GetFieldValue(ConvertHelper.Cint0(ddlParentId.SelectedValue), AdvertisingPositionTable.Depth)) + 1; } //限制分类层数只能为2层 if (model.Depth > 2) { return("广告位置只能创建2层分类!"); } } //设置排序 if (txtSort.Text == "0") { model.Sort = AdvertisingPositionBll.GetInstence().GetSortMax(model.ParentId) + 1; } else { model.Sort = ConvertHelper.Cint0(txtSort.Text); } //设定当前项是否显示 model.IsDisplay = ConvertHelper.StringToByte(rblIsDisplay.SelectedValue); //广告宽与高 model.Width = ConvertHelper.Cint0(txtWidth.Text); model.Height = ConvertHelper.Cint0(txtHeight.Text); //添加最后修改人员 model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId(); model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName(); model.AddDate = DateTime.Now; #endregion #region 图片 //上传广告位置图 if (this.MapImg.HasFile && this.MapImg.FileName.Length > 3) { int vid = 5; //5 广告位置图 //--------------------------------------------------- var upload = new UploadFile(); result = new UploadFileBll().Upload_AspNet(this.MapImg.PostedFile, vid, RndKey, OnlineUsersBll.GetInstence().GetManagerId(), OnlineUsersBll.GetInstence().GetManagerCName(), upload); this.MapImg.Dispose(); //--------------------------------------------------- if (result.Length == 0)//上传成功 { model.MapImg = upload.Path; } else { CommonBll.WriteLog("上传出错:" + result, null);//收集异常信息 return("上传出错!" + result); } } //如果是修改,检查用户是否重新上传过新图片,如果是删除旧的图片 if (model.Id > 0) { UploadFileBll.GetInstence().Upload_DiffFile(AdvertisingPositionTable.Id, AdvertisingPositionTable.MapImg, AdvertisingPositionTable.TableName, model.Id, model.MapImg); //同步UploadFile上传表 UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, AdvertisingPositionTable.TableName, model.Id); } //—————————————————————————————————————————————————————————————————————— //上传广告默认图 if (this.PicImg.HasFile && this.PicImg.FileName.Length > 3) { int vid = 6; //6 广告默认图 //--------------------------------------------------- var upload = new UploadFile(); result = new UploadFileBll().Upload_AspNet(this.PicImg.PostedFile, vid, RndKey, OnlineUsersBll.GetInstence().GetManagerId(), OnlineUsersBll.GetInstence().GetManagerCName(), upload); this.PicImg.Dispose(); //--------------------------------------------------- if (result.Length == 0)//上传成功 { model.PicImg = upload.Path; } else { CommonBll.WriteLog("上传出错:" + result, null);//收集异常信息 return("上传出错!" + result); } } //如果是修改,检查用户是否重新上传过默认图片,如果是删除旧的图片 if (model.Id > 0) { UploadFileBll.GetInstence().Upload_DiffFile(AdvertisingPositionTable.Id, AdvertisingPositionTable.PicImg, AdvertisingPositionTable.TableName, model.Id, model.PicImg); //同步UploadFile上传表 UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, AdvertisingPositionTable.TableName, model.Id); } #endregion //---------------------------------------------------------- //存储到数据库 AdvertisingPositionBll.GetInstence().Save(this, model); #region 步更新上传图片表绑定Id if (id == 0) { //同步UploadFile上传表记录,绑定刚刚上传成功的文件Id为当前记录Id UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, AdvertisingPositionTable.TableName, model.Id); } #endregion //如果本次修改改变了相关名称,则同步更新其他关联表的对应名称 if (isUpdate) { AdvertisementBll.GetInstence().UpdateValue_For_AdvertisingPosition_Id(this, model.Id, AdvertisementTable.AdvertisingPosition_Name, model.Name); } } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
///// /////取消 //public override void Cancel() //{ //} #region 保存 /// <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 + "不能为空!"); } if (string.IsNullOrEmpty(txtAREA_ID.Text.Trim())) { return(txtAREA_ID.Label + "不能为空!"); } int area_id = ConvertHelper.Cint0(txtAREA_ID.Text.Trim()); Expression <Func <DataAccess.Model.GROUPAREA, bool> > list = null; list = x => x.AREA_ID == area_id; if (GROUPAREABll.GetInstence().Exist(list)) { return(txtAREA_ID.Label + "区域ID不能重复!"); } //var sUrl = StringHelper.Left(txtUrl.Text, 400); //if (BranchBll.GetInstence().Exist(x => x.Url == sUrl && x.Id != id)) //{ // return txtUrl.Label + "已存在!请重新输入!"; //} #endregion int userId = OnlineUsersBll.GetInstence().GetManagerId(); #region 赋值 //读取资料 var model = new GROUPAREA(x => x.Id == id); model.AREA_ID = ConvertHelper.Cint0(txtAREA_ID.Text); model.AREA_NAME = txtAREA_NAME.Text; model.AREA_ADD = txtAREA_ADD.Text; model.AREA_TEL = txtAREA_TEL.Text; model.AREA_EMAIL = txtAREA_EMAIL.Text; model.AREA_CONTECT = txtAREA_CONTECT.Text; model.AREA_MEMO = txtAREA_MEMO.Text; model.AREA_STATUS = ConvertHelper.StringToByte(ddlAREA_STATUS.SelectedValue); model.CRT_DATETIME = DateTime.Now.ToString(); model.CRT_USER_ID = userId.ToString(); model.MOD_DATETIME = DateTime.Now; model.MOD_USER_ID = userId.ToString(); model.LAST_UPDATE = DateTime.Now; model.STATUS = 0; #endregion //---------------------------------------------------------- //存储到数据库 GROUPAREABll.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); try { #region 数据验证 if (string.IsNullOrEmpty(txtName.Text.Trim())) { return(txtName.Label + "不能为空!"); } var sName = StringHelper.Left(txtName.Text, 20); if (UploadConfigBll.GetInstence().Exist(x => x.Name == sName && x.Id != id)) { return(txtName.Label + "已存在!请重新输入!"); } if (string.IsNullOrEmpty(txtJoinName.Text.Trim())) { return(txtJoinName.Label + "不能为空!"); } if (ddlUploadTypeId.SelectedValue == "0") { return(ddlUploadTypeId.Label + "为必选项,请选择后再保存!"); } if (string.IsNullOrEmpty(txtPicSize.Text.Trim())) { return(txtPicSize.Label + "不能为空!"); } if (string.IsNullOrEmpty(txtFileSize.Text.Trim())) { return(txtFileSize.Label + "不能为空!"); } if (string.IsNullOrEmpty(txtSaveDir.Text.Trim())) { return(txtSaveDir.Label + "不能为空!"); } #endregion #region 赋值 //获取实体 var model = new UploadConfig(x => x.Id == id); model.Name = sName; model.JoinName = StringHelper.Left(txtJoinName.Text, 30); model.UserType = (byte)ConvertHelper.Cint1(rblUserType.SelectedValue); //读取上传类型 model.UploadType_Id = ConvertHelper.Cint0(ddlUploadTypeId.SelectedValue); var uploadTypeModel = UploadTypeBll.GetInstence().GetModelForCache(model.UploadType_Id); if (uploadTypeModel != null) { model.UploadType_Name = uploadTypeModel.Name; model.UploadType_TypeKey = uploadTypeModel.TypeKey; } //上传限制 model.PicSize = ConvertHelper.Cint0(txtPicSize.Text); model.FileSize = ConvertHelper.Cint0(txtFileSize.Text); model.SaveDir = StringHelper.Left(txtSaveDir.Text, 50); model.IsPost = ConvertHelper.Ctinyint(rblIsPost.SelectedValue); model.IsEditor = ConvertHelper.Ctinyint(rblIsEditor.SelectedValue); model.IsSwf = ConvertHelper.Ctinyint(rblIsSwf.SelectedValue); model.IsChkSrcPost = ConvertHelper.Ctinyint(brlIsChkSrcPost.SelectedValue); //按比例生成 model.IsFixPic = ConvertHelper.Ctinyint(rblIsFixPic.SelectedValue); model.CutType = ConvertHelper.Cint0(ddlCutType.SelectedValue); model.PicWidth = ConvertHelper.Cint0(txtPicWidth.Text); model.PicHeight = ConvertHelper.Cint0(txtPicHeight.Text); model.PicQuality = ConvertHelper.Cint0(txtPicQuality.Text); //大图 model.IsBigPic = ConvertHelper.Ctinyint(rblIsBigPic.SelectedValue); model.BigWidth = ConvertHelper.Cint0(txtBigWidth.Text); model.BigHeight = ConvertHelper.Cint0(txtBigHeight.Text); model.BigQuality = ConvertHelper.Cint0(txtBigQuality.Text); //中图 model.IsMidPic = ConvertHelper.Ctinyint(rblIsMidPic.SelectedValue); model.MidWidth = ConvertHelper.Cint0(txtMidWidth.Text); model.MidWidth = ConvertHelper.Cint0(txtMidWidth.Text); model.MidHeight = ConvertHelper.Cint0(txtMidHeight.Text); //小图 model.IsMinPic = ConvertHelper.Ctinyint(rblIsMinPic.SelectedValue); model.MinWidth = ConvertHelper.Cint0(txtMinWidth.Text); model.MinWidth = ConvertHelper.Cint0(txtMinWidth.Text); model.MinHeight = ConvertHelper.Cint0(txtMinHeight.Text); //推荐图 model.IsHotPic = ConvertHelper.Ctinyint(rblIsHotPic.SelectedValue); model.HotWidth = ConvertHelper.Cint0(txtHotWidth.Text); model.HotWidth = ConvertHelper.Cint0(txtHotWidth.Text); model.HotHeight = ConvertHelper.Cint0(txtHotHeight.Text); //加水印 model.IsWaterPic = ConvertHelper.Ctinyint(rblIsWaterPic.SelectedValue); //修改时间与管理员 model.UpdateDate = DateTime.Now; model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId(); model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName(); #endregion //---------------------------------------------------------- //存储到数据库 UploadConfigBll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 核准按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void BtnPur00_Approval(Object sender, EventArgs e) { string Pur00_ID = tbxPurchase_ID.Text.ToString(); var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == Pur00_ID); if (model == null) { FineUI.Alert.ShowInParent("订单单号不存在", FineUI.MessageBoxIcon.Information); return; } if (model.STATUS == 1) { DataTable dsCom = (DataTable)SPs.Get_MAX_Inventory_DATE().ExecuteDataTable(); DateTime dtInput = DateTime.Parse(dsCom.Rows[0]["INPUT_DATE"].ToString()); if (model.INPUT_DATE.CompareTo(dtInput) <= 0) { FineUI.Alert.ShowInParent("单据小于盘点日期,不允许盘点。盘点日期为:" + dsCom.Rows[0]["INPUT_DATE"].ToString() + "", FineUI.MessageBoxIcon.Information); return; } } //1 = 存档 2 = 核准 3 = 作废 4 = 已引入(供应商进货) switch (model.STATUS) { case 1: model.STATUS = 2; break; case 2: model.STATUS = 1; break; case 3: FineUI.Alert.ShowInParent("订单已作废,无法进行核准", FineUI.MessageBoxIcon.Information); return; case 4: FineUI.Alert.ShowInParent("订单已引入,无法进行核准", FineUI.MessageBoxIcon.Information); return; default: FineUI.Alert.ShowInParent("订单状态有误,无法核准", FineUI.MessageBoxIcon.Information); return; } ddlStatus.SelectedValue = model.STATUS.ToString(); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); model.MOD_DATETIME = DateTime.Now; model.LAST_UPDATE = DateTime.Now; model.MOD_USER_ID = OlUser.Manager_LoginName; string result = ""; try { Purchase00Bll.GetInstence().Save(this, model); } catch (Exception err) { result = err.Message; } //BtnPur01_Edit(sender, e); //string result = Pur01_Edit(); if (String.IsNullOrEmpty(result)) { result = Pur_Edit(); } LoadPur(); LoadDataPur01(); FineUI.Alert.ShowInParent(result, FineUI.MessageBoxIcon.Error); //FineUI.Alert.ShowInParent("核准成功", FineUI.MessageBoxIcon.Information); }
/// <summary> /// 子表保存 /// </summary> /// <returns></returns> public string DetailEdit() { JArray jarr = Grid2.GetMergedData(); var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); string result = ""; int n = 0; for (int i = 0; i < jarr.Count; i++) { try { var model2 = new PREPARE01(); //string str = jarr[i]["status"].ToString(); if (jarr[i]["status"].ToString().Equals("modified")) { model2.SetIsNew(false); } else if (jarr[i]["status"].ToString().Equals("unchanged")) { continue; } else { model2.SetIsNew(true); } model2.SHOP_ID = jarr[i]["values"]["SHOP_ID01"].ToString(); if (!String.IsNullOrEmpty(jarr[i]["values"]["PREPARE_ID01"].ToString())) { model2.PREPARE_ID = jarr[i]["values"]["PREPARE_ID01"].ToString(); } else { return("保存失败"); } model2.SNo = ConvertHelper.Cint(jarr[i]["values"]["SNo01"].ToString()); model2.PROD_ID = jarr[i]["values"]["PROD_ID01"].ToString(); model2.QUANTITY = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUANTITY01"].ToString()); model2.STD_UNIT = jarr[i]["values"]["STD_UNIT01"].ToString(); model2.STD_CONVERT = ConvertHelper.Cint(jarr[i]["values"]["STD_CONVERT01"].ToString()); model2.STD_QUAN = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_QUAN01"].ToString()); model2.STD_PRICE = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_PRICE01"].ToString()); model2.COST = ConvertHelper.StringToDecimal(jarr[i]["values"]["COST01"].ToString()); model2.QUAN1 = 0; model2.QUAN2 = 0; model2.sProd_ID = jarr[i]["values"]["sProd_ID01"].ToString(); model2.BAT_NO = ConvertHelper.Cint(jarr[i]["values"]["BAT_NO01"].ToString()); model2.IsScales = ConvertHelper.StringToByte(jarr[i]["values"]["IsScales01"].ToString()); model2.IsFlag = ConvertHelper.StringToByte(jarr[i]["values"]["IsFlag01"].ToString()); model2.Scales_User = jarr[i]["values"]["Scales_User01"].ToString(); model2.Scale_Date = DateTime.Now; model2.MEMO = jarr[i]["values"]["MEMO01"].ToString(); PREPARE01Bll.GetInstence().Save(this, model2); } catch (Exception err) { n++; result = "明细保存失败" + n + "条"; } } return(result); }
/// <summary> /// 采购主表更新 /// </summary> /// <returns></returns> public string Pur01_Edit() { #region 校验数据 string _SHOP_ID = ddlSHOP_NAME.SelectedValue; if (String.IsNullOrEmpty(_SHOP_ID)) { //FineUI.Alert.ShowInParent("分店编码不允许为空", FineUI.MessageBoxIcon.Error); return("分店编码不允许为空"); } //string _EXPECT_DATE = dpAPP_DATETIME.SelectedDate.ToString(); //if (dpAPP_DATETIME.SelectedDate < DateTime.Now) //{ // //FineUI.Alert.ShowInParent("期望日期不能小于当前时间", FineUI.MessageBoxIcon.Error); // return "期望日期不能小于当前时间"; //} string _SUP_ID = ddlSHOP_NAME.SelectedValue; if (String.IsNullOrEmpty(_SUP_ID)) { //FineUI.Alert.ShowInParent("厂商不能为空", FineUI.MessageBoxIcon.Error); return("厂商不能为空"); } #endregion string _Pur00_id = tbxPurchase_ID.Text; var model = Purchase00.SingleOrDefault(x => x.Purchase_ID == _Pur00_id); if (model == null) { //FineUI.Alert.ShowInParent("采购单号已存在不允许添加", FineUI.MessageBoxIcon.Error); return("该订单不存在"); } else { try { var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); //model = new Purchase00(); model.SHOP_ID = _SHOP_ID; model.STATUS = 1; model.INPUT_DATE = DateTime.Now; model.EXPECT_DATE = ConvertHelper.StringToDatetime(dpEXPECT_DATE.SelectedDate.ToString()); model.SUP_ID = ddlSUP_NAME.SelectedValue.ToString(); model.PAY_STATUS = ConvertHelper.Cint(ddlPAY_STATUS.SelectedValue); model.USER_ID = OlUser.Manager_LoginName; model.APP_USER = ""; model.APP_DATETIME = ConvertHelper.StringToDatetime("1900-01-01 00:00:00"); model.TOT_AMOUNT = 0; model.TOT_TAX = ConvertHelper.StringToDecimal(numTOT_QTY.Text); model.TOT_QTY = 0; model.PRE_PAY = 0; model.PRE_PAY_ID = ""; model.EXPORTED = 0; model.EXPORTED_ID = ""; model.LOCKED = 0; model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToLongDateString()); model.CRT_USER_ID = OlUser.Manager_LoginName; model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToLongDateString()); model.MOD_USER_ID = OlUser.Manager_LoginName; model.LAST_UPDATE = ConvertHelper.StringToDatetime(DateTime.Now.ToLongDateString()); model.SetIsNew(false); Purchase00Bll.GetInstence().Save(this, model); LoackPur01(); //FineUI.Alert.ShowInParent("保存成功", FineUI.MessageBoxIcon.Error); return(""); } catch (Exception err) { return(err.Message); } } }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; string order_id = hidId.Text; try { #region 数据验证 if (ddlPROD_NAME1.Text.Trim() == "请选择商品名称") { return(ddlPROD_NAME1.Label + "请选择商品名称!"); } if (string.IsNullOrEmpty(txtPROD_ID.Text.Trim())) { return(txtPROD_ID.Label + "不能为空!"); } if (string.IsNullOrEmpty(txtPROD_UNIT.Text.Trim())) { return(txtPROD_UNIT.Label + "不能为空!"); } if (string.IsNullOrEmpty(txtU_Cost.Text.Trim())) { return(txtU_Cost.Label + "不能为空!"); } if (string.IsNullOrEmpty(txtOrder_QUAN.Text.Trim())) { return(txtOrder_QUAN.Label + "不能为空!"); } #endregion #region 赋值 int id = ConvertHelper.Cint0(RequestHelper.GetQueryString("Id")); //读取资料 var model_0 = new ORDER00(x => x.ORDER_ID == order_id); var model = new ORDER01(x => x.ORDER_ID == order_id && x.Id == id); model.SHOP_ID = model_0.SHOP_ID;//分店编号 //序号 conditionList = new List <ConditionFun.SqlqueryCondition>(); conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER01Table.ORDER_ID, Comparison.Equals, order_id, false, false)); model.SNo = ORDER01Bll.GetInstence().GetRecordCount(conditionList) + 1; model.PROD_ID = txtPROD_ID.Text.Trim(); model.ORDER_ID = order_id; model.ON_QUAN = ConvertHelper.StringToDecimal(txtON_QUAN.Text.Trim()); model.QUAN1 = 0; model.QUAN2 = 0; model.COST_PRICE = 0; model.STD_UNIT = txtPROD_UNIT.Text; model.STD_CONVERT = 0; model.QUANTITY = model.STD_QUAN * model.STD_CONVERT; model.STD_QUAN = ConvertHelper.StringToDecimal(txtON_QUAN.Text); model.STD_PRICE = ConvertHelper.StringToDecimal(txtU_Cost.Text); model.Memo = txtMemo.Text; model.CRT_DATETIME = DateTime.Now; model.CRT_USER_ID = OnlineUsersBll.GetInstence().GetManagerCName(); model.MOD_DATETIME = DateTime.Now; model.MOD_USER_ID = OnlineUsersBll.GetInstence().GetManagerCName(); #endregion //---------------------------------------------------------- //存储到数据库 ORDER01Bll.GetInstence().Save(this, model); // PageContext.RegisterStartupScript(ActiveWindow.GetHidePostBackReference()); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 // CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// Contract00保存与更新 /// </summary> /// <param name="isNew"></param> /// <returns></returns> public string Contract00Edit(bool isNew) { string result = ""; result = CheckContract00(); if (!String.IsNullOrEmpty(result)) { return(result); } try { CONTRACT00 model = null; var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); if (isNew == true) { model = new CONTRACT00(); model.SetIsNew(true); model.CONTRACT_ID = tbxCONTRACT_ID.Text; model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.CRT_USER_ID = OlUser.Manager_LoginName; } else { int _id = ConvertHelper.Cint(hidId.Text.ToString()); model = new CONTRACT00(x => x.Id == _id); model.SetIsNew(false); model.CONTRACT_ID = model.CONTRACT_ID; } model.MOD_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.MOD_USER_ID = OlUser.Manager_LoginName; model.CONTRACT_TITLE = tbxCONTRACT_TITLE.Text; if (cbxUSABLE.Checked == true) { model.USABLE = 1; } else { model.USABLE = 0; } if (cbxLOCK.Checked == true) { model.LOCK = 1; } else { model.LOCK = 0; } model.CONTRACTP_SIGN = ConvertHelper.StringToDatetime(dpkCONTRACTP_SIGN.Text.ToString()); model.CONTRACTP_STARTTIME = ConvertHelper.StringToDatetime(dpkCONTRACTP_STARTTIME.Text.ToString()); model.CONTRACTP_ENDTIME = ConvertHelper.StringToDatetime(dpkCONTRACTP_ENDTIME.Text.ToString()); model.FIRST_PARTY = tbxFIRST_PARTY.Text; model.SECEND_PARTY = tbxSECEND_PARTY.SelectedValue.ToString(); model.Meno = tbxMeno.Text; CONTRACT00Bll.GetInstence().Save(this, model); result = ""; } catch (Exception err) { result = "保存失败"; } return(result); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; var branchId = ConvertHelper.Cint0(hidBranchId.Text); var positionId = ConvertHelper.Cint0(hidPositionId.Text); try { #region 数据验证 if (branchId == 0) { return("非法路径进入!"); } if (string.IsNullOrEmpty(txtName.Text.Trim())) { return(txtName.Label + "不能为空!"); } //同一个部门里职位不能样同,不同部门可以有同名称的职位 var sName = StringHelper.Left(txtName.Text, 30); if (PositionBll.GetInstence().Exist(x => x.Branch_Id == branchId && x.Name == sName && x.Id != positionId)) { return(txtName.Label + "已存在!请重新输入!"); } #endregion #region 赋值 //定义是否更新其他关联表变量 bool isUpdate = false; //获取实体 var model = new Position(x => x.Id == positionId); //判断是否有改变名称 if (positionId > 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; //设置部门 var branchModel = BranchBll.GetInstence().GetModelForCache(branchId); model.Branch_Id = branchId; model.Branch_Name = branchModel.Name; model.Branch_Code = branchModel.Code; //设置职位权限 //从树列表中获取勾选的节点 GetCheckTreeNode(MenuTree.Nodes); //赋予权限 model.PagePower = StringHelper.FilterSql(_hidPositionPagePower); model.ControlPower = StringHelper.FilterSql(_hidPositionControlPower); #endregion //---------------------------------------------------------- //存储到数据库 PositionBll.GetInstence().Save(this, model); //如果本次修改改变了相关名称,则同步更新其他关联表的对应名称 if (isUpdate) { ManagerBll.GetInstence().UpdatePositionName(model.Id, model.Name); } } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 退出系统 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnExit_Click(object sender, EventArgs e) { OnlineUsersBll.GetInstence().UserExit(this); FineUI.Alert.ShowInTop("成功退出系统!", "安全退出", MessageBoxIcon.Information, "top.location='Login.aspx'"); }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { //判断 if (ddlShop.SelectedValue == "0") { return(ddlShop.Label + "不能为空!"); } if (ddlOUT_SHOP.SelectedValue == "0") { return(ddlOUT_SHOP.Label + "不能为空!"); } if (ddlORDER_DEP.SelectedValue == "0") { return(ddlORDER_DEP.Label + "不能为空!"); } //订单编号 if (txtORDER_ID.Text == "") { Random ran = new Random(); txtORDER_ID.Text = ddlShop.SelectedValue + "OR" + DateTime.Now.ToString("yyyy-MM-dd").Replace("-", "") + ran.Next(1000, 9999); } string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名 txtAPP_USER.Text = manager_LoginName; txtAPP_DATE.SelectedDate = DateTime.Now; string ORDER_ID = txtORDER_ID.Text; // GridViewHelper.GetSelectedKey(Grid2, true); //获取价格区域 string shop_id = ddlShop.SelectedValue;// OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); var model_SHOP = new SHOP00(x => x.SHOP_ID == shop_id); string prcarea_id = model_SHOP.SHOP_Price_Area; // 复制原始表格的结构 DataTable newTable = GetSourceData(ORDER_ID, prcarea_id).Clone(); DataRow newRow; JArray mergedData = Grid1.GetMergedData(); int i = 0; foreach (JObject mergedRow in mergedData) { string status = mergedRow.Value <string>("status"); int rowIndex = mergedRow.Value <int>("index"); JObject values = mergedRow.Value <JObject>("values"); i = i + 1; newRow = newTable.NewRow(); newRow[0] = rowIndex;//i;////j;// rowIndex; // 将行标识符设置为行索引号 newRow[1] = values.Value <string>("PROD_ID"); newRow[2] = values.Value <string>("PROD_NAME1"); newRow[3] = values.Value <string>("PROD_SPEC"); newRow[4] = values.Value <string>("PROD_UNIT"); newRow[5] = values.Value <string>("ON_QUAN"); newRow[6] = values.Value <string>("STD_PRICE"); newRow[7] = values.Value <string>("QUAN1"); newTable.Rows.Add(newRow); } // 更新数据源 Session[KEY_FOR_DATASOURCE_SESSION] = newTable; labResult.Text = ""; // String.Format("用户修改的数据:<pre>{0}</pre>", Grid1.GetModifiedData().ToString(Newtonsoft.Json.Formatting.Indented)); // MessageBox.Show(this,String.Format("用户修改的数据:<pre>{0}</pre>", Grid1.GetModifiedData().ToString(Newtonsoft.Json.Formatting.Indented))); // DataTable table = GetSourceData(); Grid1.DataSource = (DataTable)Session[KEY_FOR_DATASOURCE_SESSION];// table; Grid1.DataBind(); #region 数据验证 //判断列表 DataTable dt = (DataTable)Session[KEY_FOR_DATASOURCE_SESSION]; if (dt.Rows.Count <= 0 || Session[KEY_FOR_DATASOURCE_SESSION] == null) { return("要货明细不能为空!"); } #endregion //改变界面 ddlStatus.SelectedValue = "1" + ""; #region 赋值 主表 var model = new ORDER00(x => x.ORDER_ID == ORDER_ID); model.SHOP_ID = ddlShop.SelectedValue; 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 = 1; 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 = ddlORDER_DEP.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 = 0; #endregion //---------------------------------------------------------- //存储到数据库 ORDER00Bll.GetInstence().Save(this, model); //清空子表 ORDER00Bll.GetInstence().Delete(model.ORDER_ID); #region 添加子表 JArray mergedData1 = Grid1.GetMergedData(); int f = mergedData.Count; int k = 0; foreach (JObject mergedRow in mergedData1) { string status = mergedRow.Value <string>("status"); int rowIndex = mergedRow.Value <int>("index"); JObject values = mergedRow.Value <JObject>("values"); k = k + 1; try { var model_1 = new ORDER01(x => x.SNo == k && x.ORDER_ID == txtORDER_ID.Text.Trim()); model_1.SNo = k;// rowIndex + 1; model_1.SHOP_ID = ddlShop.SelectedValue; model_1.ORDER_ID = txtORDER_ID.Text.Trim(); model_1.PROD_ID = values.Value <string>("PROD_ID"); model_1.QUANTITY = 0; model_1.ON_QUAN = ConvertHelper.StringToDecimal(values.Value <string>("ON_QUAN")); model_1.QUAN1 = ConvertHelper.StringToDecimal(values.Value <string>("QUAN1"));//小计 model_1.QUAN2 = 0; model_1.COST_PRICE = ConvertHelper.StringToDecimal(values.Value <string>("STD_PRICE")); model_1.STD_UNIT = "1";//最小订货单位 Prod_UnitList.UNIT_ID; model_1.STD_CONVERT = 0; model_1.STD_QUAN = ConvertHelper.StringToDecimal(values.Value <string>("ON_QUAN")); model_1.STD_PRICE = ConvertHelper.StringToDecimal(values.Value <string>("STD_PRICE")); model_1.Memo = ""; model_1.CRT_DATETIME = DateTime.Now; model_1.CRT_USER_ID = txtCRT_USER_ID.Text; model_1.MOD_DATETIME = DateTime.Now; model_1.MOD_USER_ID = txtMOD_USER_ID.Text; // model_1.STD_TYPE = ""; ORDER01Bll.GetInstence().Save(this, model_1); } catch (Exception ee) { result = "保存失败!"; CommonBll.WriteLog(result + ":" + DateTime.Now.ToString(), ee); } //---------------------------------------------------------- //存储到数据库 } ///grid2 conditionList = new List <ConditionFun.SqlqueryCondition>(); user = OnlineUsersBll.GetInstence().GetPosition_Name(this, OnlineUsersBll.GetInstence().GetManagerId(), false); if (user.Contains("管理员")) { conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, "1", Comparison.Equals, "1", false, false)); } else { conditionList.Add(new ConditionFun.SqlqueryCondition(ConstraintType.Where, ORDER00Table.SHOP_ID, Comparison.Equals, shop_id, false, false)); } ORDER00Bll.GetInstence().BindGrid(Grid2, 0, 0, conditionList, sortList); #endregion } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } //设置不可更改 txtINPUT_DATE.Enabled = true; ddlEXPECT_DATE.Enabled = true; ddlORDER_DEP.Enabled = true; ddlORD_TYPE.Enabled = true; ddlEXPECT_DATE.Enabled = true; ddlOUT_SHOP.Enabled = true; txtMemo.Enabled = true; ButtonApproval.Enabled = true; btnNew.Enabled = true; btnDelete.Enabled = true; Grid1.Enabled = true; // Grid1.Rows.Clear(); // ButtonPowers(); 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(SUP_ID.Text.Trim())) { return(SUP_ID.Label + "不能为空!"); } if (string.IsNullOrEmpty(SUP_NAME.Text.Trim())) { return(SUP_NAME.Label + "不能为空!"); } if (string.IsNullOrEmpty(SUP_NICKNAME.Text.Trim())) { return(SUP_NICKNAME.Label + "不能为空!"); } if (string.IsNullOrEmpty(SUP_TYPE.SelectedValue) || SUP_TYPE.SelectedValue == "0") { return(SUP_TYPE.Label + "不能为空!"); } var sSUP_ID = StringHelper.Left(SUP_ID.Text, 50); if (SUPPLIERSBll.GetInstence().Exist(x => x.SUP_ID == sSUP_ID) && id == 0) { return(SUP_ID.Label + "已存在!请重新输入!"); } var sSUP_NAME = StringHelper.Left(SUP_NAME.Text, 50); if (SUPPLIERSBll.GetInstence().Exist(x => x.SUP_NAME == sSUP_NAME) && id == 0) { return(SUP_NAME.Label + "已存在!请重新输入!"); } //var sMeno = StringHelper.Left(UNIT_MENO.Text, 40); //if (UNIT_MENO.Text.Trim().Length > 40) //{ // return UNIT_MENO.Label + "超长!"; //} #endregion #region 赋值 var model = new SUPPLIERS(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.SUP_ID = sSUP_ID; model.SUP_NAME = sSUP_NAME; model.SUP_NICKNAME = SUP_NICKNAME.Text; model.SUP_TYPE = ConvertHelper.Cint(SUP_TYPE.SelectedValue); model.SUP_ADD = SUP_ADD.Text; model.SUP_TEL = SUP_TEL.Text; model.SUP_Email = SUP_Email.Text; model.SUP_ZIP = SUP_ZIP.Text; model.SUP_Contact = SUP_Contact.Text; model.SUP_Mobile = SUP_Mobile.Text; model.SUP_CODE_ID = SUP_CODE_ID.Text; model.SUP_BankName = SUP_BankName.Text; model.SUP_BankID = SUP_BankID.Text; model.SUP_PASSWORD = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(SUP_PASSWORD.Text, "MD5"); model.Send_DAY = ConvertHelper.Cint(Send_DAY.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 ////---------------------------------------------------------- ////存储到数据库 SUPPLIERSBll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
protected void btnSubmit1_Click(object sender, EventArgs e) { Grid2.Rows.Clear(); //判断 FineUI.RadioButton RaddpUp_Date = Window2.FindControl("A").FindControl("RaddpUp_Date") as FineUI.RadioButton; FineUI.RadioButton RadEXPECT_DATE = Window2.FindControl("B").FindControl("RadEXPECT_DATE") as FineUI.RadioButton; if (RaddpUp_Date.Checked == false && RadEXPECT_DATE.Checked == false) { Alert.Show("请选择时间"); return; } string Start_Time = ""; string End_Time = ""; //获取时间 DatePicker dpUp_DateBeg = Window2.FindControl("A").FindControl("dpUp_DateBeg") as DatePicker; DateTime dt_up_date_bg = ConvertHelper.StringToDatetime(DateTime.Parse(dpUp_DateBeg.SelectedDate.ToString()).ToString("yyyy-MM-dd 00:00:00")); DatePicker dpUp_DateEnd = Window2.FindControl("A").FindControl("dpUp_DateEnd") as DatePicker; DateTime dt_up_date_end = ConvertHelper.StringToDatetime(DateTime.Parse(dpUp_DateEnd.SelectedDate.ToString()).ToString("yyyy-MM-dd 23:59:59")); DatePicker dpEXPECT_DATEBeg = Window2.FindControl("B").FindControl("dpEXPECT_DATEBeg") as DatePicker; DateTime dt_expect_date_bg = ConvertHelper.StringToDatetime(DateTime.Parse(dpEXPECT_DATEBeg.SelectedDate.ToString()).ToString("yyyy-MM-dd 00:00:00")); DatePicker dpEXPECT_DATEEnd = Window2.FindControl("B").FindControl("dpEXPECT_DATEEnd") as DatePicker; DateTime dt_expect_date_end = ConvertHelper.StringToDatetime(DateTime.Parse(dpEXPECT_DATEEnd.SelectedDate.ToString()).ToString("yyyy-MM-dd 23:59:59")); int IsTime = 1; if (RaddpUp_Date.Checked) { IsTime = 0; Start_Time = dt_up_date_bg.ToString(); End_Time = dt_up_date_end.ToString(); } if (RadEXPECT_DATE.Checked) { IsTime = 1; Start_Time = dt_expect_date_bg.ToString(); End_Time = dt_expect_date_end.ToString(); } string shop_id = SHOP_hidId.Text.Trim(); string shop_name = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_NAME1").ToString(); string shop_idStr = ORDER00Table.SHOP_ID; // string user = OnlineUsersBll.GetInstence().GetPosition_Name(this, OnlineUsersBll.GetInstence().GetManagerId(), false); user = OnlineUsersBll.GetInstence().GetPosition_Name(this, OnlineUsersBll.GetInstence().GetManagerId(), false); if (user.Contains("区域管理员")) { IsTime = -1; } Session["SerchPars_session_Orders"] = Session["SerchPars_session"] = IsTime + "," + Start_Time + "," + End_Time; BandGrid2(shop_name, shop_idStr, shop_id, Start_Time, End_Time, IsTime); Window2.Hidden = true; }
/// <summary> /// 数据保存 /// </summary> /// <returns></returns> public override string Save() { string result = string.Empty; int id = ConvertHelper.Cint0(hidId.Text); try { #region 数据验证 if (string.IsNullOrEmpty(UNIT_ID.Text.Trim())) { return(UNIT_ID.Label + "不能为空!"); } if (string.IsNullOrEmpty(UNIT_NAME.Text.Trim())) { return(UNIT_NAME.Label + "不能为空!"); } var sName = StringHelper.Left(UNIT_NAME.Text, 50); if (PROD_UNITBll.GetInstence().Exist(x => x.UNIT_NAME == sName) && id == 0) { return(UNIT_NAME.Label + "已存在!请重新输入!"); } var sUNIT_ID = StringHelper.Left(UNIT_ID.Text, 50); if (PROD_UNITBll.GetInstence().Exist(x => x.UNIT_ID == sUNIT_ID) && id == 0) { return(UNIT_ID.Label + "已存在!请重新输入!"); } var sMeno = StringHelper.Left(UNIT_MENO.Text, 40); if (UNIT_MENO.Text.Trim().Length > 40) { return(UNIT_MENO.Label + "超长!"); } #endregion #region 赋值 var model = new PROD_UNIT(x => x.Id == id); //var OlUser = new OnlineUsers(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); //var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); var OlUser = OnlineUsers.SingleOrDefault(x => x.UserHashKey == OnlineUsersBll.GetInstence().GetUserHashKey()); //设置名称 model.UNIT_ID = UNIT_ID.Text; model.UNIT_NAME = sName; model.UNIT_MEMO = sMeno; model.CRT_DATETIME = ConvertHelper.StringToDatetime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")); model.CRT_USER_ID = OlUser.Manager_LoginName; //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 //---------------------------------------------------------- //存储到数据库 PROD_UNITBll.GetInstence().Save(this, model); } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志信息 CommonBll.WriteLog(result, e); } return(result); }
public override void Add() { string shop_id = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); // SHOP_hidId.Text.Trim(); int managerId = OnlineUsersBll.GetInstence().GetManagerId(); //获取登录名 //表头 SHOP00Bll.GetInstence().GetShopList(this, shop_id, ddlShop); //.BandDropDownListShowShop(this, ddlShop, shop_id); //分店名称 SHOP00Bll.GetInstence().BandDropDownListShowShop1(this, ddlOUT_SHOP); //供货分店 // ORDER_DEP00Bll.GetInstence().BandDropDownList(this, ddlORDER_DEP, shop_id);//订货部门 BranchBll.GetInstence().BandDropDownList(this, ddlORDER_DEP); string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名 txtCRT_USER_ID.Text = manager_LoginName; txtORD_USER.Text = manager_LoginName; txtAPP_USER.Text = ""; // manager_LoginName; txtMOD_USER_ID.Text = ""; // manager_LoginName; txtINPUT_DATE.SelectedDate = DateTime.Now; //单据时间 txtManage.Text = manager_LoginName; ddlStatus.SelectedValue = "0";//状态 ddlEXPECT_DATE.SelectedDate = DateTime.Now.AddDays(1); txtCRT_DATETIME.SelectedDate = DateTime.Now; txtMOD_DATETIME.SelectedDate = DateTime.Now; txtEXPORTED_ID.Text = ""; txtMemo.Text = ""; cbTrans_STATUS.Checked = false; ddlShop.SelectedValue = shop_id; HiddenShop_Id.Text = ddlShop.SelectedValue;// ddlORDER_DEP.SelectedValue; Random ran = new Random(); txtORDER_ID.Text = ddlShop.SelectedValue + "OR" + DateTime.Now.ToString("yyyy-MM-dd").Replace("-", "") + ran.Next(1000, 9999); ddlStatus.SelectedIndex = 0; txtEXPORTED_ID.Text = ""; txtEXPORTED.Checked = false; txtCRT_DATETIME.Text = DateTime.Now.ToString(); txtLAST_UPDATE.Text = DateTime.Now.ToString(); txtMOD_DATETIME.Text = DateTime.Now.ToString(); //设置不可更改 txtINPUT_DATE.Enabled = true; ddlEXPECT_DATE.Enabled = true; ddlORDER_DEP.Enabled = true; ddlORD_TYPE.Enabled = true; ddlEXPECT_DATE.Enabled = true; ddlOUT_SHOP.Enabled = true; txtMemo.Enabled = true; ButtonApproval.Enabled = true; btnNew.Enabled = true; btnDelete.Enabled = true; Grid1.Enabled = true; Grid1.Rows.Clear(); // txtManage.Text = OnlineUsersBll.GetInstence().GetManager_LoginName(this, managerId, true); }
/// <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 (AdvertisementBll.GetInstence().Exist(x => x.Name == sName && x.Id != id)) { return(txtName.Label + "已存在!请重新输入!"); } if (ddlAdvertisingPosition.SelectedValue == "0") { return(ddlAdvertisingPosition.Label + "为必选项,请选择!"); } if (dpStartTime.SelectedDate == null || TimeHelper.IsDateTime(dpStartTime.SelectedDate) == false) { return("请选择" + dpStartTime.Label); } if (dpEndTime.SelectedDate == null || TimeHelper.IsDateTime(dpEndTime.SelectedDate) == false) { return("请选择" + dpEndTime.Label); } if (dpStartTime.SelectedDate > dpEndTime.SelectedDate) { return(dpStartTime.Label + "不能大于" + dpEndTime.Label); } #endregion #region 赋值 //获取实体 var model = new Advertisement(x => x.Id == id); //------------------------------------------ //设置名称 model.Name = sName; model.Keyword = StringHelper.Left(txtKeyword.Text, 50); model.Url = StringHelper.Left(txtUrl.Text, 200, true, false); //说明 model.Content = StringHelper.Left(txtContent.Text, 100); //取得位置 model.AdvertisingPosition_Id = ConvertHelper.Cint0(ddlAdvertisingPosition.SelectedValue); model.AdvertisingPosition_Name = StringHelper.Left(ddlAdvertisingPosition.SelectedText, 50); //开始时间与结束时间 model.StartTime = dpStartTime.SelectedDate ?? DateTime.Now; model.EndTime = dpEndTime.SelectedDate ?? DateTime.Now.AddDays(1); //设定当前项是否显示 model.IsDisplay = ConvertHelper.StringToByte(rblIsDisplay.SelectedValue); model.Sort = ConvertHelper.Cint0(txtSort.Text);; //修改时间与用户 model.UpdateDate = DateTime.Now; model.Manager_Id = OnlineUsersBll.GetInstence().GetManagerId(); model.Manager_CName = OnlineUsersBll.GetInstence().GetManagerCName(); #endregion //------------------------------------------ #region 图片 //判断前端的ASP.NET上传控件是否选择有上传文件 if (this.filePhoto.HasFile && this.filePhoto.FileName.Length > 3) { //将当前页面上传文件绑定上传配置表Id为7的记录,给上传组件的逻辑层函数调用 int vid = 7; //7 广告 //--------------------------------------------------- //创建上传实体 var upload = new UploadFile(); //调用ASP.NET上传控件上传函数,并获取上传成功或失败信息 result = new UploadFileBll().Upload_AspNet(this.filePhoto.PostedFile, vid, RndKey, OnlineUsersBll.GetInstence().GetManagerId(), OnlineUsersBll.GetInstence().GetManagerCName(), upload); this.filePhoto.Dispose(); //--------------------------------------------------- //没有返回信息时表示上传成功 if (result.Length == 0) { //将上传到服务器后的路径赋给广告实体对应字段 model.AdImg = upload.Path; } else { //将出错写入日志中 CommonBll.WriteLog("上传出错:" + result); //收集异常信息 //弹出出错提示 return("上传出错!" + result); } } //如果是修改,检查用户是否重新上传过广告图片,如果是删除旧的图片 if (model.Id > 0) { //删除旧图片 UploadFileBll.GetInstence() .Upload_DiffFile(AdvertisementTable.Id, AdvertisementTable.AdImg, AdvertisementTable.TableName, model.Id, model.AdImg); //同步UploadFile上传表记录,绑定刚刚上传成功的文件Id为当前记录Id UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, AdvertisementTable.TableName, model.Id); } #endregion //---------------------------------------------------------- //存储到数据库 AdvertisementBll.GetInstence().Save(this, model); #region 步更新上传图片表绑定Id if (id == 0) { //同步UploadFile上传表记录,绑定刚刚上传成功的文件Id为当前记录Id UploadFileBll.GetInstence().Upload_UpdateRs(RndKey, AdvertisementTable.TableName, model.Id); } #endregion //这里放置清空前端页面缓存的代码(如果前端使用了页面缓存的话,必须进行清除操作) } catch (Exception e) { result = "保存失败!"; //出现异常,保存出错日志广告 CommonBll.WriteLog(result, e); } return(result); }
/// <summary> /// 汇整 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnArchive_Click(object sender, EventArgs e) { //判断 FineUI.RadioButton RaddpUp_Date = Window2.FindControl("A").FindControl("RaddpUp_Date") as FineUI.RadioButton; FineUI.RadioButton RadEXPECT_DATE = Window2.FindControl("B").FindControl("RadEXPECT_DATE") as FineUI.RadioButton; if (RaddpUp_Date.Checked == false && RadEXPECT_DATE.Checked == false) { Alert.Show("请选择时间"); return; } string Start_Time = ""; string End_Time = ""; //获取时间 DatePicker dpUp_DateBeg = Window2.FindControl("A").FindControl("dpUp_DateBeg") as DatePicker; DateTime dt_up_date_bg = ConvertHelper.StringToDatetime(dpUp_DateBeg.SelectedDate.ToString()); DatePicker dpUp_DateEnd = Window2.FindControl("A").FindControl("dpUp_DateEnd") as DatePicker; DateTime dt_up_date_end = ConvertHelper.StringToDatetime(dpUp_DateEnd.SelectedDate.ToString()); DatePicker dpEXPECT_DATEBeg = Window2.FindControl("B").FindControl("dpEXPECT_DATEBeg") as DatePicker; DateTime dt_expect_date_bg = ConvertHelper.StringToDatetime(dpEXPECT_DATEBeg.SelectedDate.ToString()); DatePicker dpEXPECT_DATEEnd = Window2.FindControl("B").FindControl("dpEXPECT_DATEEnd") as DatePicker; DateTime dt_expect_date_end = ConvertHelper.StringToDatetime(dpEXPECT_DATEEnd.SelectedDate.ToString()); //参数 Random ran = new Random(); string SHOP_ID = OnlineUsersBll.GetInstence().GetUserOnlineInfo("SHOP_ID").ToString(); string COL_ID = SHOP_ID + "CL" + DateTime.Now.ToString("yyyy-MM-dd") + +ran.Next(1000, 9999); string manager_LoginName = OnlineUsersBll.GetInstence().GetUserOnlineInfo("Manager_LoginName").ToString();//登录名 int IsTime = 1; if (RaddpUp_Date.Checked) { IsTime = 0; Start_Time = dt_up_date_bg.ToString(); End_Time = dt_up_date_end.ToString(); } if (RadEXPECT_DATE.Checked) { IsTime = 1; Start_Time = dt_expect_date_bg.ToString(); End_Time = dt_expect_date_end.ToString(); } string ORD_DEP_ID_C = "";//汇整者的 部门 int ex_int = Col_Order00Bll.GetInstence().ADD_ARCHIVEORDERS(manager_LoginName, ORD_DEP_ID_C, SHOP_ID, Start_Time, End_Time, IsTime); if (ex_int == 0) { Alert.Show("汇整成功!"); } else { Alert.Show("汇整失败!请重新汇整!"); } LoadData(); }
/// <summary> /// 子表保存 /// </summary> /// <returns></returns> public string DetailEdit() { JArray jarr = Grid2.GetMergedData(); string result = ""; result = DetailChecked(jarr); if (!String.IsNullOrEmpty(result)) { return(result); } var OlUser = OnlineUsersBll.GetInstence().GetModelForCache(x => x.UserHashKey == Session[OnlineUsersTable.UserHashKey].ToString()); int n = 0; for (int i = 0; i < jarr.Count; i++) { try { int id = ConvertHelper.Cint(jarr[i]["values"]["Id01"].ToString()); var model2 = new TAKEIN11(x => x.Id == id); //string str = jarr[i]["status"].ToString(); if (jarr[i]["status"].ToString().Equals("modified")) { model2.SetIsNew(false); } else if (jarr[i]["status"].ToString().Equals("unchanged")) { continue; } else { model2.SetIsNew(true); } model2.SHOP_ID = jarr[i]["values"]["SHOP_ID01"].ToString(); if (!String.IsNullOrEmpty(jarr[i]["values"]["TAKEIN_ID01"].ToString())) { model2.TAKEIN_ID = jarr[i]["values"]["TAKEIN_ID01"].ToString(); } else { return("保存失败"); } model2.SNo = ConvertHelper.Cint(jarr[i]["values"]["TAKEIN_ID01"].ToString()); model2.PROD_ID = jarr[i]["values"]["PROD_ID01"].ToString(); model2.QUANTITY = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUANTITY01"].ToString()); model2.STD_UNIT = jarr[i]["values"]["STD_UNIT01"].ToString(); model2.STD_CONVERT = ConvertHelper.Cint(jarr[i]["values"]["STD_CONVERT01"].ToString()); model2.STD_QUAN = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_QUAN01"].ToString()); model2.STD_PRICE = ConvertHelper.StringToDecimal(jarr[i]["values"]["STD_PRICE01"].ToString()); model2.Tax = ConvertHelper.StringToDecimal(jarr[i]["values"]["Tax01"].ToString()); //model2.COST = ConvertHelper.StringToDecimal(jarr[i]["values"]["COST01"].ToString()); model2.QUAN1 = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUAN101"].ToString()); model2.QUAN2 = ConvertHelper.StringToDecimal(jarr[i]["values"]["QUAN201"].ToString()); model2.Item_DISC_Amt = 0; model2.MEMO = jarr[i]["values"]["MEMO01"].ToString(); model2.BAT_NO = jarr[i]["values"]["BAT_NO"].ToString(); model2.Exp_DateTime = DateTime.Now; TAKEIN11Bll.GetInstence().Save(this, model2); } catch (Exception err) { n++; result = "明细保存失败" + n + "条"; } } LoadDETAIL(); 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)); }