public string GetNumByScodeAndOrcode(string scode) { OutStockModel modelByWhere = this.outStockBll.GetModelByWhere(string.Concat(new string[] { " where orcode='", this.txtPPCode.Text, "' and scode='", scode, "'" })); if (modelByWhere != null) { return(modelByWhere.number.ToString()); } return(string.Concat(0)); }
public OutStockModel GetModel(string orsid) { StringBuilder builder = new StringBuilder(); builder.Append("select orsid,orcode,scode,sprice,number,corp from Sm_out_Stock "); builder.Append(" where orsid=@orsid "); OutStockModel model = null; using (IDataReader reader = SqlHelper.ExecuteReader(CommandType.Text, builder.ToString(), new SqlParameter[] { new SqlParameter("@orsid", orsid) })) { if (reader.Read()) { model = this.ReaderBind(reader); } } return(model); }
private void smOutReserve(SqlTransaction trans) { OutReserveModel model = new OutReserveModel { annx = "", explain = "", flowstate = 1, intime = DateTime.Now, isout = true, orcode = DateTime.Now.ToString("yyyyMMddHHmmss"), orid = Guid.NewGuid().ToString() }; this.ReceiveNoteModel.soId = model.orid; model.person = this.UserName; model.procode = this.SendNoteMdoleInfo.prjCode.ToString(); model.tcode = this.TreasuryCode; model.PickingSector = this.getUserDepartmentName(this.sendNoteMdoleInfo.snAddUser); model.PickingPeople = this.UserName; model.IsOutTime = DateTime.Now; if (this.outReserveBll.Add(trans, model) != 0) { this.outStockBll.DeleteByWhere(trans, " where orcode='" + model.orcode + "'"); DataTable table = (DataTable)this.ViewState["DataTable"]; if (table != null) { foreach (DataRow row in table.Rows) { OutStockModel model2 = new OutStockModel { corp = row["suppyCode"].ToString(), number = Convert.ToDecimal(row["number"].ToString()), orcode = model.orcode, orsid = Guid.NewGuid().ToString(), scode = row["scode"].ToString(), sprice = Convert.ToDecimal(row["price"]), TaskId = string.Empty }; this.outStockBll.Add(trans, model2); } } } }
public OutStockModel ReaderBind(IDataReader dataReader) { OutStockModel model = new OutStockModel { orsid = dataReader["orsid"].ToString(), orcode = dataReader["orcode"].ToString(), scode = dataReader["scode"].ToString() }; object obj2 = dataReader["sprice"]; if ((obj2 != null) && (obj2 != DBNull.Value)) { model.sprice = (decimal)obj2; } obj2 = dataReader["number"]; if ((obj2 != null) && (obj2 != DBNull.Value)) { model.number = (decimal)obj2; } model.corp = dataReader["corp"].ToString(); return(model); }
public int Add(SqlTransaction trans, OutStockModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into Sm_out_Stock("); builder.Append("orsid,orcode,scode,sprice,number,corp,TaskId)"); builder.Append(" values ("); builder.Append("@orsid,@orcode,@scode,@sprice,@number,@corp,@TaskId)"); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@orsid", SqlDbType.NVarChar, 50), new SqlParameter("@orcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@sprice", SqlDbType.Decimal, 0x12), new SqlParameter("@number", SqlDbType.Decimal, 0x12), new SqlParameter("@corp", SqlDbType.NVarChar, 0x40), new SqlParameter("@TaskId", SqlDbType.NVarChar, 0x40) }; commandParameters[0].Value = model.orsid; commandParameters[1].Value = model.orcode; commandParameters[2].Value = model.scode; commandParameters[3].Value = model.sprice; commandParameters[4].Value = model.number; commandParameters[5].Value = model.corp; commandParameters[6].Value = model.TaskId; if (trans == null) { return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters)); } return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters)); }
public int Update(SqlTransaction trans, OutStockModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update Sm_out_Stock set "); builder.Append("orcode=@orcode,"); builder.Append("scode=@scode,"); builder.Append("sprice=@sprice,"); builder.Append("number=@number,"); builder.Append("corp=@corp"); builder.Append(" where orsid=@orsid "); SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@orsid", SqlDbType.NVarChar, 50), new SqlParameter("@orcode", SqlDbType.NVarChar, 0x40), new SqlParameter("@scode", SqlDbType.VarChar, 50), new SqlParameter("@sprice", SqlDbType.Decimal, 9), new SqlParameter("@number", SqlDbType.Decimal, 9), new SqlParameter("@corp", SqlDbType.NVarChar, 0x40) }; commandParameters[0].Value = model.orsid; commandParameters[1].Value = model.orcode; commandParameters[2].Value = model.scode; commandParameters[3].Value = model.sprice; commandParameters[4].Value = model.number; commandParameters[5].Value = model.corp; if (trans == null) { return(SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters)); } return(SqlHelper.ExecuteNonQuery(trans, CommandType.Text, builder.ToString(), commandParameters)); }
public int Update(SqlTransaction trans, OutStockModel model) { return(this.outStock.Update(trans, model)); }
public int Add(SqlTransaction trans, OutStockModel model) { return(this.outStock.Add(trans, model)); }