/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Binning model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Binning set "); strSql.Append("BoxID=@BoxID,"); strSql.Append("BatchNO=@BatchNO,"); strSql.Append("OrderID=@OrderID,"); strSql.Append("ID_Key=@ID_Key"); strSql.Append(" where SackID=@SackID "); SqlParameter[] parameters = { new SqlParameter("@BoxID", SqlDbType.NChar, 10), new SqlParameter("@BatchNO", SqlDbType.NChar, 10), new SqlParameter("@OrderID", SqlDbType.NChar, 10), new SqlParameter("@ID_Key", SqlDbType.Decimal, 9), new SqlParameter("@SackID", SqlDbType.NChar, 10) }; parameters[0].Value = model.BoxID; parameters[1].Value = model.BatchNO; parameters[2].Value = model.OrderID; parameters[3].Value = model.ID_Key; parameters[4].Value = model.SackID; int rows = dbs.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.Binning model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Binning("); strSql.Append("SackID,BoxID,BatchNO,OrderID,ID_Key)"); strSql.Append(" values ("); strSql.Append("@SackID,@BoxID,@BatchNO,@OrderID,@ID_Key)"); SqlParameter[] parameters = { new SqlParameter("@SackID", SqlDbType.NChar, 10), new SqlParameter("@BoxID", SqlDbType.NChar, 10), new SqlParameter("@BatchNO", SqlDbType.NChar, 10), new SqlParameter("@OrderID", SqlDbType.NChar, 10), new SqlParameter("@ID_Key", SqlDbType.Decimal, 9) }; parameters[0].Value = model.SackID; parameters[1].Value = model.BoxID; parameters[2].Value = model.BatchNO; parameters[3].Value = model.OrderID; parameters[4].Value = model.ID_Key; int rows = dbs.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Binning DataRowToModel(DataRow row) { Maticsoft.Model.Binning model = new Maticsoft.Model.Binning(); if (row != null) { if (row["SackID"] != null) { model.SackID = row["SackID"].ToString(); } if (row["BoxID"] != null) { model.BoxID = row["BoxID"].ToString(); } if (row["BatchNO"] != null) { model.BatchNO = row["BatchNO"].ToString(); } if (row["OrderID"] != null) { model.OrderID = row["OrderID"].ToString(); } if (row["ID_Key"] != null && row["ID_Key"].ToString() != "") { model.ID_Key = decimal.Parse(row["ID_Key"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Binning GetModel(string SackID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SackID,BoxID,BatchNO,OrderID,ID_Key from tb_Binning "); strSql.Append(" where SackID=@SackID "); SqlParameter[] parameters = { new SqlParameter("@SackID", SqlDbType.NChar, 10) }; parameters[0].Value = SackID; Maticsoft.Model.Binning model = new Maticsoft.Model.Binning(); DataSet ds = dbs.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Binning model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.Binning model) { return(dal.Add(model)); }