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));
}
