protected void hideModalPopupViaServer_Click(object sender, EventArgs e)
{
GPRP.GPRPControls.Button btn = (GPRP.GPRPControls.Button)sender;
string sResult = "-1";
if (btn.ID == "btnSubmit")
{
Workflow_BaseEntity _Workflow_BaseEntity = new Workflow_BaseEntity();
_Workflow_BaseEntity.WorkflowID = txtWorkflowID.Value != string.Empty ? Convert.ToInt32(txtWorkflowID.Value) : 0;
_Workflow_BaseEntity.WorkflowName = txtWorkflowName.Text;
_Workflow_BaseEntity.WorkflowDesc = txtWorkflowDesc.Text;
_Workflow_BaseEntity.FlowTypeID = Convert.ToInt32(ddlFlowTypeID.SelectedValue);
_Workflow_BaseEntity.FormID = Convert.ToInt32(txtFormID.Value);
_Workflow_BaseEntity.IsValid = chkIsValid.Checked ? 1 : 0;
_Workflow_BaseEntity.IsMailNotice = chkIsMailNotice.Checked ? 1 : 0;
_Workflow_BaseEntity.IsMsgNotice = chkIsMsgNotice.Checked ? 1 : 0;
_Workflow_BaseEntity.IsTransfer = chkIsTransfer.Checked ? 1 : 0;
_Workflow_BaseEntity.AttachDocPath = 0;
_Workflow_BaseEntity.HelpDocPath = 0;
_Workflow_BaseEntity.DisplayOrder = Convert.ToInt32(txtDisplayOrder.Text);
sResult = DbHelper.GetInstance().UpdateWorkflow_Base(_Workflow_BaseEntity);
if (sResult != "1")
{
lblMsg.Text = ResourceManager.GetString("Operation_RECORD") + ":" + sResult;
}
}
System.Web.UI.ScriptManager.RegisterStartupScript(btn, this.GetType(), "ButtonHideScript", strButtonHideScript, false);
}
private string SaveData()
{
Workflow_BaseEntity _Workflow_BaseEntity = new Workflow_BaseEntity();
_Workflow_BaseEntity.WorkflowID = txtWorkflowID.Value != string.Empty ? Convert.ToInt32(txtWorkflowID.Value) : 0;
_Workflow_BaseEntity.WorkflowName = txtWorkflowName.Text;
_Workflow_BaseEntity.WorkflowDesc = txtWorkflowDesc.Text;
_Workflow_BaseEntity.FlowTypeID = Convert.ToInt32(ddlFlowTypeID.SelectedValue);
_Workflow_BaseEntity.FormID = Convert.ToInt32(txtFormID.Value);
_Workflow_BaseEntity.IsValid = chkIsValid.Checked ? 1 : 0;
_Workflow_BaseEntity.IsMailNotice = chkIsMailNotice.Checked ? 1 : 0;
_Workflow_BaseEntity.IsMsgNotice = chkIsMsgNotice.Checked ? 1 : 0;
_Workflow_BaseEntity.IsTransfer = chkIsTransfer.Checked ? 1 : 0;
_Workflow_BaseEntity.AttachDocPath = 0;
_Workflow_BaseEntity.HelpDocPath = 0;
_Workflow_BaseEntity.DisplayOrder = Convert.ToInt32(txtDisplayOrder.Text);
string sResult = "-1";
if (strOperationState == "Add")
sResult = DbHelper.GetInstance().AddWorkflow_Base(_Workflow_BaseEntity);
else if (strOperationState == "Update")
sResult = DbHelper.GetInstance().UpdateWorkflow_Base(_Workflow_BaseEntity);
return sResult;
}
private Workflow_BaseEntity GetWorkflow_BaseFromIDataReader(DbDataReader dr)
{
Workflow_BaseEntity dt = new Workflow_BaseEntity();
if (dr.FieldCount > 0)
{
if (dr["WorkflowID"].ToString() != "" || dr["WorkflowID"] != null) dt.WorkflowID = Int32.Parse(dr["WorkflowID"].ToString());
dt.WorkflowName = dr["WorkflowName"].ToString();
dt.WorkflowDesc = dr["WorkflowDesc"].ToString();
if (dr["FlowTypeID"].ToString() != "" || dr["FlowTypeID"] != null) dt.FlowTypeID = Int32.Parse(dr["FlowTypeID"].ToString());
if (dr["FormID"].ToString() != "" || dr["FormID"] != null) dt.FormID = Int32.Parse(dr["FormID"].ToString());
if (dr["IsValid"].ToString() != "" || dr["IsValid"] != null) dt.IsValid = Int32.Parse(dr["IsValid"].ToString());
if (dr["IsMailNotice"].ToString() != "" || dr["IsMailNotice"] != null) dt.IsMailNotice = Int32.Parse(dr["IsMailNotice"].ToString());
if (dr["IsMsgNotice"].ToString() != "" || dr["IsMsgNotice"] != null) dt.IsMsgNotice = Int32.Parse(dr["IsMsgNotice"].ToString());
if (dr["IsTransfer"].ToString() != "" || dr["IsTransfer"] != null) dt.IsTransfer = Int32.Parse(dr["IsTransfer"].ToString());
if (dr["AttachDocPath"].ToString() != "" || dr["AttachDocPath"] != null) dt.AttachDocPath = Int32.Parse(dr["AttachDocPath"].ToString());
if (dr["HelpDocPath"].ToString() != "" || dr["HelpDocPath"] != null) dt.HelpDocPath = Int32.Parse(dr["HelpDocPath"].ToString());
if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
/// <summary>
/// 新增信息
/// </summary>
/// <param name="_Workflow_BaseEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddWorkflow_Base(Workflow_BaseEntity _Workflow_BaseEntity)
{
//判断该记录是否已经存在
DbParameter[] prams = { MakeInParam("@WorkflowName",(DbType)SqlDbType.VarChar,200,_Workflow_BaseEntity.WorkflowName),
};
string sql = "select * from [dbo].[Workflow_Base] where WorkflowName=@WorkflowName ";
if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0)
{
return "-1";//该记录已经存在
}
else
{
DbParameter[] pramsInsert = {
MakeInParam("@WorkflowName",(DbType)SqlDbType.VarChar,200,_Workflow_BaseEntity.WorkflowName ),
MakeInParam("@WorkflowDesc",(DbType)SqlDbType.VarChar,2000,_Workflow_BaseEntity.WorkflowDesc ),
MakeInParam("@FlowTypeID",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.FlowTypeID ),
MakeInParam("@FormID",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.FormID ),
MakeInParam("@IsValid",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.IsValid ),
MakeInParam("@IsMailNotice",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.IsMailNotice ),
MakeInParam("@IsMsgNotice",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.IsMsgNotice ),
MakeInParam("@IsTransfer",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.IsTransfer ),
MakeInParam("@AttachDocPath",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.AttachDocPath ),
MakeInParam("@HelpDocPath",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.HelpDocPath ),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.DisplayOrder ),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_Base]");
sb.Append("(");
sb.Append(" [WorkflowName]");
sb.Append(",[WorkflowDesc]");
sb.Append(",[FlowTypeID]");
sb.Append(",[FormID]");
sb.Append(",[IsValid]");
sb.Append(",[IsMailNotice]");
sb.Append(",[IsMsgNotice]");
sb.Append(",[IsTransfer]");
sb.Append(",[AttachDocPath]");
sb.Append(",[HelpDocPath]");
sb.Append(",[DisplayOrder]");
sb.Append(") ");
sb.Append(" VALUES (");
sb.Append("@WorkflowName,");
sb.Append("@WorkflowDesc,");
sb.Append("@FlowTypeID,");
sb.Append("@FormID,");
sb.Append("@IsValid,");
sb.Append("@IsMailNotice,");
sb.Append("@IsMsgNotice,");
sb.Append("@IsTransfer,");
sb.Append("@AttachDocPath,");
sb.Append("@HelpDocPath,");
sb.Append("@DisplayOrder )");
sb.Append("select @@identity;");
// ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert);
_Workflow_BaseEntity.WorkflowID = Convert.ToInt32(ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString());
ArrayList arlst = new ArrayList();
arlst.Add("Workflow_Base");
arlst.Add(_Workflow_BaseEntity.FlowTypeID);
arlst.Add("");
return sp_ReDisplayOrder(arlst);
}
}
/// <summary>
/// 修改信息
/// </summary>
/// <param name="_Workflow_BaseEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string UpdateWorkflow_Base(Workflow_BaseEntity _Workflow_BaseEntity)
{
DbParameter[] pramsUpdate = {
MakeInParam("@WorkflowID",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.WorkflowID ),
MakeInParam("@WorkflowName",(DbType)SqlDbType.VarChar,200,_Workflow_BaseEntity.WorkflowName ),
MakeInParam("@WorkflowDesc",(DbType)SqlDbType.VarChar,2000,_Workflow_BaseEntity.WorkflowDesc ),
MakeInParam("@FlowTypeID",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.FlowTypeID ),
MakeInParam("@FormID",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.FormID ),
MakeInParam("@IsValid",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.IsValid ),
MakeInParam("@IsMailNotice",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.IsMailNotice ),
MakeInParam("@IsMsgNotice",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.IsMsgNotice ),
MakeInParam("@IsTransfer",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.IsTransfer ),
MakeInParam("@AttachDocPath",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.AttachDocPath ),
MakeInParam("@HelpDocPath",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.HelpDocPath ),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_BaseEntity.DisplayOrder ),
};
StringBuilder sb = new StringBuilder();
sb.Append("Update [dbo].[Workflow_Base]");
sb.Append(" set ");
sb.Append(" [WorkflowName]=@WorkflowName,");
sb.Append(" [WorkflowDesc]=@WorkflowDesc,");
sb.Append(" [FlowTypeID]=@FlowTypeID,");
sb.Append(" [FormID]=@FormID,");
sb.Append(" [IsValid]=@IsValid,");
sb.Append(" [IsMailNotice]=@IsMailNotice,");
sb.Append(" [IsMsgNotice]=@IsMsgNotice,");
sb.Append(" [IsTransfer]=@IsTransfer,");
sb.Append(" [AttachDocPath]=@AttachDocPath,");
sb.Append(" [HelpDocPath]=@HelpDocPath, ");
sb.Append(" [DisplayOrder]=@DisplayOrder ");
sb.Append(" where [WorkflowID]=@WorkflowID ");
ExecuteNonQuery(CommandType.Text, sb.ToString(), pramsUpdate).ToString();
ArrayList arlst = new ArrayList();
arlst.Add("Workflow_Base");
arlst.Add(_Workflow_BaseEntity.FlowTypeID);
arlst.Add("");
return sp_ReDisplayOrder(arlst);
}
/// <summary>
/// 保存工作流
/// </summary>
/// <param name="nwf"></param>
/// <param name="operationState"></param>
/// <returns></returns>
private int SaveData(Workflow_BaseEntity _Workflow_BaseEntity, string operationState)
{
string sResult = "-1";
if (operationState == "Add")
sResult = DbHelper.GetInstance().AddWorkflow_Base(_Workflow_BaseEntity);
else if (operationState == "Update")
sResult = DbHelper.GetInstance().UpdateWorkflow_Base(_Workflow_BaseEntity);
int wfid = _Workflow_BaseEntity.WorkflowID;
return wfid;
}
