/// <summary> /// 更新一条数据 /// </summary> public bool Update(ERP.Model.Records model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Records set "); strSql.Append("RMCode=@RMCode,"); strSql.Append("RMName=@RMName,"); strSql.Append("RQuantity=@RQuantity,"); strSql.Append("RType=@RType,"); strSql.Append("RHander=@RHander,"); strSql.Append("RTime=@RTime"); strSql.Append(" where RID=@RID "); SqlParameter[] parameters = { new SqlParameter("@RMCode", SqlDbType.Int, 4), new SqlParameter("@RMName", SqlDbType.NVarChar, 50), new SqlParameter("@RQuantity", SqlDbType.Int, 4), new SqlParameter("@RType", SqlDbType.Int, 4), new SqlParameter("@RHander", SqlDbType.NVarChar, 50), new SqlParameter("@RTime", SqlDbType.DateTime), new SqlParameter("@RID", SqlDbType.Int, 4) }; parameters[0].Value = model.RMCode; parameters[1].Value = model.RMName; parameters[2].Value = model.RQuantity; parameters[3].Value = model.RType; parameters[4].Value = model.RHander; parameters[5].Value = model.RTime; parameters[6].Value = model.RID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(ERP.Model.Records model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Records("); strSql.Append("RMCode,RMName,RQuantity,RType,RHander,RTime)"); strSql.Append(" values ("); strSql.Append("@RMCode,@RMName,@RQuantity,@RType,@RHander,@RTime)"); SqlParameter[] parameters = { //new SqlParameter("@RID", SqlDbType.Int,4), new SqlParameter("@RMCode", SqlDbType.Int, 4), new SqlParameter("@RMName", SqlDbType.NVarChar, 50), new SqlParameter("@RQuantity", SqlDbType.Int, 4), new SqlParameter("@RType", SqlDbType.Int, 4), new SqlParameter("@RHander", SqlDbType.NVarChar, 50), new SqlParameter("@RTime", SqlDbType.DateTime) }; //parameters[0].Value = model.RID; parameters[0].Value = model.RMCode; parameters[1].Value = model.RMName; parameters[2].Value = model.RQuantity; parameters[3].Value = model.RType; parameters[4].Value = model.RHander; parameters[5].Value = model.RTime; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ERP.Model.Records DataRowToModel(DataRow row) { ERP.Model.Records model = new ERP.Model.Records(); if (row != null) { if (row["RID"] != null && row["RID"].ToString() != "") { model.RID = int.Parse(row["RID"].ToString()); } if (row["RMCode"] != null && row["RMCode"].ToString() != "") { model.RMCode = int.Parse(row["RMCode"].ToString()); } if (row["RMName"] != null) { model.RMName = row["RMName"].ToString(); } if (row["RQuantity"] != null && row["RQuantity"].ToString() != "") { model.RQuantity = int.Parse(row["RQuantity"].ToString()); } if (row["RType"] != null && row["RType"].ToString() != "") { model.RType = int.Parse(row["RType"].ToString()); } if (row["RHander"] != null) { model.RHander = row["RHander"].ToString(); } if (row["RTime"] != null && row["RTime"].ToString() != "") { model.RTime = DateTime.Parse(row["RTime"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public ERP.Model.Records GetModel(int RID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 RID,RMCode,RMName,RQuantity,RType,RHander,RTime from Records "); strSql.Append(" where RID=@RID "); SqlParameter[] parameters = { new SqlParameter("@RID", SqlDbType.Int, 4) }; parameters[0].Value = RID; ERP.Model.Records model = new ERP.Model.Records(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }