/// <summary> /// 获得数据列表 /// </summary> public List <System.Model.t_users_pj> DataTableToList(DataTable dt) { List <System.Model.t_users_pj> modelList = new List <System.Model.t_users_pj>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { System.Model.t_users_pj model; for (int n = 0; n < rowsCount; n++) { model = new System.Model.t_users_pj(); if (dt.Rows[n]["id"].ToString() != "") { model.id = int.Parse(dt.Rows[n]["id"].ToString()); } model.customId = dt.Rows[n]["customId"].ToString(); model.usersId = dt.Rows[n]["usersId"].ToString(); model.xj = dt.Rows[n]["xj"].ToString(); model.pudate = dt.Rows[n]["pudate"].ToString(); model.orderId = dt.Rows[n]["orderId"].ToString(); model.fwtd = dt.Rows[n]["fwtd"].ToString(); model.wlsd = dt.Rows[n]["wlsd"].ToString(); model.texts = dt.Rows[n]["texts"].ToString(); if (dt.Rows[n]["evaluate"].ToString() != "") { model.evaluate = int.Parse(dt.Rows[n]["evaluate"].ToString()); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(System.Model.t_users_pj model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update t_users_pj set "); strSql.Append(" customId = @customId , "); strSql.Append(" usersId = @usersId , "); strSql.Append(" xj = @xj , "); strSql.Append(" pudate = @pudate , "); strSql.Append(" orderId = @orderId , "); strSql.Append(" fwtd = @fwtd , "); strSql.Append(" wlsd = @wlsd , "); strSql.Append(" texts = @texts , "); strSql.Append(" evaluate = @evaluate "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4), new SqlParameter("@customId", SqlDbType.NVarChar, 50), new SqlParameter("@usersId", SqlDbType.NVarChar, 50), new SqlParameter("@xj", SqlDbType.NVarChar, 50), new SqlParameter("@pudate", SqlDbType.NVarChar, 50), new SqlParameter("@orderId", SqlDbType.NVarChar, 50), new SqlParameter("@fwtd", SqlDbType.NVarChar, 50), new SqlParameter("@wlsd", SqlDbType.NVarChar, 50), new SqlParameter("@texts", SqlDbType.Text), new SqlParameter("@evaluate", SqlDbType.Int, 4) }; parameters[0].Value = model.id; parameters[1].Value = model.customId; parameters[2].Value = model.usersId; parameters[3].Value = model.xj; parameters[4].Value = model.pudate; parameters[5].Value = model.orderId; parameters[6].Value = model.fwtd; parameters[7].Value = model.wlsd; parameters[8].Value = model.texts; parameters[9].Value = model.evaluate; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(System.Model.t_users_pj model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into t_users_pj("); strSql.Append("customId,usersId,xj,pudate,orderId,fwtd,wlsd,texts,evaluate"); strSql.Append(") values ("); strSql.Append("@customId,@usersId,@xj,@pudate,@orderId,@fwtd,@wlsd,@texts,@evaluate"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@customId", SqlDbType.NVarChar, 50), new SqlParameter("@usersId", SqlDbType.NVarChar, 50), new SqlParameter("@xj", SqlDbType.NVarChar, 50), new SqlParameter("@pudate", SqlDbType.NVarChar, 50), new SqlParameter("@orderId", SqlDbType.NVarChar, 50), new SqlParameter("@fwtd", SqlDbType.NVarChar, 50), new SqlParameter("@wlsd", SqlDbType.NVarChar, 50), new SqlParameter("@texts", SqlDbType.Text), new SqlParameter("@evaluate", SqlDbType.Int, 4) }; parameters[0].Value = model.customId; parameters[1].Value = model.usersId; parameters[2].Value = model.xj; parameters[3].Value = model.pudate; parameters[4].Value = model.orderId; parameters[5].Value = model.fwtd; parameters[6].Value = model.wlsd; parameters[7].Value = model.texts; parameters[8].Value = model.evaluate; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public System.Model.t_users_pj GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id, customId, usersId, xj, pudate, orderId, fwtd, wlsd, texts, evaluate "); strSql.Append(" from t_users_pj "); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; System.Model.t_users_pj model = new System.Model.t_users_pj(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } model.customId = ds.Tables[0].Rows[0]["customId"].ToString(); model.usersId = ds.Tables[0].Rows[0]["usersId"].ToString(); model.xj = ds.Tables[0].Rows[0]["xj"].ToString(); model.pudate = ds.Tables[0].Rows[0]["pudate"].ToString(); model.orderId = ds.Tables[0].Rows[0]["orderId"].ToString(); model.fwtd = ds.Tables[0].Rows[0]["fwtd"].ToString(); model.wlsd = ds.Tables[0].Rows[0]["wlsd"].ToString(); model.texts = ds.Tables[0].Rows[0]["texts"].ToString(); if (ds.Tables[0].Rows[0]["evaluate"].ToString() != "") { model.evaluate = int.Parse(ds.Tables[0].Rows[0]["evaluate"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(System.Model.t_users_pj model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(System.Model.t_users_pj model) { return(dal.Add(model)); }