private string SaveData()
{
Workflow_FormTypeEntity _Workflow_FormTypeEntity = new Workflow_FormTypeEntity();
_Workflow_FormTypeEntity.FormTypeID = Convert.ToInt32(txtFormTypeID.Value != string.Empty ? txtFormTypeID.Value : "0");
_Workflow_FormTypeEntity.FormTypeName = txtFormTypeName.Text;
_Workflow_FormTypeEntity.FormTypeDesc = txtFormTypeDesc.Text;
_Workflow_FormTypeEntity.DisplayOrder = Convert.ToInt32(txtDisplayOrder.Text != string.Empty ? txtDisplayOrder.Text : "99990");
_Workflow_FormTypeEntity.Useflag = chkUseFlag.Checked ? "1" : "0";
_Workflow_FormTypeEntity.Creator = userEntity.UserID;
_Workflow_FormTypeEntity.CreateDate = DateTime.Now;
_Workflow_FormTypeEntity.lastModifier = userEntity.UserID;
_Workflow_FormTypeEntity.lastModifyDate = DateTime.Now;
string sResult = "-1";
if (strOperationState == "Add")
sResult = DbHelper.GetInstance().AddWorkflow_FormType(_Workflow_FormTypeEntity);
else if (strOperationState == "Update")
sResult = DbHelper.GetInstance().UpdateWorkflow_FormType(_Workflow_FormTypeEntity);
return sResult;
}
private Workflow_FormTypeEntity GetWorkflow_FormTypeFromIDataReader(DbDataReader dr)
{
Workflow_FormTypeEntity dt = new Workflow_FormTypeEntity();
if (dr.FieldCount > 0)
{
if (dr["FormTypeID"].ToString() != "" || dr["FormTypeID"] != null) dt.FormTypeID = Int32.Parse(dr["FormTypeID"].ToString());
dt.FormTypeName = dr["FormTypeName"].ToString();
dt.FormTypeDesc = dr["FormTypeDesc"].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_FormTypeEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddWorkflow_FormType(Workflow_FormTypeEntity _Workflow_FormTypeEntity)
{
//判断该记录是否已经存在
DbParameter[] prams = {
MakeInParam("@FormTypeName",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.FormTypeName ),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_FormTypeEntity.DisplayOrder ),
};
string sql = " select * from [dbo].[Workflow_FormType] where FormTypeName=@FormTypeName or DisplayOrder=@DisplayOrder ";
if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0)
{
return "-1";//该记录已经存在
}
else
{
DbParameter[] pramsInsert = {
MakeInParam("@FormTypeName",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.FormTypeName ),
MakeInParam("@FormTypeDesc",(DbType)SqlDbType.VarChar,200,_Workflow_FormTypeEntity.FormTypeDesc ),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_FormTypeEntity.DisplayOrder ),
MakeInParam("@Useflag",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.Useflag ),
MakeInParam("@Creator",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.Creator ),
MakeInParam("@CreateDate",(DbType)SqlDbType.DateTime,16,_Workflow_FormTypeEntity.CreateDate ),
MakeInParam("@lastModifier",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.lastModifier ),
MakeInParam("@lastModifyDate",(DbType)SqlDbType.DateTime,16,_Workflow_FormTypeEntity.lastModifyDate ),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_FormType]");
sb.Append("(");
sb.Append(" [FormTypeName]");
sb.Append(",[FormTypeDesc]");
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("@FormTypeName,");
sb.Append("@FormTypeDesc,");
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).ToString();
ArrayList arlst = new ArrayList();
arlst.Add("Workflow_FormType");
arlst.Add("");
arlst.Add("");
return sp_ReDisplayOrder(arlst);
}
}
/// <summary>
/// 修改信息
/// </summary>
/// <param name="_Workflow_FormTypeEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string UpdateWorkflow_FormType(Workflow_FormTypeEntity _Workflow_FormTypeEntity)
{
DbParameter[] pramsUpdate = {
MakeInParam("@FormTypeID",(DbType)SqlDbType.Int,4,_Workflow_FormTypeEntity.FormTypeID ),
MakeInParam("@FormTypeName",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.FormTypeName ),
MakeInParam("@FormTypeDesc",(DbType)SqlDbType.VarChar,200,_Workflow_FormTypeEntity.FormTypeDesc ),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_FormTypeEntity.DisplayOrder ),
MakeInParam("@Useflag",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.Useflag ),
MakeInParam("@lastModifier",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.lastModifier ),
MakeInParam("@lastModifyDate",(DbType)SqlDbType.DateTime,23,_Workflow_FormTypeEntity.lastModifyDate ),
};
StringBuilder sb = new StringBuilder();
sb.Append("Update [dbo].[Workflow_FormType]");
sb.Append(" set ");
sb.Append(" [FormTypeName]=@FormTypeName,");
sb.Append(" [FormTypeDesc]=@FormTypeDesc,");
sb.Append(" [DisplayOrder]=@DisplayOrder,");
sb.Append(" [Useflag]=@Useflag,");
sb.Append(" [lastModifier]=@lastModifier,");
sb.Append(" [lastModifyDate]=@lastModifyDate ");
sb.Append(" where [FormTypeID]=@FormTypeID ");
sb.Append(" select @FormTypeID;");
ExecuteScalar(CommandType.Text, sb.ToString(), pramsUpdate).ToString();
ArrayList arlst = new ArrayList();
arlst.Add("Workflow_FormType");
arlst.Add("");
arlst.Add("");
return sp_ReDisplayOrder(arlst);
}
