public void GenerateProductIDsByPO(POInfo PO) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { if (PO != null) { AbandonProductIDsByPO(PO.SysNo); foreach (POItemInfo item in PO.itemHash.Values) { for (int i = 1; i <= item.Quantity; i++) { ProductIDInfo pidInfo = new ProductIDInfo(); pidInfo.ProductSysNo = item.ProductSysNo; pidInfo.POSysNo = PO.SysNo; pidInfo.OrderNum = i; pidInfo.Status = (int)AppEnum.BiStatus.Valid; this.Insert(pidInfo); } } } scope.Complete(); } }
private void map(ProductIDInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.ProductSysNo = Util.TrimIntNull(tempdr["ProductSysNo"]); oParam.POSysNo = Util.TrimIntNull(tempdr["POSysNo"]); oParam.OrderNum = Util.TrimIntNull(tempdr["OrderNum"]); oParam.Status = Util.TrimIntNull(tempdr["Status"]); oParam.ProductSN = Util.TrimNull(tempdr["ProductSN"]); oParam.ProductTrackSN = Util.TrimNull(tempdr["ProductTrackSN"]); oParam.Note = Util.TrimNull(tempdr["Note"]); }
public ProductIDInfo Load(int SysNo) { string sql = "select * from product_id where sysno=" + SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { ProductIDInfo oInfo = new ProductIDInfo(); map(oInfo, ds.Tables[0].Rows[0]); return(oInfo); } else { return(null); } }
public void ProductIDSNImportToDB(ArrayList al) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { for (int i = 0; i < al.Count; i++) { ProductIDInfo oInfo = (ProductIDInfo)al[i]; string sql = "update Product_ID set ProductSN=" + Util.ToSqlString(oInfo.ProductSN) + " where sysno =" + oInfo.SysNo; SqlHelper.ExecuteNonQuery(sql); } scope.Complete(); } }
public int Update(ProductIDInfo oParam) { return(new ProductIDDac().Update(oParam)); }
public int Insert(ProductIDInfo oParam) { return(new ProductIDDac().Insert(oParam)); }
public int Insert(ProductIDInfo oParam) { string sql = @"INSERT INTO Product_ID ( ProductSysNo, POSysNo, OrderNum, Status, ProductSN, ProductTrackSN, Note ) VALUES ( @ProductSysNo, @POSysNo, @OrderNum, @Status, @ProductSN, @ProductTrackSN, @Note );set @SysNo = SCOPE_IDENTITY();"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4); SqlParameter paramPOSysNo = new SqlParameter("@POSysNo", SqlDbType.Int, 4); SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); SqlParameter paramProductSN = new SqlParameter("@ProductSN", SqlDbType.NVarChar, 50); SqlParameter paramProductTrackSN = new SqlParameter("@ProductTrackSN", SqlDbType.NVarChar, 50); SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.NVarChar, 500); paramSysNo.Direction = ParameterDirection.Output; if (oParam.ProductSysNo != AppConst.IntNull) { paramProductSysNo.Value = oParam.ProductSysNo; } else { paramProductSysNo.Value = System.DBNull.Value; } if (oParam.POSysNo != AppConst.IntNull) { paramPOSysNo.Value = oParam.POSysNo; } else { paramPOSysNo.Value = System.DBNull.Value; } if (oParam.OrderNum != AppConst.IntNull) { paramOrderNum.Value = oParam.OrderNum; } else { paramOrderNum.Value = System.DBNull.Value; } if (oParam.Status != AppConst.IntNull) { paramStatus.Value = oParam.Status; } else { paramStatus.Value = System.DBNull.Value; } if (oParam.ProductSN != AppConst.StringNull) { paramProductSN.Value = oParam.ProductSN; } else { paramProductSN.Value = System.DBNull.Value; } if (oParam.ProductTrackSN != AppConst.StringNull) { paramProductTrackSN.Value = oParam.ProductTrackSN; } else { paramProductTrackSN.Value = System.DBNull.Value; } if (oParam.Note != AppConst.StringNull) { paramNote.Value = oParam.Note; } else { paramNote.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramProductSysNo); cmd.Parameters.Add(paramPOSysNo); cmd.Parameters.Add(paramOrderNum); cmd.Parameters.Add(paramStatus); cmd.Parameters.Add(paramProductSN); cmd.Parameters.Add(paramProductTrackSN); cmd.Parameters.Add(paramNote); return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo)); }
public int Update(ProductIDInfo oParam) { string sql = @"UPDATE Product_ID SET ProductSysNo=@ProductSysNo, POSysNo=@POSysNo, OrderNum=@OrderNum, Status=@Status, ProductSN=@ProductSN, ProductTrackSN=@ProductTrackSN, Note=@Note WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4); SqlParameter paramPOSysNo = new SqlParameter("@POSysNo", SqlDbType.Int, 4); SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4); SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4); SqlParameter paramProductSN = new SqlParameter("@ProductSN", SqlDbType.NVarChar, 50); SqlParameter paramProductTrackSN = new SqlParameter("@ProductTrackSN", SqlDbType.NVarChar, 50); SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.NVarChar, 500); if (oParam.SysNo != AppConst.IntNull) { paramSysNo.Value = oParam.SysNo; } else { paramSysNo.Value = System.DBNull.Value; } if (oParam.ProductSysNo != AppConst.IntNull) { paramProductSysNo.Value = oParam.ProductSysNo; } else { paramProductSysNo.Value = System.DBNull.Value; } if (oParam.POSysNo != AppConst.IntNull) { paramPOSysNo.Value = oParam.POSysNo; } else { paramPOSysNo.Value = System.DBNull.Value; } if (oParam.OrderNum != AppConst.IntNull) { paramOrderNum.Value = oParam.OrderNum; } else { paramOrderNum.Value = System.DBNull.Value; } if (oParam.Status != AppConst.IntNull) { paramStatus.Value = oParam.Status; } else { paramStatus.Value = System.DBNull.Value; } if (oParam.ProductSN != AppConst.StringNull) { paramProductSN.Value = oParam.ProductSN; } else { paramProductSN.Value = System.DBNull.Value; } if (oParam.ProductTrackSN != AppConst.StringNull) { paramProductTrackSN.Value = oParam.ProductTrackSN; } else { paramProductTrackSN.Value = System.DBNull.Value; } if (oParam.Note != AppConst.StringNull) { paramNote.Value = oParam.Note; } else { paramNote.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramProductSysNo); cmd.Parameters.Add(paramPOSysNo); cmd.Parameters.Add(paramOrderNum); cmd.Parameters.Add(paramStatus); cmd.Parameters.Add(paramProductSN); cmd.Parameters.Add(paramProductTrackSN); cmd.Parameters.Add(paramNote); return(SqlHelper.ExecuteNonQuery(cmd)); }