//此类一般不需要更改,因为保存的工作全部放在下面的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;
}
}
