private Workflow_ReportTypeEntity GetWorkflow_ReportTypeFromIDataReader(DbDataReader dr)
{
Workflow_ReportTypeEntity dt = new Workflow_ReportTypeEntity();
if (dr.FieldCount > 0)
{
if (dr["ReportTypeID"].ToString() != "" || dr["ReportTypeID"] != null) dt.ReportTypeID = Int32.Parse(dr["ReportTypeID"].ToString());
dt.ReportTypeName = dr["ReportTypeName"].ToString();
dt.ReportTypeDesc = dr["ReportTypeDesc"].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_ReportTypeEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddWorkflow_ReportType(Workflow_ReportTypeEntity _Workflow_ReportTypeEntity)
{
//判断该记录是否已经存在
DbParameter[] prams = { MakeInParam("@ReportTypeName",(DbType)SqlDbType.VarChar,200,_Workflow_ReportTypeEntity.ReportTypeName),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_ReportTypeEntity.DisplayOrder )
};
string sql = " select * from Workflow_ReportType where ReportTypeName=@ReportTypeName or DisplayOrder=@DisplayOrder";
if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0)
{
return "-1";//该记录已经存在
}
else
{
DbParameter[] pramsInsert = {
// MakeInParam("@ReportTypeID",(DbType)SqlDbType.Int,4,_Workflow_ReportTypeEntity.ReportTypeID ),
MakeInParam("@ReportTypeName",(DbType)SqlDbType.VarChar,200,_Workflow_ReportTypeEntity.ReportTypeName ),
MakeInParam("@ReportTypeDesc",(DbType)SqlDbType.VarChar,200,_Workflow_ReportTypeEntity.ReportTypeDesc ),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_ReportTypeEntity.DisplayOrder )
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_ReportType]");
sb.Append("(");
sb.Append("[ReportTypeName]");
sb.Append(",[ReportTypeDesc]");
sb.Append(",[DisplayOrder]");
sb.Append(") ");
sb.Append(" VALUES (");
sb.Append("@ReportTypeName,");
sb.Append("@ReportTypeDesc,");
sb.Append("@DisplayOrder");
sb.Append(" );");
sb.Append("select @@identity;");
return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
}
}
/// <summary>
/// 修改信息
/// </summary>
/// <param name="_Workflow_ReportTypeEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string UpdateWorkflow_ReportType(Workflow_ReportTypeEntity _Workflow_ReportTypeEntity)
{
DbParameter[] pramsUpdate = {
MakeInParam("@ReportTypeID",(DbType)SqlDbType.Int,4,_Workflow_ReportTypeEntity.ReportTypeID ),
MakeInParam("@ReportTypeName",(DbType)SqlDbType.VarChar,200,_Workflow_ReportTypeEntity.ReportTypeName ),
MakeInParam("@ReportTypeDesc",(DbType)SqlDbType.VarChar,200,_Workflow_ReportTypeEntity.ReportTypeDesc ),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_ReportTypeEntity.DisplayOrder )
};
StringBuilder sb = new StringBuilder();
sb.Append("Update [dbo].[Workflow_ReportType]");
sb.Append(" set ");
sb.Append(" [ReportTypeName]=@ReportTypeName,");
sb.Append(" [ReportTypeDesc]=@ReportTypeDesc,");
sb.Append(" [DisplayOrder]=@DisplayOrder");
sb.Append(" where ");
sb.Append(" [ReportTypeID]=@ReportTypeID");
return ExecuteNonQuery(CommandType.Text, sb.ToString(), pramsUpdate).ToString();
}
private string SaveData()
{
Workflow_ReportTypeEntity _Workflow_TypeEntity = new Workflow_ReportTypeEntity();
_Workflow_TypeEntity.ReportTypeID = Convert.ToInt32(txtTypeID.Value != string.Empty ? txtTypeID.Value : "0");
_Workflow_TypeEntity.ReportTypeName = txtTypeName.Text;
_Workflow_TypeEntity.ReportTypeDesc = txtTypeDesc.Text;
_Workflow_TypeEntity.DisplayOrder = Convert.ToInt32(txtDisplayOrder.Text != string.Empty ? txtDisplayOrder.Text : "99990");
/* _Workflow_TypeEntity.Useflag = chkUseFlag.Checked ? "1" : "0";
_Workflow_TypeEntity.Creator = userEntity.UserID;
_Workflow_TypeEntity.CreateDate = DateTime.Now;
_Workflow_TypeEntity.lastModifier = userEntity.UserID;
_Workflow_TypeEntity.lastModifyDate = DateTime.Now;*/
string sResult = "-1";
if (strOperationState == "Add")
sResult = DbHelper.GetInstance().AddWorkflow_ReportType(_Workflow_TypeEntity);
else if (strOperationState == "Update")
sResult = DbHelper.GetInstance().UpdateWorkflow_ReportType(_Workflow_TypeEntity);
return sResult;
}
