/// <summary> /// 更新一条数据 /// </summary> public bool Update(TSGLXT.Model.GLB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update GLB set "); strSql.Append("ADYNAME=@ADYNAME,"); strSql.Append("ADSEX=@ADSEX,"); strSql.Append("SKID=@SKID,"); strSql.Append("ADPASSWORD=@ADPASSWORD"); strSql.Append(" where ADUSERNAME=@ADUSERNAME "); SqlParameter[] parameters = { new SqlParameter("@ADYNAME", SqlDbType.VarChar, 10), new SqlParameter("@ADSEX", SqlDbType.VarChar, 2), new SqlParameter("@SKID", SqlDbType.VarChar, 6), new SqlParameter("@ADPASSWORD", SqlDbType.VarChar, 10), new SqlParameter("@ADUSERNAME", SqlDbType.VarChar, 10) }; parameters[0].Value = model.ADYNAME; parameters[1].Value = model.ADSEX; parameters[2].Value = model.SKID; parameters[3].Value = model.ADPASSWORD; parameters[4].Value = model.ADUSERNAME; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TSGLXT.Model.GLB DataRowToModel(DataRow row) { TSGLXT.Model.GLB model = new TSGLXT.Model.GLB(); if (row != null) { if (row["ADYNAME"] != null) { model.ADYNAME = row["ADYNAME"].ToString(); } if (row["ADSEX"] != null) { model.ADSEX = row["ADSEX"].ToString(); } if (row["ADUSERNAME"] != null) { model.ADUSERNAME = row["ADUSERNAME"].ToString(); } if (row["SKID"] != null) { model.SKID = row["SKID"].ToString(); } if (row["ADPASSWORD"] != null) { model.ADPASSWORD = row["ADPASSWORD"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(TSGLXT.Model.GLB model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into GLB("); strSql.Append("ADYNAME,ADSEX,ADUSERNAME,SKID,ADPASSWORD)"); strSql.Append(" values ("); strSql.Append("@ADYNAME,@ADSEX,@ADUSERNAME,@SKID,@ADPASSWORD)"); SqlParameter[] parameters = { new SqlParameter("@ADYNAME", SqlDbType.VarChar, 10), new SqlParameter("@ADSEX", SqlDbType.VarChar, 2), new SqlParameter("@ADUSERNAME", SqlDbType.VarChar, 10), new SqlParameter("@SKID", SqlDbType.VarChar, 6), new SqlParameter("@ADPASSWORD", SqlDbType.VarChar, 10) }; parameters[0].Value = model.ADYNAME; parameters[1].Value = model.ADSEX; parameters[2].Value = model.ADUSERNAME; parameters[3].Value = model.SKID; parameters[4].Value = model.ADPASSWORD; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TSGLXT.Model.GLB GetModel(string ADUSERNAME) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ADYNAME,ADSEX,ADUSERNAME,SKID,ADPASSWORD from GLB "); strSql.Append(" where ADUSERNAME=@ADUSERNAME "); SqlParameter[] parameters = { new SqlParameter("@ADUSERNAME", SqlDbType.VarChar, 10) }; parameters[0].Value = ADUSERNAME; TSGLXT.Model.GLB model = new TSGLXT.Model.GLB(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }