// Workflow_FormBaseEntity
public string FormBaseToJson(int formID)
{
string item = FieldToHtml(formID);
DataTable dtFormBase = DbHelper.GetInstance().GetDBRecords("*", "Workflow_FormBase", "FormID='" + formID + "'", "FormID");
foreach (DataRow dr in dtFormBase.Rows)
{
Workflow_FormBaseEntity wfb = new Workflow_FormBaseEntity();
wfb.FormID = Convert.ToInt32(dr["FormID"]);
wfb.FormName = dr["FormName"].ToString();
wfb.FormDesc = dr["FormDesc"].ToString();
wfb.FormTypeID =Convert.ToInt32(dr["FormTypeID"]);
wfb.DisplayOrder = Convert.ToInt32(dr["DisplayOrder"]);
wfb.Useflag = dr["Useflag"].ToString();
bool useflag = false ;
if (wfb.Useflag == "1")
{
useflag = true;
}
string html= "<form formid=\""+wfb.FormID
+"\" displayorder=\""+wfb.DisplayOrder
+"\" formdesc=\""+wfb.FormDesc
+"\" formtypeid=\""+wfb.FormTypeID
+"\" name=\""+wfb.FormName
+"\" useflag=\""+useflag+"\">"+item+"</form>";
return html;
}
return "";
}
protected void hideModalPopupViaServer_Click(object sender, EventArgs e)
{
GPRP.GPRPControls.Button btn = (GPRP.GPRPControls.Button)sender;
if (btn.ID == "btnSubmit")
{
Workflow_FormBaseEntity _FormBaseEntity = new Workflow_FormBaseEntity();
_FormBaseEntity.FormID = Convert.ToInt32(txtFormID.Value != string.Empty ? txtFormID.Value : "0");
_FormBaseEntity.FormName = txtFormName.Text;
_FormBaseEntity.FormDesc = txtFormDesc.Text;
_FormBaseEntity.FormTypeID = Convert.ToInt32(ddlFormTypeID.SelectedValue);
_FormBaseEntity.DisplayOrder = Convert.ToInt32(txtDisplayOrder.Text);
_FormBaseEntity.Useflag = chkUseFlag.Checked ? "1" : "0";
_FormBaseEntity.Creator = userEntity.UserID;
_FormBaseEntity.CreateDate = DateTime.Now;
_FormBaseEntity.lastModifier = userEntity.UserID;
_FormBaseEntity.lastModifyDate = DateTime.Now;
string sResult = DbHelper.GetInstance().UpdateWorkflow_FormBase(_FormBaseEntity);
if (sResult != "1")
{
lblMsg.Text = ResourceManager.GetString("Operation_RECORD") + ":" + sResult;
}
}
System.Web.UI.ScriptManager.RegisterStartupScript(btn, this.GetType(), "ButtonHideScript", strButtonHideScript, false);
}
/// <summary>
/// 新增信息
/// </summary>
/// <param name="_Workflow_FormBaseEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddWorkflow_FormBase2(Workflow_FormBaseEntity _Workflow_FormBaseEntity)
{
//判断该记录是否已经存在
DbParameter[] prams = {
MakeInParam("@FormName",(DbType)SqlDbType.VarChar,50,_Workflow_FormBaseEntity.FormName),
MakeInParam("@FormTypeID",(DbType)SqlDbType.Int,4,_Workflow_FormBaseEntity.FormTypeID ),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_FormBaseEntity.DisplayOrder ),
};
string sql = "select * from [dbo].[Workflow_FormBase] where FormName=@FormName or (FormTypeID=@FormTypeID and DisplayOrder=@DisplayOrder)";
if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0)
{
return "-1";//该记录已经存在
}
else
{
DbParameter[] pramsInsert = {
MakeInParam("@FormName",(DbType)SqlDbType.VarChar,200,_Workflow_FormBaseEntity.FormName ),
MakeInParam("@FormDesc",(DbType)SqlDbType.VarChar,2000,_Workflow_FormBaseEntity.FormDesc ),
MakeInParam("@FormTypeID",(DbType)SqlDbType.Int,4,_Workflow_FormBaseEntity.FormTypeID ),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_FormBaseEntity.DisplayOrder ),
MakeInParam("@Useflag",(DbType)SqlDbType.VarChar,50,_Workflow_FormBaseEntity.Useflag ),
MakeInParam("@Creator",(DbType)SqlDbType.VarChar,50,_Workflow_FormBaseEntity.Creator ),
MakeInParam("@CreateDate",(DbType)SqlDbType.DateTime,23,_Workflow_FormBaseEntity.CreateDate ),
MakeInParam("@lastModifier",(DbType)SqlDbType.VarChar,50,_Workflow_FormBaseEntity.lastModifier ),
MakeInParam("@lastModifyDate",(DbType)SqlDbType.DateTime,23,_Workflow_FormBaseEntity.lastModifyDate ),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_FormBase]");
sb.Append("(");
sb.Append(" [FormName]");
sb.Append(",[FormDesc]");
sb.Append(",[FormTypeID]");
sb.Append(",[DisplayOrder]");
sb.Append(",[Useflag]");
sb.Append(",[Creator]");
sb.Append(",[CreateDate]");
sb.Append(",[lastModifier]");
sb.Append(",[lastModifyDate]");
sb.Append(") ");
sb.Append(" VALUES (");
sb.Append("@FormName,");
sb.Append("@FormDesc,");
sb.Append("@FormTypeID,");
sb.Append("@DisplayOrder,");
sb.Append("@Useflag,");
sb.Append("@Creator,");
sb.Append("@CreateDate,");
sb.Append("@lastModifier,");
sb.Append("@lastModifyDate )");
sb.Append("select @@identity;");
// ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert);
string FormID = ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
_Workflow_FormBaseEntity.FormID = Convert.ToInt32(FormID);
ArrayList arlst = new ArrayList();
arlst.Add("Workflow_FormBase");
arlst.Add(_Workflow_FormBaseEntity.FormTypeID);
arlst.Add("");
return sp_ReDisplayOrder(arlst);
}
}
/// <summary>
/// GetWorkflow_FormBaseFromIDataReader
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private Workflow_FormBaseEntity GetWorkflow_FormBaseFromIDataReader(DbDataReader dr)
{
Workflow_FormBaseEntity dt = new Workflow_FormBaseEntity();
if (dr.FieldCount > 0)
{
if (dr["FormID"].ToString() != "" || dr["FormID"] != null) dt.FormID = Int32.Parse(dr["FormID"].ToString());
dt.FormName = dr["FormName"].ToString();
dt.FormDesc = dr["FormDesc"].ToString();
if (dr["FormTypeID"].ToString() != "" || dr["FormTypeID"] != null) dt.FormTypeID = Int32.Parse(dr["FormTypeID"].ToString());
if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString());
dt.Useflag = dr["Useflag"].ToString();
dt.Creator = dr["Creator"].ToString();
dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]);
dt.lastModifier = dr["lastModifier"].ToString();
dt.lastModifyDate = Convert.ToDateTime(dr["lastModifyDate"]);
dr.Close();
return dt;
}
dr.Close();
return null;
}
/// <summary>
/// 修改信息
/// </summary>
/// <param name="_Workflow_FormBaseEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string UpdateWorkflow_FormBase(Workflow_FormBaseEntity _Workflow_FormBaseEntity)
{
//判断该记录是否已经存在
DbParameter[] prams = {
MakeInParam("@FormID",(DbType)SqlDbType.Int,4,_Workflow_FormBaseEntity.FormID ),
MakeInParam("@FormName",(DbType)SqlDbType.VarChar,50,_Workflow_FormBaseEntity.FormName),
MakeInParam("@FormTypeID",(DbType)SqlDbType.Int,4,_Workflow_FormBaseEntity.FormTypeID ),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_FormBaseEntity.DisplayOrder ),
};
string sql = "select * from [dbo].[Workflow_FormBase] where FormID<>@FormID and ( FormName=@FormName or (FormTypeID=@FormTypeID and DisplayOrder=@DisplayOrder))";
if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0)
{
return "-1";//该记录已经存在
}
Workflow_FormBaseEntity _OriginalWorkflow_FormBaseEntity = GetWorkflow_FormBaseEntityByKeyCol(_Workflow_FormBaseEntity.FormID.ToString());
DbParameter[] pramsUpdate = {
MakeInParam("@FormID",(DbType)SqlDbType.Int,4,_Workflow_FormBaseEntity.FormID ),
MakeInParam("@FormName",(DbType)SqlDbType.VarChar,200,_Workflow_FormBaseEntity.FormName ),
MakeInParam("@FormDesc",(DbType)SqlDbType.VarChar,2000,_Workflow_FormBaseEntity.FormDesc ),
MakeInParam("@FormTypeID",(DbType)SqlDbType.Int,4,_Workflow_FormBaseEntity.FormTypeID ),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_FormBaseEntity.DisplayOrder ),
MakeInParam("@Useflag",(DbType)SqlDbType.VarChar,50,_Workflow_FormBaseEntity.Useflag ),
MakeInParam("@Creator",(DbType)SqlDbType.VarChar,50,_Workflow_FormBaseEntity.Creator ),
MakeInParam("@CreateDate",(DbType)SqlDbType.DateTime,23,_Workflow_FormBaseEntity.CreateDate ),
MakeInParam("@lastModifier",(DbType)SqlDbType.VarChar,50,_Workflow_FormBaseEntity.lastModifier ),
MakeInParam("@lastModifyDate",(DbType)SqlDbType.DateTime,23,_Workflow_FormBaseEntity.lastModifyDate ),
};
StringBuilder sb = new StringBuilder();
sb.Append("Update [dbo].[Workflow_FormBase]");
sb.Append(" set ");
sb.Append(" [FormName]=@FormName,");
sb.Append(" [FormDesc]=@FormDesc,");
sb.Append(" [FormTypeID]=@FormTypeID,");
sb.Append(" [DisplayOrder]=@DisplayOrder,");
sb.Append(" [Useflag]=@Useflag,");
sb.Append(" [Creator]=@Creator,");
sb.Append(" [CreateDate]=@CreateDate,");
sb.Append(" [lastModifier]=@lastModifier,");
sb.Append(" [lastModifyDate]=@lastModifyDate ");
sb.Append(" where [FormID]=@FormID ");
ExecuteNonQuery(CommandType.Text, sb.ToString(), pramsUpdate);
ArrayList arlst = new ArrayList();
arlst.Add("Workflow_FormBase");
arlst.Add(_OriginalWorkflow_FormBaseEntity.FormTypeID);
arlst.Add(_Workflow_FormBaseEntity.FormTypeID);
return sp_ReDisplayOrder(arlst);
}
private string SaveData()
{
Workflow_FormBaseEntity _FormBaseEntity = new Workflow_FormBaseEntity();
_FormBaseEntity.FormID = Convert.ToInt32(txtFormID.Value != string.Empty ? txtFormID.Value : "0");
_FormBaseEntity.FormName = txtFormName.Text;
_FormBaseEntity.FormDesc = txtFormDesc.Text;
_FormBaseEntity.FormTypeID = Convert.ToInt32(ddlFormTypeID.SelectedValue);
_FormBaseEntity.DisplayOrder = Convert.ToInt32(txtDisplayOrder.Text);
_FormBaseEntity.Useflag = chkUseFlag.Checked ? "1" : "0";
_FormBaseEntity.Creator = userEntity.UserID;
_FormBaseEntity.CreateDate = DateTime.Now;
_FormBaseEntity.lastModifier = userEntity.UserID;
_FormBaseEntity.lastModifyDate = DateTime.Now;
string sResult = "-1";
if (strOperationState == "Add")
sResult = DbHelper.GetInstance().AddWorkflow_FormBase(_FormBaseEntity);
else if (strOperationState == "Update")
sResult = DbHelper.GetInstance().UpdateWorkflow_FormBase(_FormBaseEntity);
return sResult;
}
/// <summary>
/// 增加表单
/// </summary>
/// <param name="form"></param>
/// <returns></returns>
private static List<int> addFormBase(XmlNodeList form)
{
DateTime dt = DateTime.Now;
List<int> result = new List<int>();
foreach (XmlNode fNode in form)
{
GPRP.Entity.Workflow_FormBaseEntity wfb = new GPRP.Entity.Workflow_FormBaseEntity();
XmlNode FormID = fNode.SelectSingleNode("FormID"); //判断是否
XmlNode FormName = fNode.SelectSingleNode("FormName");
XmlNode FormDesc = fNode.SelectSingleNode("FormDesc");
XmlNode FormTypeID = fNode.SelectSingleNode("FormTypeID");
XmlNode DisplayOrder = fNode.SelectSingleNode("DisplayOrder");
XmlNode Useflag = fNode.SelectSingleNode("Useflag");
wfb.FormID =(FormID.InnerText!=string.Empty?Convert.ToInt32(FormID.InnerText):0);
wfb.FormName = FormName.InnerText;
wfb.FormDesc = FormDesc.InnerText;
wfb.FormTypeID = Convert.ToInt32(FormTypeID.InnerText);
wfb.DisplayOrder = Convert.ToInt32(DisplayOrder.InnerText);
wfb.Useflag = Useflag.InnerText;
wfb.Creator = WebUtils.GetCookieUser(); //人员，实现上逻辑有问题！
wfb.CreateDate = dt;
wfb.lastModifier = WebUtils.GetCookieUser();
wfb.lastModifyDate = dt;
string r = "-1";
if (wfb.FormID != 0) //判断是否有FormId
{
r = DbHelper.GetInstance().UpdateWorkflow_FormBase(wfb); //更新
}
else
{
r = DbHelper.GetInstance().AddWorkflow_FormBase(wfb); //新增
}
if (r != "-1")
{
result.Add(wfb.FormID);
}
}
return result;
}
