public int AddNewGroupOfGoods(GroupOfGoodsInfo groupOfGoodsInfo) { string strSQL = "INSERT INTO GroupOfGoods VALUES(@GOGID, @GOGName, @Note)"; int nRow = 0; try { nRow = dB.ExecuteNonQuery(CommandType.Text, strSQL, new SqlParameter { ParameterName = "@GOGID", Value = groupOfGoodsInfo.GOGID }, new SqlParameter { ParameterName = "@GOGName", Value = groupOfGoodsInfo.GOGName }, new SqlParameter { ParameterName = "@Note", Value = groupOfGoodsInfo.Note } ); } catch (SqlException ex) { throw ex; } return(nRow); }
public GroupOfGoodsInfo LoadInfo(int id) { string sqlStr = string.Format("SELECT * FROM GroupOfGoods WHERE GOGID = {0}", id); DataTable dt = dB.getData(sqlStr); GroupOfGoodsInfo groupOfGoodsInfo = new GroupOfGoodsInfo { GOGID = int.Parse(dt.Rows[0]["GOGID"].ToString()), GOGName = dt.Rows[0]["GOGName"].ToString(), Note = dt.Rows[0]["Note"].ToString(), }; return(groupOfGoodsInfo); }
public int UpdateGroupOfGoods(GroupOfGoodsInfo groupOfGoodsInfo) { string strSQL = "UpdateGroupOfGoods"; int nRow = 0; nRow = dB.ExecuteNonQuery(CommandType.StoredProcedure, strSQL, new SqlParameter { ParameterName = "@GOGID", Value = groupOfGoodsInfo.GOGID }, new SqlParameter { ParameterName = "@GOGName", Value = groupOfGoodsInfo.GOGName }, new SqlParameter { ParameterName = "@Note", Value = groupOfGoodsInfo.Note } ); return(nRow); }
public int AddNewGroupOfGoods(GroupOfGoodsInfo groupOfGoodsInfo) { return(groupOfGoodsDAO.AddNewGroupOfGoods(groupOfGoodsInfo)); }
public int UpdateGroupOfGoods(GroupOfGoodsInfo groupOfGoodsInfo) { return(groupOfGoodsDAO.UpdateGroupOfGoods(groupOfGoodsInfo)); }