public static SysInfoModel GetSysInfoByType(int type, int lang) { string sql = "select * from T_SysInfo where F_InfoType=@InfoType And F_Lang=@Lang"; OleDbParameter[] parameter = new OleDbParameter[2]; parameter[0] = new OleDbParameter("@InfoType", OleDbType.Integer); parameter[1] = new OleDbParameter("@Lang", OleDbType.Integer); parameter[0].Value = type; parameter[1].Value = lang; OleDbDataReader dr = AccessorDB.ExecuteReader(sql, parameter); SysInfoModel f = new SysInfoModel(); if (dr.Read()) { f.ID = Convert.ToInt32(dr["ID"]); f.Content = dr["F_Content"].ToString(); f.InfoType = Convert.ToInt32(dr["F_InfoType"].ToString()); f.Lang = Convert.ToInt32(dr["F_Lang"].ToString()); f.Title = dr["F_InfoTitile"].ToString(); } dr.Close(); dr.Dispose(); return(f); }
public static int AddSysInfo(SysInfoModel f) { string sql = "insert into T_SysInfo(F_Content,F_InfoType,F_Lang,F_InfoTitle) values(@F_Content,@F_InfoType,@F_Lang,@F_Title)"; OleDbParameter[] parameter = new OleDbParameter[4]; parameter[0] = new OleDbParameter("@F_Content", OleDbType.VarChar); parameter[0].Value = f.Content; parameter[2] = new OleDbParameter("@F_InfoType", OleDbType.Integer); parameter[2].Value = f.InfoType; parameter[3] = new OleDbParameter("@F_Lang", OleDbType.Integer); parameter[3].Value = f.Lang; parameter[4] = new OleDbParameter("@F_Title", OleDbType.VarChar); parameter[4].Value = f.Title; return(AccessorDB.ExecuteNonQuery(sql, parameter)); }
public static int UpdateSysInfoByID(SysInfoModel f) { string sql = "update T_SysInfo set F_Content=@F_Content,F_InfoType=@F_InfoType,F_Lang=@F_Lang,F_InfoTitle=@F_Title where ID=@ID"; OleDbParameter[] parameter = new OleDbParameter[5]; parameter[0] = new OleDbParameter("@F_Content", OleDbType.VarChar); parameter[0].Value = f.Content; parameter[1] = new OleDbParameter("@ID", OleDbType.Integer); parameter[1].Value = f.ID; parameter[2] = new OleDbParameter("@F_InfoType", OleDbType.Integer); parameter[2].Value = f.InfoType; parameter[3] = new OleDbParameter("@F_Lang", OleDbType.Integer); parameter[3].Value = f.Lang; parameter[4] = new OleDbParameter("@F_Title", OleDbType.VarChar); parameter[4].Value = f.Title; return(AccessorDB.ExecuteNonQuery(sql, parameter)); }
public static SysInfoResult UpdateSysInfoByID(SysInfoModel f) { SysInfoResult result = new SysInfoResult(); if (!VerifyTool.IsLong(f.ID.ToString())) { result.HasError = true; result.ErrorMessage = "参数错误。"; return(result); } if (EispSysInfoDAL.UpdateSysInfoByID(f) > 0) { result.HasError = false; return(result); } else { result.HasError = true; result.ErrorMessage = "数据库错误,请联系管理员。"; return(result); } }