//此类一般不需要更改,因为保存的工作全部放在下面的SaveData中 protected void btnSubmit_Click(object sender, EventArgs e) { string sResult = "-1"; //保存 Workflow_AgentSettingEntity _Workflow_AgentSettingEntity = new Workflow_AgentSettingEntity(); _Workflow_AgentSettingEntity.AgentID = Convert.ToInt32((txtAgentID.Value == "") ? "0" : txtAgentID.Value); _Workflow_AgentSettingEntity.BeAgentPersonID = Convert.ToInt32(txtBeAgentPersonID.Value); _Workflow_AgentSettingEntity.AgentPersonID = Convert.ToInt32(txtAgentPersonID.Value); if (txtAgentStartDate.Text.ToString() != "") _Workflow_AgentSettingEntity.AgentStartDate = Convert.ToDateTime(txtAgentStartDate.Text.ToString()); else _Workflow_AgentSettingEntity.AgentStartDate = Convert.ToDateTime( System.DBNull.Value) ; if (txtAgentEndDate.Text.ToString() != "") _Workflow_AgentSettingEntity.AgentEndDate = Convert.ToDateTime(txtAgentEndDate.Text.ToString()); else _Workflow_AgentSettingEntity.AgentEndDate = Convert.ToDateTime( System.DBNull.Value) ; _Workflow_AgentSettingEntity.CreateDate = Convert.ToDateTime(nowdatetime); _Workflow_AgentSettingEntity.Creator = userEntity.UserSerialID ; _Workflow_AgentSettingEntity.AllowCycle = chkAllowCycle.Checked ? "1" : "0"; _Workflow_AgentSettingEntity.AllowCreate = chkAllowCreate.Checked ? "1" : "0"; if (JudgeAgentBeforeAddAndUpdate(_Workflow_AgentSettingEntity)) { sResult = SaveData(_Workflow_AgentSettingEntity); if (sResult == " -1") { // lblMsg.Text = ResourceManager.GetString("Operation_RECORD"); string strScript = "<script type='text/javascript' lanuage='javascript'> alert('" + ResourceManager.GetString("Operation_RECORD") + "'); </script>"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", strScript, false); } else { // lblMsg.Text = ResourceManager.GetString(""); string strScript = "<script type='text/javascript' lanuage='javascript'> alert('" + ResourceManager.GetString("Button_GoComplete") + "'); </script>"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", strScript, false); } } else // lblMsg.Text = ResourceManager.GetString("REPLICATED_DATA"); { string strScript = "<script type='text/javascript' lanuage='javascript'> alert('" + ResourceManager.GetString("REPLICATED_DATA") + "'); </script>"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alert", strScript, false); } System.Web.UI.ScriptManager.RegisterStartupScript(btnSubmit, this.GetType(), "ButtonHideScript", strButtonHideScript, false); }
/// <summary> /// 新增信息,前台插入时已做判断,在此处不需再判断 /// </summary> /// <param name="_Workflow_AgentSettingEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string AddWorkflow_AgentSetting(Workflow_AgentSettingEntity _Workflow_AgentSettingEntity) { DbParameter[] pramsInsert = { MakeInParam("@WorkflowID",(DbType)SqlDbType.Int,4,_Workflow_AgentSettingEntity.WorkflowID ), MakeInParam("@BeAgentPersonID",(DbType)SqlDbType.Int,4,_Workflow_AgentSettingEntity.BeAgentPersonID ), MakeInParam("@AgentPersonID",(DbType)SqlDbType.Int,4,_Workflow_AgentSettingEntity.AgentPersonID ), MakeInParam("@AgentStartDate",(DbType)SqlDbType.DateTime ,23,_Workflow_AgentSettingEntity.AgentStartDate ), MakeInParam("@AgentEndDate",(DbType)SqlDbType.DateTime,23,_Workflow_AgentSettingEntity.AgentEndDate ), MakeInParam("@CreateDate",(DbType)SqlDbType.DateTime,23,_Workflow_AgentSettingEntity.CreateDate ), MakeInParam("@Creator",(DbType)SqlDbType.Int,4,_Workflow_AgentSettingEntity.Creator ), MakeInParam("@AllowCycle",(DbType)SqlDbType.Char,1,_Workflow_AgentSettingEntity.AllowCycle ), MakeInParam("@AllowCreate",(DbType)SqlDbType.Char,1,_Workflow_AgentSettingEntity.AllowCreate )//, }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Workflow_AgentSetting]"); sb.Append("("); sb.Append("[WorkflowID]"); sb.Append(",[BeAgentPersonID]"); sb.Append(",[AgentPersonID]"); sb.Append(",[AgentStartDate]"); sb.Append(",[AgentEndDate]"); sb.Append(",[CreateDate]"); sb.Append(",[Creator]"); // sb.Append(",[IsCancel]"); sb.Append(",[AllowCycle]"); sb.Append(",[AllowCreate]"); sb.Append(") "); sb.Append(" VALUES ("); sb.Append("@WorkflowID,"); sb.Append("@BeAgentPersonID,"); sb.Append("@AgentPersonID,"); sb.Append("@AgentStartDate,"); sb.Append("@AgentEndDate,"); sb.Append("@CreateDate,"); sb.Append("@Creator,"); sb.Append("@AllowCycle,"); sb.Append("@AllowCreate);"); sb.Append("select @@identity;"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); }
private Workflow_AgentSettingEntity GetWorkflow_AgentSettingFromIDataReader(DbDataReader dr) { Workflow_AgentSettingEntity dt = new Workflow_AgentSettingEntity(); if (dr.FieldCount > 0) { if (dr["AgentID"].ToString() != "" || dr["AgentID"] != null) dt.AgentID = Int32.Parse(dr["AgentID"].ToString()); if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString()); if (dr["BeAgentPersonID"].ToString() != "" || dr["BeAgentPersonID"] != null) dt.BeAgentPersonID = Int32.Parse(dr["BeAgentPersonID"].ToString()); if (dr["AgentPersonID"].ToString() != "" || dr["AgentPersonID"] != null) dt.AgentPersonID = Int32.Parse(dr["AgentPersonID"].ToString()); if (dr["AgentStartDate"].ToString() != "" || dr["AgentStartDate"].ToString() != null) dt.AgentStartDate = Convert.ToDateTime(dr["AgentStartDate"].ToString()); if (dr["AgentEndDate"].ToString() != "" || dr["AgentEndDate"].ToString() != null) dt.AgentEndDate = Convert.ToDateTime(dr["AgentEndDate"].ToString()); if (dr["CreateDate"].ToString() != "" || dr["CreateDate"].ToString() != null) dt.CreateDate = Convert.ToDateTime(dr["CreateDate"].ToString()); if (dr["Creator"].ToString() != "" || dr["Creator"] != null) dt.Creator = Int32.Parse(dr["Creator"].ToString()); dt.IsCancel = dr["IsCancel"].ToString(); dt.AllowCycle = dr["AllowCycle"].ToString(); dt.AllowCreate = dr["AllowCreate"].ToString(); if (dr["CancelOperator"].ToString() != "" || dr["CancelOperator"] != null) dt.CancelOperator = Int32.Parse(dr["CancelOperator"].ToString()); if (dr["CancelDate"].ToString() != "" || dr["CancelDate"].ToString() != null) dt.CancelDate = Convert.ToDateTime(dr["CancelDate"].ToString()); dr.Close(); return dt; } dr.Close(); return null; }
/// <summary> /// 修改信息 /// </summary> /// <param name="_Workflow_AgentSettingEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string UpdateWorkflow_AgentSetting(Workflow_AgentSettingEntity _Workflow_AgentSettingEntity) { DbParameter[] pramsUpdate = { MakeInParam("@WorkflowID",(DbType)SqlDbType.Int,4,_Workflow_AgentSettingEntity.WorkflowID ), MakeInParam("@BeAgentPersonID",(DbType)SqlDbType.Int,4,_Workflow_AgentSettingEntity.BeAgentPersonID ), MakeInParam("@AgentPersonID",(DbType)SqlDbType.Int,4,_Workflow_AgentSettingEntity.AgentPersonID ), MakeInParam("@AgentStartDate",(DbType)SqlDbType.DateTime,23,_Workflow_AgentSettingEntity.AgentStartDate ), MakeInParam("@AgentEndDate",(DbType)SqlDbType.DateTime,23,_Workflow_AgentSettingEntity.AgentEndDate ), MakeInParam("@CreateDate",(DbType)SqlDbType.DateTime,23,_Workflow_AgentSettingEntity.CreateDate ), MakeInParam("@Creator",(DbType)SqlDbType.Int,4,_Workflow_AgentSettingEntity.Creator ), MakeInParam("@AllowCycle",(DbType)SqlDbType.Char,1,_Workflow_AgentSettingEntity.AllowCycle ), MakeInParam("@AllowCreate",(DbType)SqlDbType.Char,1,_Workflow_AgentSettingEntity.AllowCreate ) , MakeInParam("@AgentID",(DbType)SqlDbType.Int,4,_Workflow_AgentSettingEntity.AgentID ) }; StringBuilder sb = new StringBuilder(); sb.Append("Update [dbo].[Workflow_AgentSetting]"); sb.Append(" set "); sb.Append(" [WorkflowID]=@WorkflowID,"); sb.Append(" [BeAgentPersonID]=@BeAgentPersonID,"); sb.Append(" [AgentPersonID]=@AgentPersonID,"); sb.Append(" [AgentStartDate]=@AgentStartDate,"); sb.Append(" [AgentEndDate]=@AgentEndDate,"); sb.Append(" [CreateDate]=@CreateDate,"); sb.Append(" [Creator]=@Creator,"); sb.Append(" [AllowCycle]=@AllowCycle,"); sb.Append(" [AllowCreate]=@AllowCreate"); sb.Append(" where [AgentID]=@AgentID;select @@RowCount"); return Convert.ToString(ExecuteScalar(CommandType.Text, sb.ToString(), pramsUpdate)); }
/// <summary> /// JudgeAgentBeforeAddAndUpdate 判断是否可插入. /// </summary> /// <param name="_ASE"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string JudgeAgentBeforeAddAndUpdate(Workflow_AgentSettingEntity _ASE) { //判断该记录是否已经存在 DbParameter[] prams = { MakeInParam("@WorkflowID",(DbType)SqlDbType.Int,4,_ASE.WorkflowID ), MakeInParam("@BeAgentPersonID",(DbType)SqlDbType.Int,4,_ASE.BeAgentPersonID ), MakeInParam("@AgentStartDate",(DbType)SqlDbType.DateTime,23,_ASE.AgentStartDate ), MakeInParam("@AgentEndDate",(DbType)SqlDbType.DateTime,23,_ASE.AgentEndDate ) }; StringBuilder sb = new StringBuilder(); sb.Append(" select AgentID from Workflow_AgentSetting "); sb.Append(" where "); sb.Append(" [WorkflowID]=@WorkflowID"); sb.Append(" and IsCancel='0'"); sb.Append(" and BeAgentPersonID=@BeAgentPersonID"); sb.Append(" and ("); sb.Append(" (AgentStartDate>=@AgentStartDate and AgentStartDate<=@AgentEndDate)"); sb.Append(" or "); sb.Append(" (AgentStartDate<=@AgentStartDate and AgentEndDate>=@AgentStartDate)"); sb.Append(" )"); DataTable dt = new DataTable(); dt = (ExecuteDataset(CommandType.Text, sb.ToString(), prams)).Tables[0]; if ((dt.Rows.Count == 1)) { if (dt.Rows[0]["AgentID"].ToString() == _ASE.AgentID.ToString()) return "0";//用做在修改时判定是否可更新 else return "-1"; } else if (dt.Rows.Count >= 1) { return "-1";//该记录已经存在 } else return "0"; }
//此类要更改,完成赋值工作 private string SaveData(Workflow_AgentSettingEntity _Workflow_AgentSettingEntity) { string sResult = "-1"; if (txtWorkflowID.Value.Trim().IndexOf(",") > 0) { string[] wfID = txtWorkflowID.Value.Trim().Split(new Char[] { ',' }); for (int i = 0; i < wfID.GetLength(0); i++) { _Workflow_AgentSettingEntity.WorkflowID = Convert.ToInt32(wfID[i]); if (ViewState["status"].ToString () == "Add") sResult = DbHelper.GetInstance().AddWorkflow_AgentSetting(_Workflow_AgentSettingEntity); else if (ViewState["status"].ToString() == "Update") sResult = DbHelper.GetInstance().UpdateWorkflow_AgentSetting(_Workflow_AgentSettingEntity); } return sResult; } else { _Workflow_AgentSettingEntity.WorkflowID = Convert.ToInt32(txtWorkflowID.Value); if (ViewState["status"].ToString() == "Add") sResult = DbHelper.GetInstance().AddWorkflow_AgentSetting(_Workflow_AgentSettingEntity); else if (ViewState["status"].ToString() == "Update") sResult = DbHelper.GetInstance().UpdateWorkflow_AgentSetting(_Workflow_AgentSettingEntity); return sResult; } }
private bool JudgeAgentBeforeAddAndUpdate(Workflow_AgentSettingEntity _ASE ) { string sResult = "-1"; if (txtWorkflowID.Value.Trim().IndexOf(",") > 0) { string[] wfID = txtWorkflowID.Value.Trim().Split(new Char[] { ',' }); for (int i = 0; i < wfID.GetLength(0); i++) { _ASE.WorkflowID = Convert.ToInt32(wfID[i]); sResult = DbHelper.GetInstance().JudgeAgentBeforeAddAndUpdate(_ASE); if (sResult != "-1") { return false; } } return true ; } else { _ASE.WorkflowID = Convert.ToInt32(txtWorkflowID.Value); sResult = DbHelper.GetInstance().JudgeAgentBeforeAddAndUpdate(_ASE ); if ((sResult == "-1")) return false ; else return true; } }