/// <summary> /// 更新一条数据 /// </summary> public void Update(GZS.Model.Menu.SysGroupTab model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SysGroupTab set "); strSql.Append("SRoleID=@RoleID,"); strSql.Append("SName=@SName,"); strSql.Append("SysCheck=@SysCheck,"); strSql.Append("SysDate=@SysDate,"); strSql.Append("EmployeeID=@EmployeeID,"); strSql.Append("sdescribe=@sdescribe"); strSql.Append(" where SGID=@SID "); SqlParameter[] parameters = { new SqlParameter("@SID", SqlDbType.Int, 4), new SqlParameter("@RoleID", SqlDbType.VarChar, 50), new SqlParameter("@SName", SqlDbType.VarChar, 100), new SqlParameter("@SysCheck", SqlDbType.Int, 4), new SqlParameter("@SysDate", SqlDbType.DateTime), new SqlParameter("@EmployeeID", SqlDbType.VarChar, 100), new SqlParameter("@sdescribe", SqlDbType.VarChar, 100) }; parameters[0].Value = model.SGID; parameters[1].Value = model.SRoleID; parameters[2].Value = model.SName; parameters[3].Value = model.SysCheck; parameters[4].Value = model.SysDate; parameters[5].Value = model.EmployeeID; parameters[6].Value = model.SDescribe; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(GZS.Model.Menu.SysGroupTab model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SysGroupTab("); strSql.Append("SRoleID,SName,SysCheck,SysDate,EmployeeID,SDescribe)"); strSql.Append(" values ("); strSql.Append("@RoleID,@SName,@SysCheck,@SysDate,@EmployeeID,@SDescribe)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@RoleID", SqlDbType.VarChar, 50), new SqlParameter("@SName", SqlDbType.VarChar, 100), new SqlParameter("@SysCheck", SqlDbType.Int, 4), new SqlParameter("@SysDate", SqlDbType.DateTime), new SqlParameter("@EmployeeID", SqlDbType.VarChar, 100), new SqlParameter("@sdescribe", SqlDbType.VarChar, 100) }; parameters[0].Value = model.SRoleID; parameters[1].Value = model.SName; parameters[2].Value = model.SysCheck; parameters[3].Value = model.SysDate; parameters[4].Value = model.EmployeeID; parameters[5].Value = model.SDescribe; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 获得数据列表 /// </summary> public List <GZS.Model.Menu.SysGroupTab> DataTableToList(DataTable dt) { List <GZS.Model.Menu.SysGroupTab> modelList = new List <GZS.Model.Menu.SysGroupTab>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { GZS.Model.Menu.SysGroupTab model; for (int n = 0; n < rowsCount; n++) { model = new GZS.Model.Menu.SysGroupTab(); if (dt.Rows[n]["SGID"].ToString() != "") { model.SID = int.Parse(dt.Rows[n]["SGID"].ToString()); } if (dt.Rows[n]["SRoleID"].ToString() != "") { model.SRoleID = dt.Rows[n]["SRoleID"].ToString(); } model.SName = dt.Rows[n]["SName"].ToString(); if (dt.Rows[n]["SysCheck"].ToString() != "") { model.SysCheck = int.Parse(dt.Rows[n]["SysCheck"].ToString()); } if (dt.Rows[n]["SysDate"].ToString() != "") { model.SysDate = DateTime.Parse(dt.Rows[n]["SysDate"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 得到一个对象实体 /// </summary> public GZS.Model.Menu.SysGroupTab GetModel(int SGID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SGID,SRoleID,EmployeeID,SName,Sdescribe,SysCheck,SysDate from SysGroupTab "); strSql.Append(" where SGID=@SID "); SqlParameter[] parameters = { new SqlParameter("@SID", SqlDbType.Int, 4) }; parameters[0].Value = SGID; GZS.Model.Menu.SysGroupTab model = new GZS.Model.Menu.SysGroupTab(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["SGID"].ToString() != "") { model.SID = int.Parse(ds.Tables[0].Rows[0]["SGID"].ToString()); } if (ds.Tables[0].Rows[0]["SRoleID"].ToString() != "") { model.SRoleID = ds.Tables[0].Rows[0]["SRoleID"].ToString(); } model.SName = ds.Tables[0].Rows[0]["SName"].ToString(); if (ds.Tables[0].Rows[0]["SysCheck"].ToString() != "") { model.SysCheck = int.Parse(ds.Tables[0].Rows[0]["SysCheck"].ToString()); } if (ds.Tables[0].Rows[0]["SysDate"].ToString() != "") { model.SysDate = DateTime.Parse(ds.Tables[0].Rows[0]["SysDate"].ToString()); } if (ds.Tables[0].Rows[0]["SDescribe"].ToString() != "") { model.SDescribe = ds.Tables[0].Rows[0]["SDescribe"].ToString(); } if (ds.Tables[0].Rows[0]["EmployeeID"].ToString() != "") { model.EmployeeID = ds.Tables[0].Rows[0]["EmployeeID"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(GZS.Model.Menu.SysGroupTab model) { dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(GZS.Model.Menu.SysGroupTab model) { return(dal.Add(model)); }