public int InsertItem(SRItemInfo oParam) { string sql = @"INSERT INTO SR_Item ( SRSysNo, ProductSysNo, Quantity ) VALUES ( @SRSysNo, @ProductSysNo, @Quantity );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSRSysNo = new SqlParameter("@SRSysNo", SqlDbType.Int, 4); SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4); SqlParameter paramQuantity = new SqlParameter("@Quantity", SqlDbType.Int, 4); paramSysNo.Direction = ParameterDirection.Output; if (oParam.SRSysNo != AppConst.IntNull) paramSRSysNo.Value = oParam.SRSysNo; else paramSRSysNo.Value = System.DBNull.Value; if (oParam.ProductSysNo != AppConst.IntNull) paramProductSysNo.Value = oParam.ProductSysNo; else paramProductSysNo.Value = System.DBNull.Value; if (oParam.Quantity != AppConst.IntNull) paramQuantity.Value = oParam.Quantity; else paramQuantity.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramSRSysNo); cmd.Parameters.Add(paramProductSysNo); cmd.Parameters.Add(paramQuantity); return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo); }
public int UpdateItem(SRItemInfo oParam) { string sql = @"UPDATE SR_Item SET SRSysNo=@SRSysNo, ProductSysNo=@ProductSysNo, Quantity=@Quantity WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSRSysNo = new SqlParameter("@SRSysNo", SqlDbType.Int, 4); SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4); SqlParameter paramQuantity = new SqlParameter("@Quantity", SqlDbType.Int, 4); if (oParam.SysNo != AppConst.IntNull) paramSysNo.Value = oParam.SysNo; else paramSysNo.Value = System.DBNull.Value; if (oParam.SRSysNo != AppConst.IntNull) paramSRSysNo.Value = oParam.SRSysNo; else paramSRSysNo.Value = System.DBNull.Value; if (oParam.ProductSysNo != AppConst.IntNull) paramProductSysNo.Value = oParam.ProductSysNo; else paramProductSysNo.Value = System.DBNull.Value; if (oParam.Quantity != AppConst.IntNull) paramQuantity.Value = oParam.Quantity; else paramQuantity.Value = System.DBNull.Value; cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramSRSysNo); cmd.Parameters.Add(paramProductSysNo); cmd.Parameters.Add(paramQuantity); return SqlHelper.ExecuteNonQuery(cmd); }
private void map(SRItemInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.SRSysNo = Util.TrimIntNull(tempdr["SRSysNo"]); oParam.ProductSysNo = Util.TrimIntNull(tempdr["ProductSysNo"]); oParam.Quantity = Util.TrimIntNull(tempdr["Quantity"]); }
private void InsertSRItem(SRItemInfo oParam, SRInfo srInfo) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { new SRDac().InsertItem(oParam); scope.Complete(); } }
public void UpdateSRItem(SRItemInfo oParam) { new SRDac().UpdateItem(oParam); }
public SRInfo Load(int sysno) { try { SRInfo oInfo = new SRInfo(); string sql = "select * from SR_Master (NOLOCK) where sysno=" + sysno; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { DataRow dr = ds.Tables[0].Rows[0]; map(oInfo, dr); string itemSql = @"select SR_Item.* from SR_Master (NOLOCK) inner join SR_Item (NOLOCK) on SR_Item.SRSysNo = SR_Master.SysNo where SR_Master.sysno=" + sysno; DataSet itemds = SqlHelper.ExecuteDataSet(itemSql); if (Util.HasMoreRow(itemds)) { foreach (DataRow itemdr in itemds.Tables[0].Rows) { SRItemInfo oSRItem = new SRItemInfo(); map(oSRItem, itemdr); oInfo.ItemHash.Add(Util.TrimIntNull(itemdr["SysNo"]), oSRItem); } } } return oInfo; } catch { throw new BizException("Load SRInfo Error!"); } }