/// <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; }