/// <summary> /// 得到一个对象实体 /// </summary> public AsrsStorDBAcc.Model.StockDetailModel DataRowToModel(DataRow row) { AsrsStorDBAcc.Model.StockDetailModel model = new AsrsStorDBAcc.Model.StockDetailModel(); if (row != null) { if (row["StockDetailID"] != null && row["StockDetailID"].ToString() != "") { model.StockDetailID = long.Parse(row["StockDetailID"].ToString()); } if (row["StockListID"] != null && row["StockListID"].ToString() != "") { model.StockListID = long.Parse(row["StockListID"].ToString()); } if (row["MeterialName"] != null) { model.MeterialName = row["MeterialName"].ToString(); } if (row["MeterialCode"] != null) { model.MeterialCode = row["MeterialCode"].ToString(); } if (row["MeterialPos"] != null) { model.MeterialPos = row["MeterialPos"].ToString(); } if (row["Reserve"] != null) { model.Reserve = row["Reserve"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(AsrsStorDBAcc.Model.StockDetailModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into StockDetail("); strSql.Append("StockListID,MeterialName,MeterialCode,MeterialPos,Reserve)"); strSql.Append(" values ("); strSql.Append("@StockListID,@MeterialName,@MeterialCode,@MeterialPos,@Reserve)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@StockListID", SqlDbType.BigInt, 8), new SqlParameter("@MeterialName", SqlDbType.NVarChar, 50), new SqlParameter("@MeterialCode", SqlDbType.NVarChar, 50), new SqlParameter("@MeterialPos", SqlDbType.NVarChar, 50), new SqlParameter("@Reserve", SqlDbType.NVarChar, 200) }; parameters[0].Value = model.StockListID; parameters[1].Value = model.MeterialName; parameters[2].Value = model.MeterialCode; parameters[3].Value = model.MeterialPos; parameters[4].Value = model.Reserve; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(AsrsStorDBAcc.Model.StockDetailModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update StockDetail set "); strSql.Append("StockListID=@StockListID,"); strSql.Append("MeterialName=@MeterialName,"); strSql.Append("MeterialCode=@MeterialCode,"); strSql.Append("MeterialPos=@MeterialPos,"); strSql.Append("Reserve=@Reserve"); strSql.Append(" where StockDetailID=@StockDetailID"); SqlParameter[] parameters = { new SqlParameter("@StockListID", SqlDbType.BigInt, 8), new SqlParameter("@MeterialName", SqlDbType.NVarChar, 50), new SqlParameter("@MeterialCode", SqlDbType.NVarChar, 50), new SqlParameter("@MeterialPos", SqlDbType.NVarChar, 50), new SqlParameter("@Reserve", SqlDbType.NVarChar, 200), new SqlParameter("@StockDetailID", SqlDbType.BigInt, 8) }; parameters[0].Value = model.StockListID; parameters[1].Value = model.MeterialName; parameters[2].Value = model.MeterialCode; parameters[3].Value = model.MeterialPos; parameters[4].Value = model.Reserve; parameters[5].Value = model.StockDetailID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public AsrsStorDBAcc.Model.StockDetailModel GetModel(long StockDetailID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 StockDetailID,StockListID,MeterialName,MeterialCode,MeterialPos,Reserve from StockDetail "); strSql.Append(" where StockDetailID=@StockDetailID"); SqlParameter[] parameters = { new SqlParameter("@StockDetailID", SqlDbType.BigInt) }; parameters[0].Value = StockDetailID; AsrsStorDBAcc.Model.StockDetailModel model = new AsrsStorDBAcc.Model.StockDetailModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }