protected void btnSave_Click(object sender, EventArgs e) { model.flag_name = KillSqlIn.Form_ReplaceByString(Request.Form["txtTitle"], 200); //string BackUrl = "CategoryTree.aspx"; if (_id != "0") { model.flag_id = _id; bll.Update(model); ClientScript.RegisterStartupScript(this.GetType(), "js", "<script>alert('修改成功!');layer_close_refresh();</script>"); //JSUtility.AlertAndRedirect("修改成功!", BackUrl); /*日志归档*/ //string sql1 = @"select Title as title from dbo.T_Category where CategoryId = (" + _ACid + ")"; //string function = "修改"; //PubFunction.InsertLog1("文章类别管理", sql1, function); } else { model.if_use = 1; model.flag_id = IdCreator.CreateId("T_Base_Flag", "flag_id"); bll.Add(model); JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); /*日志归档*/ //string sql1 = @"select Title as title from dbo.T_Category where CategoryId = (select top 1 CategoryId from T_Category order by CategoryId desc)"; //string function = "添加"; //PubFunction.InsertLog1("文章类别管理", sql1, function); } }
protected void FillFeild() { if (_id != "0") { model = bll.GetModel(this._id); model.templateId = this._id; } else { model.templateId = IdCreator.CreateId("T_ShortMessage_Template", "templateId"); model.isUse = 1; } model.flag = this.ddlParentCategory.SelectedValue; //标识 model.supplierId = this.ddlSupplierCategory.SelectedValue; //供应商 if (!string.IsNullOrEmpty(model.supplierId)) { ShortMsgSupModel modelSup = new ShortMsgSupBll().GetModel(model.supplierId); if (modelSup != null) { model.supplierFlag = modelSup.flag; } } model.templateCode = KillSqlIn.Form_ReplaceByString(Request.Form["txtCode"], 200); model.templateParam = KillSqlIn.Form_ReplaceByString(Request.Form["txtParam"], 200); }
/// <summary> /// 确定提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { model = GetModel(); if (_Pid != "SysError") { if (!_Pid.Equals(model.area_id)) { bll.UpdateId(model.area_id, _Pid); //先更新编号 } if (bll.Update(model)) { adohelper.ExecuteSqlNonQuery("update T_Base_Area set ishot=" + (this.cbHot.Checked ? "1" : "0") + " where area_id='" + model.area_id + "'"); this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { model.area_id = IdCreator.CreateId("T_Base_Area", "area_id"); if (bll.Add(model)) { adohelper.ExecuteSqlNonQuery("update T_Base_Area set ishot=" + (this.cbHot.Checked ? "1" : "0") + " where area_id='" + model.area_id + "'"); JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); } } }
protected void btnSave_Click(object sender, EventArgs e) { try { List <SqlParameter> p = new List <SqlParameter>(); p.Add(new SqlParameter("@activity_title", activity_title.Value)); p.Add(new SqlParameter("@activity_desc", activity_desc.Value)); p.Add(new SqlParameter("@activity_status", activity_status.SelectedValue)); p.Add(new SqlParameter("@remarks", remarks.Value)); p.Add(new SqlParameter("@if_approved", if_approved.SelectedValue)); p.Add(new SqlParameter("@manager_id", manager_id.Value)); p.Add(new SqlParameter("@job_ids", job_ids.Value)); p.Add(new SqlParameter("@activity_person", activity_person.Value)); if (string.IsNullOrWhiteSpace(activity_id.Value)) { string id = IdCreator.CreateId("t_activity_info", "activity_id"); //add p.Add(new SqlParameter("@activity_id", id)); p.Add(new SqlParameter("@create_time", DateTime.Now)); p.Add(new SqlParameter("@create_person", this.TrueName)); string sql = "insert into t_activity_info(activity_id,activity_title,activity_desc,activity_status,create_time,create_person,if_approved,manager_id,job_ids,activity_person,remarks) values(@activity_id,@activity_title,@activity_desc,@activity_status,@create_time,@create_person,@if_approved,@manager_id,@job_ids,@activity_person,@remarks);"; int result = ado.ExecuteSqlNonQuery(sql, p.ToArray()); if (result == 1) { ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('新增成功');layer_close_refresh();</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('新增失败');</script>"); } } else { //update p.Add(new SqlParameter("@activity_id", activity_id.Value)); string sql = "update t_activity_info set activity_title=@activity_title,activity_desc=@activity_desc,activity_status=@activity_status,remarks=@remarks,if_approved=@if_approved,manager_id=@manager_id,job_ids=@job_ids,activity_person=@activity_person where activity_id=@activity_id;"; int result = ado.ExecuteSqlNonQuery(sql, p.ToArray()); if (result == 1) { ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改失败');</script>"); } } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('提交失败');</script>"); } }
protected void btnSave_Click(object sender, EventArgs e) { try { List <SqlParameter> p = new List <SqlParameter>(); p.Add(new SqlParameter("@node_sn", node_sn.Value)); p.Add(new SqlParameter("@node_name", node_name.Value)); p.Add(new SqlParameter("@yb_value", yb_value.Value)); p.Add(new SqlParameter("@jyz_value_set", jyz_value_set.Value)); p.Add(new SqlParameter("@cs_value_set", cs_value_set.Value)); p.Add(new SqlParameter("@rq_value_set", rq_value_set.Value)); p.Add(new SqlParameter("@node_para", node_para.Value)); p.Add(new SqlParameter("@remarks", remarks.Value)); p.Add(new SqlParameter("@if_use", if_use.SelectedValue)); if (string.IsNullOrWhiteSpace(node_id.Value)) { string id = IdCreator.CreateId("t_task_node_config", "node_id"); //add p.Add(new SqlParameter("@node_id", id)); p.Add(new SqlParameter("@node_code", "cd" + new Random().Next(1000, 9999))); p.Add(new SqlParameter("@task_id", task_id.Value)); string sql = "insert into t_task_node_config(node_id,task_id,node_code,node_sn,node_name,node_para,remarks,if_use) values(@node_id,@task_id,@node_code,@node_sn,@node_name,@node_para,@remarks,@if_use);"; int result = ado.ExecuteSqlNonQuery(sql, p.ToArray()); if (result == 1) { ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('新增成功');layer_close_refresh();</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('新增失败');</script>"); } } else { //update p.Add(new SqlParameter("@node_id", node_id.Value)); string sql = "update t_task_node_config set node_sn=@node_sn,node_name=@node_name,node_para=@node_para,remarks=@remarks,if_use=@if_use where node_id=@node_id;"; int result = ado.ExecuteSqlNonQuery(sql, p.ToArray()); if (result == 1) { ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改失败');</script>"); } } } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('提交失败');</script>"); } }
protected void FillFeild() { if (_id != "0") { model = bll.GetModel(this._id); model.supplierId = this._id; } else { model.supplierId = IdCreator.CreateId("T_ShortMessage_Supplier", "supplierId"); model.isUse = 0; model.isDefault = 0; } model.flag = this.ddlParentCategory.SelectedValue; model.supplierName = KillSqlIn.Form_ReplaceByString(Request.Form["txtTitle"], 200); model.accessKeyID = KillSqlIn.Form_ReplaceByString(Request.Form["txtKey"], 200); model.accessKeySecret = KillSqlIn.Form_ReplaceByString(Request.Form["txtSecret"], 200); model.smsSign = KillSqlIn.Form_ReplaceByString(Request.Form["txtSmsSign"], 200); model.sort = int.Parse(KillSqlIn.Form_ReplaceByString(Request.Form["txtSort"], int.MaxValue)); }
protected void btnSave_Click(object sender, EventArgs e) { if (this.id == "") { MorePropertyConfigSetModel mod = new MorePropertyConfigSetModel(); mod.propertyId = IdCreator.CreateId("T_Goods_MorePropertySet", "propertyId"); GetFormInfo(ref mod); if (bll.Add(mod) > 0) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('保存成功');location.href('MorePropertySetList.aspx');</script>"); } } else { MorePropertyConfigSetModel mod = bll.GetModel(this.id); GetFormInfo(ref mod); if (bll.Update(mod) > 0) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('保存成功');location.href('MorePropertySetList.aspx');</script>"); } } }
/// <summary> /// 确定提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { model = GetModel(); if (_Pid != "SysError") { if (!_Pid.Equals(model.Market_id)) { bll.UpdateId(model.Market_id, _Pid); //先更新编号 } if (bll.Update(model)) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { model.Market_id = IdCreator.CreateId("T_Base_Market", "Market_id"); if (bll.Add(model)) { JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); } } }
internal static ChannelContext GetNextContext(NettyNetwork network) { var contexts = GetContexts(network.Id).OrderBy(c => c.ChannelId).ToList(); if (!contexts.Any()) { return(null); } ChannelContext context = null; while (true) { if (contexts.Count == 0) { break; } var index = IdCreator.CreateNextId() % contexts.Count; context = contexts[index]; if (context.Handler.IsClient) { throw new NotSupportedException("This method does not supported a client network search, you can using GetSingleContext."); } if (context.ChannelHanderContext.Channel.Active) { break; } else { context = null; contexts.RemoveAt(index); } } return(context); }
protected void InitForm() { //string signList = ""; string sign = ""; if (this.id != "") { GoodsModel mod = bll.GetModel(this.id); if (mod != null) { this.txtName.Value = mod.GoodsName; this.txtOrder.Value = mod.Orderby.ToString(); this.txtRemarks.Text = mod.Remarks; this.div_img.Visible = true; this.Image1.ImageUrl = mod.GoodsSmallPic; this.txtSampleDesc.Text = mod.GoodsSampleDesc; this.hzst_ckeditor.Text = mod.GoodsDesc; this.cselect.categoryID = mod.CategoryId; this.goodsCode = this.txtGoodsCode.Value = mod.GoodsCode; if (mod.IsHot == 1) { this.cbIsHot.Checked = true; } if (mod.IsNew == 1) { this.cbIsNew.Checked = true; } if (mod.IsRec == 1) { this.cbIsRec.Checked = true; } //if (mod.IsSpe == 1) { this.cbIsSpe.Checked = true; } this.txtSalePrice.Value = mod.SalePrice.ToString(); this.txtMarketPrice.Value = mod.MarketPrice.ToString(); if (mod.MorePropertys != "") { this.ddlMorePropertys.SelectedValue = mod.MorePropertys; } this.rdIsSale.SelectedValue = mod.IsSale.ToString(); this.hidOldGoodsCode.Value = mod.GoodsCode; sign = mod.signId; hfSign.Value = sign; //20160605 //this.txtJobStartTime.Value = mod.JobStartTime.ToString("yyyy-MM-dd HH:mm"); //this.txtJobEndTime.Value = mod.JobEndTime.ToString("yyyy-MM-dd HH:mm"); this.ddlJobType.Value = mod.JobType; this.txtTotalSaleCount.Value = mod.TotalSaleCount.ToString(); //this.llRemark.Text = GetMemberPrice(this.id); } } else { this.txtGoodsCode.Value = IdCreator.CreateId("T_Goods_Info", "GoodsCode"); if (this.cateId != "") //this.ddlPCategory.SelectedValue = this.cateId; { this.cselect.categoryID = this.cateId; } //this.txtJobStartTime.Value = this.txtJobEndTime.Value = DateTime.Now.ToString("yyyy-MM-dd"); } string strSQL = ""; strSQL += "select * from T_Goods_Sign;"; strSQL += "select * from T_Goods_Service order by orderby asc;"; //strSQL += "select * from T_Goods_SignBind where goodsid='" + id + "';"; AdoHelper adohelper = AdoHelper.CreateHelper(StarTech.Util.AppConfig.DBInstance); DataSet ds = adohelper.ExecuteSqlDataset(strSQL); List <string> signList = new List <string>(); List <string> serviceList = new List <string>(); if (sign != "" && sign != null) { signList = sign.Split(',').ToList(); } string llText = ""; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (signList.Contains(ds.Tables[0].Rows[i]["signid"].ToString().Trim())) { llText += "<input checked='checked' type='checkbox' signname='" + ds.Tables[0].Rows[i]["signname"].ToString() + "' signid='" + ds.Tables[0].Rows[i]["signid"].ToString() + "' class='ckSign' />"; } else { llText += "<input type='checkbox' signname='" + ds.Tables[0].Rows[i]["signname"].ToString() + "' signid='" + ds.Tables[0].Rows[i]["signid"].ToString() + "' class='ckSign' />"; } llText += ds.Tables[0].Rows[i]["signname"].ToString(); if ((i + 1) % 6 == 0) { llText += "<br/>"; } ltSign.Text = llText; } }
protected void btnSave_Click(object sender, EventArgs e) { int updateInt = -1; if (this.id == "") { if (this.FileUpload1.HasFile == false) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('请选择任务图片');</script>"); return; } GoodsModel mod = new GoodsModel(); mod.GoodsId = IdCreator.CreateId("T_Goods_Info", "GoodsId"); mod.AddTime = DateTime.Now; if (hfSign.Value.Length > 0) { mod.signId = hfSign.Value; } else { mod.signId = ""; } string fileExt = System.IO.Path.GetExtension(this.FileUpload1.FileName).ToLower(); if (fileExt != ".jpeg" && fileExt != ".jpg" && fileExt != ".png" && fileExt != ".bmp" && fileExt != ".gif") { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('图片格式不正确');</script>"); return; } if (this.FileUpload1.PostedFile.ContentLength > 1024000) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('图片不能大于1M');</script>"); return; } string newFileName = Guid.NewGuid().ToString() + fileExt; string dir = "/upload/goodsadmin/" + DateTime.Now.ToString("yyyyMMdd") + "/"; if (System.IO.Directory.Exists(Server.MapPath(dir)) == false) { System.IO.Directory.CreateDirectory(Server.MapPath(dir)); } string newPath = dir + newFileName; this.FileUpload1.SaveAs(Server.MapPath(newPath)); //缩略图 MakeSmallPic(Server.MapPath(newPath), Server.MapPath(newPath.Replace(fileExt, "_s" + fileExt))); mod.GoodsSmallPic = newPath.Replace(fileExt, "_s" + fileExt); //mod.GoodsSmallPic = newPath.Replace(fileExt, "" + fileExt); ViewState["OriginalBigImg"] = mod.GoodsSmallPic; GetFormInfo(ref mod); if (mod.CategoryId == "1") { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('未选择分类')</script>"); } if (bll.Add(mod) > 0) { string strShop = "select shopId from T_Shop_User where isdefault=1;"; DataSet ds = StarTech.DBUtility.AdoHelper.CreateHelper(AppConfig.DBInstance).ExecuteSqlDataset(strShop); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string newGuid = Guid.NewGuid().ToString(); string shopId = ds.Tables[0].Rows[0][0].ToString(); string goodsId = mod.GoodsId; int num = mod.Sotck.Value; decimal price = mod.SalePrice.Value; int isSell = mod.IsSale.Value; DateTime addt = DateTime.Now; string goodsCode = mod.GoodsCode; string strGoods = "insert into T_Shop_Goods values('" + newGuid + "','" + shopId + "','" + goodsId + "'," + num + "," + price + "," + isSell + ",'" + addt + "','" + goodsCode + "',0,0,0,0);"; StarTech.DBUtility.AdoHelper.CreateHelper(AppConfig.DBInstance).ExecuteSqlNonQuery(strGoods); } } string strItem = "insert T_Menu_Item(itemName,itemImgSrc,ifBuy,GoodsId,orderBy,remark,unit) values(@itemName,@itemImgSrc,@ifBuy,@GoodsId,@orderBy,@remark,@unit);"; SqlParameter[] q = { // @itemImgSrc,@ifBuy,@GoodsId,@orderBy,@remark,@unit new SqlParameter("@itemName", SqlDbType.VarChar), new SqlParameter("@itemImgSrc", SqlDbType.VarChar), new SqlParameter("@ifBuy", SqlDbType.Int), new SqlParameter("@GoodsId", SqlDbType.VarChar), new SqlParameter("@orderBy", SqlDbType.Int), new SqlParameter("@remark", SqlDbType.VarChar), new SqlParameter("@unit", SqlDbType.VarChar) }; q[0].Value = mod.GoodsName; q[1].Value = mod.GoodsSmallPic; q[2].Value = 1; q[3].Value = mod.GoodsId; q[4].Value = 9999; q[5].Value = "任务“" + mod.GoodsName + "”添加"; q[6].Value = mod.Uint; int rows = StarTech.DBUtility.AdoHelper.CreateHelper(AppConfig.DBInstance).ExecuteSqlNonQuery(strItem, q); //默认幻灯图片 //if (ViewState["OriginalBigImg"] != null) { AddDefaultPic(mod.GoodsId, ViewState["OriginalBigImg"].ToString()); } LogAdd.CreateLog(HttpContext.Current.Session["UserId"].ToString(), "添加课程《" + mod.GoodsName + "》", "添加", "", "", HttpContext.Current.Request.Url.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>if(confirm('保存成功')){location.href='GoodsAdd.aspx?id=" + mod.GoodsId + "'}else{}</script>"); } } else { updateInt = 0; //string strSQL = "select * from T_Goods_Update where goodsid='" + id+"' and updatetime>'"+DateTime.Now.ToShortDateString()+" 00:00:00';"; string strSQL = ""; AdoHelper adohelper = StarTech.DBUtility.AdoHelper.CreateHelper(AppConfig.DBInstance); //DataSet ds = adohelper.ExecuteSqlDataset(strSQL); //if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count >= 0) //{ // if (ds.Tables[0].Rows.Count > 2) // { // ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('编辑成功');</script>"); // return; // } // else // { // updateInt = 2 - ds.Tables[0].Rows.Count; // } //} GoodsModel mod = bll.GetModel(this.id); if (this.FileUpload1.HasFile == true) { string fileExt = System.IO.Path.GetExtension(this.FileUpload1.FileName).ToLower(); if (fileExt != ".jpeg" && fileExt != ".jpg" && fileExt != ".png" && fileExt != ".bmp" && fileExt != ".gif") { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('图片格式不正确');</script>"); return; } if (this.FileUpload1.PostedFile.ContentLength > 10240000) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('图片不能大于10M');</script>"); return; } string newFileName = Guid.NewGuid().ToString() + fileExt; string dir = "/upload/goodsadmin/" + DateTime.Now.ToString("yyyyMMdd") + "/"; if (System.IO.Directory.Exists(Server.MapPath(dir)) == false) { System.IO.Directory.CreateDirectory(Server.MapPath(dir)); } string newPath = dir + newFileName; this.FileUpload1.SaveAs(Server.MapPath(newPath)); //缩略图 MakeSmallPic(Server.MapPath(newPath), Server.MapPath(newPath.Replace(fileExt, "_s" + fileExt))); mod.GoodsSmallPic = newPath.Replace(fileExt, "_s" + fileExt); //mod.GoodsSmallPic = newPath.Replace(fileExt, "" + fileExt); ViewState["OriginalBigImg"] = mod.GoodsSmallPic; } //hfSign.Value = hfSign.Value.Replace("--", "-"); if (hfSign.Value.Length > 0) { mod.signId = hfSign.Value; } else { mod.signId = ""; } GetFormInfo(ref mod); if (bll.Update(mod)) { adohelper.ExecuteSqlNonQuery("update T_Goods_Info set JobDay=datediff(day,JobStartTime,JobEndTime) where GoodsId='" + mod.GoodsId + "'"); //默认图片 //if (ViewState["OriginalBigImg"] != null) { AddDefaultPic(mod.GoodsId, ViewState["OriginalBigImg"].ToString()); } //if (updateInt == -1) // ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('保存成功');location.href='GoodsList.aspx?id=" + this.cselect.categoryID + "';</script>"); //else{ strSQL = "insert T_Goods_Update values('" + mod.GoodsId + "',getdate(),'');"; adohelper.ExecuteSqlNonQuery(strSQL); LogAdd.CreateLog(HttpContext.Current.Session["UserId"].ToString(), "编辑任务《" + mod.GoodsName + "》", "编辑", "", "", HttpContext.Current.Request.Url.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('编辑成功');</script>"); //} } } }
protected void btnSave_Click(object sender, ImageClickEventArgs e) { GoodsTypeModel mod; if (this.id != "" && this.id != null) { mod = bll.GetModel(this.id); } else { mod = new GoodsTypeModel(); } string pPath = ""; string[] codeList = this.cSelect.hfCode.Split('|'); StarTech.DBUtility.AdoHelper adoHelper = StarTech.DBUtility.AdoHelper.CreateHelper("DB_Instance"); if (codeList.Length < 1 || cSelect.hfCode == "") { mod.PCategoryId = ""; mod.CategoryLevel = 1; mod.CategoryPath = mod.CategoryId; } else { //if(this.cSelect.categoryID) mod.PCategoryId = codeList[codeList.Length - 1]; DataSet ds = adoHelper.ExecuteSqlDataset("select * from T_Info_Category where categoryid='" + KillSqlIn.Form_ReplaceByString(mod.PCategoryId, 20) + "';"); mod.CategoryLevel = Convert.ToInt32(ds.Tables[0].Rows[0]["CategoryLevel"].ToString()) + 1; pPath = ds.Tables[0].Rows[0]["CategoryPath"].ToString(); } if (pPath != "") { pPath += ","; } mod.CategoryName = this.txtMenuName.Text.Trim(); //mod.CategoryPath= //mod.Remarks = this.txtRemarks.Text.Trim(); int orderdy = 0; int.TryParse(this.txtSort.Text.Trim(), out orderdy); mod.Orderby = orderdy; mod.CategoryFlag = (this.cbIsVisible.Checked == true) ? "Course" : "Category"; if (fuImg.FileName != null && fuImg.FileName != "") { //mod.Url = fuImg.FileName; string nowUrl = Guid.NewGuid().ToString(); string tzm = fuImg.FileName.Substring(fuImg.FileName.LastIndexOf(".")); string url = "/upload/Category/" + nowUrl + "" + tzm; fuImg.SaveAs(Server.MapPath("~" + url)); mod.Url = url; } if (this.id != "" && this.id != null) { if (this.id == mod.PCategoryId) { ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('上级分类不能选择当前分类');layer_close_refresh();</script>"); return; } mod.CategoryPath = pPath + mod.CategoryId; if (bll.Update(mod)) { LogAdd.CreateLog(HttpContext.Current.Session["UserId"].ToString(), "修改任务分类《" + mod.CategoryName + "》", "修改", "", "", HttpContext.Current.Request.Url.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { mod.CategoryId = IdCreator.CreateId("T_Info_Category", "CategoryId"); mod.CategoryPath = pPath + mod.CategoryId; bll.Add(mod); LogAdd.CreateLog(HttpContext.Current.Session["UserId"].ToString(), "添加任务分类《" + mod.CategoryName + "》;", "添加", "", "", HttpContext.Current.Request.Url.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('添加成功');layer_close_refresh();</script>"); //JSUtility.ReplaceOpenerParentWindow("menuTree.aspx"); } //ModMenu detail = new ModMenu(); //detail.menuName = this.txtMenuName.Text.Trim(); //detail.menuTarget = this.txtMenuLink.Text.Trim(); //detail.isShow = (this.cbIsVisible.Checked == true ? 1 : 0); //detail.orderIndex = Convert.ToInt32(this.txtSort.Text.Trim()); //detail.parentMenuId = Convert.ToInt32(this.cSelect.categoryID); //if (this._menuId != null) //{ // int menuId = Convert.ToInt32(this._menuId); // detail.uniqueId = menuId; // this._menu.Update(detail); // ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); //} //else //{ // this._menu.Add(detail); // ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('添加成功');layer_close_refresh();</script>"); // //JSUtility.ReplaceOpenerParentWindow("menuTree.aspx"); //} }
/// <summary> /// 确定提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSubmit_Click(object sender, EventArgs e) { string strError = Validates(); if (!string.IsNullOrEmpty(strError)) { this.ClientScript.RegisterStartupScript(this.GetType(), "msg", "<script>alert('" + strError + "');</script>"); return; } model.CategoryId = Convert.ToInt32(this.ddlType.SelectedValue); model.Title = SafeRequest.GetFormString("txtTitle"); model.SubHead = SafeRequest.GetFormString("txtSubHead"); model.PublicationUnit = SafeRequest.GetFormString("txtUnit"); model.FromSource = SafeRequest.GetFormString("txtFromSouce"); // model.KeyWord = SafeRequest.GetFormString("txtKeyWord"); model.ReleaseDate = !string.IsNullOrEmpty(this.txtReleaseDate.Text.Trim()) ? Convert.ToDateTime(this.txtReleaseDate.Text.Trim()) : System.DateTime.Now; model.IsTop = 0; //SafeRequest.GetFormInt("radioTopList", 0); model.IndexCommend = 0; //SafeRequest.GetFormInt("radioIndexCommentList", 0); model.HotPic = SafeRequest.GetFormString("radioHotList"); model.HotDays = SafeRequest.GetFormInt("txtHotDays", 3); //model.ArticleType = SafeRequest.GetFormInt("radioArticleTypeList", 0); model.Body = this.fckBody.Text; //追加底部 if (cbFooter.Checked) { if (model.Body.IndexOf("start_auto_footer") == -1 && model.Body.IndexOf("end_auto_footer") == -1) { string autoFooter = "<!--start_auto_footer-->" + this.fckBodyFooter.Text + "<!--end_auto_footer-->"; model.Body = model.Body + autoFooter; } //写入缓存 NG.CachHelper.Redis.RedisHelper redis = new NG.CachHelper.Redis.RedisHelper(); redis.SetStringCash("News_Footer", this.fckBodyFooter.Text); redis.Close(); } // model.IsComment = 0;// SafeRequest.GetFormInt("radioIsComment", 0); model.Approved = SafeRequest.GetFormInt("radioApproved", 0); model.Sort = SafeRequest.GetFormInt("txtSort", 99); model.AddedDate = System.DateTime.Now; model.ExpireDate = System.DateTime.Now; model.ViewCount = 0; // model.IsScrool = 0; // model.AddedUserId = Convert.ToInt32(_userId);//默认登录进来人的编号 model.AddedUserId = 1; //~/upload/News/ #region 保存图片 if (!this.picUpload.Value.Equals("") && this.picUpload.PostedFile.ContentLength > 10) { string FileTZM = this.picUpload.PostedFile.FileName.Substring(this.picUpload.PostedFile.FileName.LastIndexOf(".") + 1);//得到文件的扩展名 if (!IsPic(FileTZM.ToLower())) { JSUtility.Alert("上传图片格式不正确!"); return; } if (this.picUpload.PostedFile.ContentLength > 1048576) { JSUtility.Alert("上传图片过大!"); return; } Random rnd = new Random(); string UpLoadFileTime = DateTime.Now.ToString("yyMMddHHmmss") + rnd.Next(9999).ToString("0000"); //生成一个新的数图片名称 string fileName = UpLoadFileTime + "." + FileTZM; //产生上传图片的名称 if (!Directory.Exists(Request.MapPath("~/upload/News/"))) { Directory.CreateDirectory(Request.MapPath("~/upload/News/")); } string Url = Request.MapPath("~/upload/News/" + fileName); picUpload.PostedFile.SaveAs(Url); model.ImgLink = "/upload/News/" + fileName; } else { model.ImgLink = ViewState["ImgLink"].ToString(); } #endregion if (_Pid != "") { model.NewsID = _Pid; if (bll.Update(model)) { this.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script>alert('修改成功');layer_close_refresh();</script>"); } } else { model.NewsID = IdCreator.CreateId("T_News", "NewsId"); if (bll.Add(model)) { JSUtility.AlertAndRedirect("添加成功,请继续添加!", Request.RawUrl.ToString()); } } }
protected void btnSave_Click(object sender, EventArgs e) { int updateInt = -1; if (this.id == "") { if (this.FileUpload1.HasFile == false) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('请选择任务图片');</script>"); return; } if (this.ddlMorePropertys.SelectedValue == "视频和练习") { if (this.FileUpload2.HasFile == false) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('请选择视频文件');</script>"); return; } } GoodsModel mod = new GoodsModel(); mod.GoodsId = IdCreator.CreateId("T_Goods_Info", "GoodsId"); mod.AddTime = DateTime.Now; mod.CategoryId = mod.GoodsToTypeId = this.hid_pgoodsid.Value; if (hfSign.Value.Length > 0) { mod.signId = hfSign.Value; } else { mod.signId = ""; } string fileExt = System.IO.Path.GetExtension(this.FileUpload1.FileName).ToLower(); if (fileExt != ".jpeg" && fileExt != ".jpg" && fileExt != ".png" && fileExt != ".bmp" && fileExt != ".gif") { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('图片格式不正确');</script>"); return; } if (this.FileUpload1.PostedFile.ContentLength > 1024000) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('图片不能大于1M');</script>"); return; } string newFileName = Guid.NewGuid().ToString() + fileExt; string dir = "/upload/goodsadmin/" + DateTime.Now.ToString("yyyyMMdd") + "/"; if (System.IO.Directory.Exists(Server.MapPath(dir)) == false) { System.IO.Directory.CreateDirectory(Server.MapPath(dir)); } string newPath = dir + newFileName; this.FileUpload1.SaveAs(Server.MapPath(newPath)); //缩略图 //MakeSmallPic(Server.MapPath(newPath), Server.MapPath(newPath.Replace(fileExt, "_s" + fileExt))); //mod.GoodsSmallPic = newPath.Replace(fileExt, "_s" + fileExt); mod.GoodsSmallPic = newPath; ViewState["OriginalBigImg"] = mod.GoodsSmallPic; //视频文件_start if (this.FileUpload2.HasFile == true) { string fileExt_video = System.IO.Path.GetExtension(this.FileUpload2.FileName).ToLower(); if (fileExt_video != ".mp4") { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('视频格式不正确');</script>"); return; } string newFileName_video = Guid.NewGuid().ToString() + fileExt_video; string dir_video = "/upload/goodsadmin/" + DateTime.Now.ToString("yyyyMMdd") + "/"; if (System.IO.Directory.Exists(Server.MapPath(dir_video)) == false) { System.IO.Directory.CreateDirectory(Server.MapPath(dir_video)); } string newPath_video = dir_video + newFileName_video; this.FileUpload2.SaveAs(Server.MapPath(newPath_video)); mod.BookInfo = newPath_video; } //视频文件_end GetFormInfo(ref mod); if (mod.CategoryId == "1") { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('未选择分类')</script>"); } if (bll.Add(mod) > 0) { //默认幻灯图片 //if (ViewState["OriginalBigImg"] != null) { AddDefaultPic(mod.GoodsId, ViewState["OriginalBigImg"].ToString()); } LogAdd.CreateLog(HttpContext.Current.Session["UserId"].ToString(), "添加任务《" + mod.GoodsName + "》", "添加", "", "", HttpContext.Current.Request.Url.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>if(confirm('保存成功')){location.href='SubGoodsAdd.aspx?id=" + mod.GoodsId + "'}else{}</script>"); } } else { updateInt = 0; //string strSQL = "select * from T_Goods_Update where goodsid='" + id+"' and updatetime>'"+DateTime.Now.ToShortDateString()+" 00:00:00';"; string strSQL = ""; AdoHelper adohelper = StarTech.DBUtility.AdoHelper.CreateHelper(AppConfig.DBInstance); //DataSet ds = adohelper.ExecuteSqlDataset(strSQL); //if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count >= 0) //{ // if (ds.Tables[0].Rows.Count > 2) // { // ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('编辑成功');</script>"); // return; // } // else // { // updateInt = 2 - ds.Tables[0].Rows.Count; // } //} GoodsModel mod = bll.GetModel(this.id); if (this.FileUpload1.HasFile == true) { string fileExt = System.IO.Path.GetExtension(this.FileUpload1.FileName).ToLower(); if (fileExt != ".jpeg" && fileExt != ".jpg" && fileExt != ".png" && fileExt != ".bmp" && fileExt != ".gif") { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('图片格式不正确');</script>"); return; } if (this.FileUpload1.PostedFile.ContentLength > 1024000) { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('图片不能大于1M');</script>"); return; } string newFileName = Guid.NewGuid().ToString() + fileExt; string dir = "/upload/goodsadmin/" + DateTime.Now.ToString("yyyyMMdd") + "/"; if (System.IO.Directory.Exists(Server.MapPath(dir)) == false) { System.IO.Directory.CreateDirectory(Server.MapPath(dir)); } string newPath = dir + newFileName; this.FileUpload1.SaveAs(Server.MapPath(newPath)); //缩略图 //MakeSmallPic(Server.MapPath(newPath), Server.MapPath(newPath.Replace(fileExt, "_s" + fileExt))); //mod.GoodsSmallPic = newPath.Replace(fileExt, "_s" + fileExt); mod.GoodsSmallPic = newPath; ViewState["OriginalBigImg"] = mod.GoodsSmallPic; } //视频文件_start if (this.FileUpload2.HasFile == true) { string fileExt_video = System.IO.Path.GetExtension(this.FileUpload2.FileName).ToLower(); if (fileExt_video != ".mp4") { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('视频格式不正确');</script>"); return; } string newFileName_video = Guid.NewGuid().ToString() + fileExt_video; string dir_video = "/upload/goodsadmin/" + DateTime.Now.ToString("yyyyMMdd") + "/"; if (System.IO.Directory.Exists(Server.MapPath(dir_video)) == false) { System.IO.Directory.CreateDirectory(Server.MapPath(dir_video)); } string newPath_video = dir_video + newFileName_video; this.FileUpload2.SaveAs(Server.MapPath(newPath_video)); mod.BookInfo = newPath_video; } //视频文件_end //hfSign.Value = hfSign.Value.Replace("--", "-"); if (hfSign.Value.Length > 0) { mod.signId = hfSign.Value; } else { mod.signId = ""; } GetFormInfo(ref mod); if (bll.Update(mod)) { adohelper.ExecuteSqlNonQuery("update T_Goods_Info set JobDay=datediff(day,JobStartTime,JobEndTime) where GoodsId='" + mod.GoodsId + "'"); //默认图片 //if (ViewState["OriginalBigImg"] != null) { AddDefaultPic(mod.GoodsId, ViewState["OriginalBigImg"].ToString()); } //if (updateInt == -1) // ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('保存成功');location.href='GoodsList.aspx?id=" + this.cselect.categoryID + "';</script>"); //else{ strSQL = "insert T_Goods_Update values('" + mod.GoodsId + "',getdate(),'');"; adohelper.ExecuteSqlNonQuery(strSQL); LogAdd.CreateLog(HttpContext.Current.Session["UserId"].ToString(), "编辑任务《" + mod.GoodsName + "》", "编辑", "", "", HttpContext.Current.Request.Url.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('编辑成功');</script>"); //} } } }
/// <summary> /// 保存信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, ImageClickEventArgs e) { MenuModel model = new MenuModel(); if (menuId != null && menuId != "") { model = new MenuBll().GetModel(menuId); if (model == null) { model = new MenuModel(); } } model.menuName = txtMenuName.Text; model.Flavor = txtFlavor.Text; //model.Technology=ddlTechnology.SelectedValue; model.Technology = txtTechnology.Text; model.Flavor = txtFlavor.Text; model.CookingTime = txtCookieTime.Text; model.CookingSkill = txtCookingSkill.Text; string[] strCode = selectMenu.hfCode.Split('|'); if (strCode.Length > 0) { model.categoryId = strCode[strCode.Length - 1]; } if (strCode[strCode.Length - 1] == "") { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('未选择分类');</script>"); } if (hfSign.Value.Length > 0) { model.signId = hfSign.Value; } else { model.signId = ""; } decimal d = 0; if (decimal.TryParse(txtCalorie.Text, out d)) { model.Calorie = d; } model.isShow = cbShow.Checked ? 1 : 0; model.isTop = cbTop.Checked ? 1 : 0; if (fuBigImg.FileName.ToLower().Contains(".jpg") || fuBigImg.FileName.ToLower().Contains(".png") || fuBigImg.FileName.ToLower().Contains(".bmp") || fuBigImg.FileName.ToLower().Contains(".gif")) { string filePath = "/Upload/Menu/" + DateTime.Now.Year + "/" + DateTime.Now.Month + "/" + DateTime.Now.Day + "/"; if (!Directory.Exists(Server.MapPath(filePath))) { Directory.CreateDirectory(Server.MapPath(filePath)); } string fileName = DateTime.Now.Hour + "" + DateTime.Now.Minute + "" + DateTime.Now.Second + new Random().Next(10, 99); string tzm = fuBigImg.FileName.Substring(fuBigImg.FileName.LastIndexOf(".")); fuBigImg.SaveAs(Server.MapPath(filePath + fileName + tzm)); model.imgSrc = filePath + fileName + tzm; if (model.imgSrc != null && model.imgSrc != "") { llBigImg.Text = "<img src='" + model.imgSrc + "' width='100px' height='100px'/>"; } } else if (fuBigImg.FileName != null && fuBigImg.FileName != "") { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('展示图图片格式不正确');</script>"); return; } if (fuSmallImg.FileName.ToLower().Contains(".jpg") || fuSmallImg.FileName.ToLower().Contains(".png") || fuSmallImg.FileName.ToLower().Contains(".bmp") || fuSmallImg.FileName.ToLower().Contains(".gif")) { string filePath = "/Upload/Menu/" + DateTime.Now.Year + "/" + DateTime.Now.Month + "/" + DateTime.Now.Day + "/"; string fileName = DateTime.Now.Hour + "" + DateTime.Now.Minute + "" + DateTime.Now.Second + new Random().Next(10, 99); string tzm = fuSmallImg.FileName.Substring(fuSmallImg.FileName.LastIndexOf(".")); fuSmallImg.SaveAs(Server.MapPath(filePath + fileName + tzm)); model.smallImgSrc = filePath + fileName + tzm; if (model.smallImgSrc != null && model.smallImgSrc != "") { llSmallImg.Text = "<img src='" + model.smallImgSrc + "' width='100px' height='100px'/>"; } } else if (fuSmallImg.FileName != null && fuSmallImg.FileName != "") { ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('预览图图片格式不正确');</script>"); return; } if (menuId == null || menuId == "") { model.menuId = IdCreator.CreateId("T_Menu_Info", "menuId"); model.AddTime = DateTime.Now; if (new MenuBll().Add(model)) { BindItemInfo(model.menuId); LogAdd.CreateLog(Session["UserId"].ToString(), "添加菜谱《" + model.menuName + "》", "添加", "", "", Request.Url.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('添加成功');layer_close_refresh();</script>"); } } else { //model.menuId = IdCreator.CreateId("T_Menu_Info", "menuId"); if (new MenuBll().Update(model)) { BindItemInfo(model.menuId); LogAdd.CreateLog(Session["UserId"].ToString(), "修改菜谱《" + model.menuName + "》", "修改", "", "", Request.Url.ToString()); ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('修改成功');layer_close_refresh();</script>"); } } }