/// <summary>
/// 新增信息
/// </summary>
/// <param name="_SysGroupEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddSysGroup(SysGroupEntity _SysGroupEntity)
{
//判断该记录是否已经存在
DbParameter[] prams = { MakeInParam("@GroupName",(DbType)SqlDbType.VarChar,50,_SysGroupEntity.GroupName),
};
string sql = "select * from [dbo].[SysGroup] where GroupName=@GroupName ";
if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0)
{
return "-1";//该记录已经存在
}
else
{
DbParameter[] pramsInsert = {
MakeInParam("@GroupName",(DbType)SqlDbType.VarChar,50,_SysGroupEntity.GroupName ),
MakeInParam("@GroupDesc",(DbType)SqlDbType.VarChar,2000,_SysGroupEntity.GroupDesc ),
MakeInParam("@GroupType",(DbType)SqlDbType.Int,4,_SysGroupEntity.GroupType ),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_SysGroupEntity.DisplayOrder ),
MakeInParam("@UseFlag",(DbType)SqlDbType.VarChar,1,_SysGroupEntity.UseFlag ),
MakeInParam("@CreateUser",(DbType)SqlDbType.VarChar,50,_SysGroupEntity.CreateUser ),
MakeInParam("@CreateDate",(DbType)SqlDbType.DateTime,23,_SysGroupEntity.CreateDate ),
MakeInParam("@LastModifier",(DbType)SqlDbType.VarChar,50,_SysGroupEntity.LastModifier ),
MakeInParam("@LastModifyDate",(DbType)SqlDbType.DateTime,23,_SysGroupEntity.LastModifyDate ),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[SysGroup]");
sb.Append("(");
sb.Append(" [GroupName]");
sb.Append(",[GroupDesc]");
sb.Append(",[GroupType]");
sb.Append(",[DisplayOrder]");
sb.Append(",[UseFlag]");
sb.Append(",[CreateUser]");
sb.Append(",[CreateDate]");
sb.Append(",[LastModifier]");
sb.Append(",[LastModifyDate]");
sb.Append(") ");
sb.Append(" VALUES (");
sb.Append("@GroupName,");
sb.Append("@GroupDesc,");
sb.Append("@GroupType,");
sb.Append("@DisplayOrder,");
sb.Append("@UseFlag,");
sb.Append("@CreateUser,");
sb.Append("@CreateDate,");
sb.Append("@LastModifier,");
sb.Append("@LastModifyDate )");
sb.Append("select @@identity;");
string GroupID = ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
UpdateSysGroupUser(GroupID, _SysGroupEntity.dtUserList);
return "0";
}
}
private SysGroupEntity GetSysGroupFromIDataReader(DbDataReader dr)
{
SysGroupEntity dt = new SysGroupEntity();
if (dr.FieldCount > 0)
{
if (dr["GroupID"].ToString() != "" || dr["GroupID"] != null) dt.GroupID = Int32.Parse(dr["GroupID"].ToString());
dt.GroupName = dr["GroupName"].ToString();
dt.GroupDesc = dr["GroupDesc"].ToString();
if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString());
dt.UseFlag = dr["UseFlag"].ToString();
dt.CreateUser = dr["CreateUser"].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="_SysGroupEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string UpdateSysGroup(SysGroupEntity _SysGroupEntity)
{
DbParameter[] pramsUpdate = {
MakeInParam("@GroupID",(DbType)SqlDbType.Int,4,_SysGroupEntity.GroupID ),
MakeInParam("@GroupName",(DbType)SqlDbType.VarChar,50,_SysGroupEntity.GroupName ),
MakeInParam("@GroupDesc",(DbType)SqlDbType.VarChar,2000,_SysGroupEntity.GroupDesc ),
MakeInParam("@GroupType",(DbType)SqlDbType.Int,4,_SysGroupEntity.GroupType ),
MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_SysGroupEntity.DisplayOrder ),
MakeInParam("@UseFlag",(DbType)SqlDbType.Char,1,_SysGroupEntity.UseFlag ),
MakeInParam("@CreateUser",(DbType)SqlDbType.VarChar,50,_SysGroupEntity.CreateUser ),
MakeInParam("@CreateDate",(DbType)SqlDbType.DateTime,23,_SysGroupEntity.CreateDate ),
MakeInParam("@LastModifier",(DbType)SqlDbType.VarChar,50,_SysGroupEntity.LastModifier ),
MakeInParam("@LastModifyDate",(DbType)SqlDbType.DateTime,23,_SysGroupEntity.LastModifyDate ),
};
StringBuilder sb = new StringBuilder();
sb.Append("Update [dbo].[SysGroup]");
sb.Append(" set ");
sb.Append(" [GroupName]=@GroupName,");
sb.Append(" [GroupDesc]=@GroupDesc,");
sb.Append(" [GroupType]=@GroupType,");
sb.Append(" [DisplayOrder]=@DisplayOrder,");
sb.Append(" [UseFlag]=@UseFlag,");
sb.Append(" [LastModifier]=@LastModifier,");
sb.Append(" [LastModifyDate]=@LastModifyDate ");
sb.Append(" where [GroupID]=@GroupID ");
ExecuteScalar(CommandType.Text, sb.ToString(), pramsUpdate);
UpdateSysGroupUser(_SysGroupEntity.GroupID.ToString(), _SysGroupEntity.dtUserList);
return "0";
}
private string SaveData()
{
SysGroupEntity _SysGroupEntity = new SysGroupEntity();
_SysGroupEntity.GroupID = Convert.ToInt32(txtGroupID.Value != string.Empty ? txtGroupID.Value : "0");
_SysGroupEntity.GroupName = txtGroupName.Text;
_SysGroupEntity.GroupDesc = txtGroupDesc.Text;
_SysGroupEntity.GroupType = 1;
_SysGroupEntity.DisplayOrder = Convert.ToInt32(txtDisplayOrder.Text != string.Empty ? txtDisplayOrder.Text : "99990");
_SysGroupEntity.UseFlag = chkUseFlag.Checked ? "1" : "0";
_SysGroupEntity.CreateUser = userEntity.UserID;
_SysGroupEntity.CreateDate = DateTime.Now;
_SysGroupEntity.LastModifier = userEntity.UserID;
_SysGroupEntity.LastModifyDate = DateTime.Now;
_SysGroupEntity.dtUserList = (DataTable)ViewState["dtUserList"];
string sResult = "-1";
if (strOperationState == "Add")
sResult = DbHelper.GetInstance().AddSysGroup(_SysGroupEntity);
else if (strOperationState == "Update")
sResult = DbHelper.GetInstance().UpdateSysGroup(_SysGroupEntity);
ArrayList arl = new ArrayList();
arl.Add("SysGroup");
arl.Add("");
arl.Add("");
sResult = DbHelper.GetInstance().sp_ReDisplayOrder(arl);
return sResult;
}
