protected void btn_Save_Click(object sender, ImageClickEventArgs e) { SYS_PositionEntity Entity = new SYS_PositionEntity(); if (Request.QueryString["PositonID"] != null) { Entity = position.GetModel(Request.QueryString["PositonID"].ToString()); } Entity.PositionName = this.txt_PositionName.Text; Entity.Remark = this.txt_Remark.Text; Entity.IsForbid = "0"; if (Request.QueryString["PositonID"] != null)//修改保存 { DataSet pDs = position.GetPositionList(" PositionName='" + CommonMethod.RepChar(Entity.PositionName) + "' and PositionCode<>'" + Request.QueryString["PositonID"].ToString() + "'"); if (pDs.Tables[0].Rows.Count > 0) { MessageBox.Show(this.upDepartAdd, this, "您输入的职位名称已经存在!"); return; } if (position.Update(Entity) == 1) { #region 数据同步 if (ConfigurationManager.AppSettings["IsSync"] == "1") { try { //添加成功,数据同步到各个磅房 IndustryPlatform.DBUtility.MsmqManage msm = MsmqManage.GetMsmq(); string strSQL = "update Sys_Position set " + "[PositionCode] = '" + Entity.PositionCode + "'," + "[PositionName] = '" + CommonMethod.RepChar(Entity.PositionName) + "'," + "[Remark] = '" + CommonMethod.RepChar(Entity.Remark) + "'," + "[IsForbid] = '" + Entity.IsForbid + "' where [PositionCode]='" + Entity.PositionCode + "'"; strSQL = msm.AllStation + msm.Prefix + "Sys_Position" + msm.Prefix + msm.EditFlg + msm.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + msm.Prefix + strSQL; msm.AddMsmq(strSQL); } catch { } } #endregion ScriptManager.RegisterStartupScript(this, this.GetType(), "myscript", "alert('修改成功!'); top.currForm.close();", true); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "myscript", "alert('修改失败!');", true); } } else//新增保存 { DataSet pDs = position.GetPositionList(" PositionName='" + CommonMethod.RepChar(Entity.PositionName) + "'"); if (pDs.Tables[0].Rows.Count > 0) { MessageBox.Show(this.upDepartAdd, this, "您输入的职位名称已经存在!"); return; } lock (this) { Entity.PositionCode = DbHelperSQL.GetBaseMaxID("PositionCode", "SYS_Position", " PositionCode<>'0'"); Entity.IsForbid = "0"; if (position.Add(Entity) == 1) { #region 数据同步 if (ConfigurationManager.AppSettings["IsSync"] == "1") { try { //添加成功,数据同步到各个磅房 IndustryPlatform.DBUtility.MsmqManage msm = MsmqManage.GetMsmq(); string strSQL = "INSERT INTO Sys_Position ( " + "[PositionCode] ," + "[PositionName] ," + "[Remark] ," + "[IsForbid] ) VALUES ('" + Entity.PositionCode + "','" + CommonMethod.RepChar(Entity.PositionName) + "','" + CommonMethod.RepChar(Entity.Remark) + "','" + Entity.IsForbid + "')"; strSQL = msm.AllStation + msm.Prefix + "Sys_Position" + msm.Prefix + msm.AddFlg + msm.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") + msm.Prefix + strSQL; msm.AddMsmq(strSQL); } catch { } } #endregion SetText(); ScriptManager.RegisterStartupScript(this, this.GetType(), "myscript", "alert('添加成功!');", true); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "myscript", "alert('添加失败!');", true); } } } }