private void map(SOIncomeVoucherInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.FSISysNo = Util.TrimIntNull(tempdr["FSISysNo"]);
oParam.VoucherID = Util.TrimNull(tempdr["VoucherID"]);
oParam.VoucherTime = Util.TrimDateNull(tempdr["VoucherTime"]);
oParam.SysUserSysNo = Util.TrimIntNull(tempdr["SysUserSysNo"]);
oParam.DateStamp = Util.TrimDateNull(tempdr["DateStamp"]);
}
public SOIncomeVoucherInfo LoadSOIncomeVoucher(SOIncomeVoucherInfo oParam)
{
string sql = "select * from finance_soincome_voucher where fsisysno=" + oParam.FSISysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
SOIncomeVoucherInfo newInfo = new SOIncomeVoucherInfo();
map(newInfo, ds.Tables[0].Rows[0]);
return(newInfo);
}
else
{
return(null);
}
}
public Hashtable LoadSOIncomeVoucherList(string VoucherID)
{
string sql = "select * from finance_soincome_voucher where voucherid = " + Util.ToSqlString(VoucherID);
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
Hashtable ht = new Hashtable();
foreach (DataRow dr in ds.Tables[0].Rows)
{
SOIncomeVoucherInfo oInfo = new SOIncomeVoucherInfo();
map(oInfo, dr);
ht.Add(oInfo, null);
}
return(ht);
}
else
{
return(null);
}
}
public void InsertSOIncomeVoucherList(Hashtable ht)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
foreach (SOIncomeVoucherInfo oParam in ht.Keys)
{
SOIncomeVoucherInfo newInfo = LoadSOIncomeVoucher(oParam);
if (newInfo == null)
{
InsertSOIncomeVoucher(oParam);
}
else
{
newInfo.VoucherID = oParam.VoucherID;
newInfo.VoucherTime = oParam.VoucherTime;
UpdateSOIncomeVoucher(newInfo);
}
SOIncomeInfo oInfo = SOIncomeManager.GetInstance().Load(oParam.FSISysNo);
if (oInfo.OrderType == (int)AppEnum.SOIncomeOrderType.RO)
{
RMARefundInfo oRefundInfo = RMARefundManager.GetInstance().LoadRMARefund(oInfo.OrderSysNo);
if (oRefundInfo != null)
{
Hashtable rmaht = new Hashtable();
rmaht.Add("SysNo", oRefundInfo.SysNo);
rmaht.Add("VoucherID", oParam.VoucherID);
rmaht.Add("VoucherTime", oParam.VoucherTime);
RMARefundManager.GetInstance().UpdateMasterMemo(rmaht);
}
}
}
scope.Complete();
}
}
public int UpdateSOIncomeVoucher(SOIncomeVoucherInfo oParam)
{
return(new SOIncomeVoucherDac().Update(oParam));
}
public int InsertSOIncomeVoucher(SOIncomeVoucherInfo oParam)
{
return(new SOIncomeVoucherDac().Insert(oParam));
}
public int Update(SOIncomeVoucherInfo oParam)
{
string sql = @"UPDATE Finance_SoIncome_Voucher SET
FSISysNo=@FSISysNo, VoucherID=@VoucherID,
VoucherTime=@VoucherTime, SysUserSysNo=@SysUserSysNo,
DateStamp=@DateStamp
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramFSISysNo = new SqlParameter("@FSISysNo", SqlDbType.Int, 4);
SqlParameter paramVoucherID = new SqlParameter("@VoucherID", SqlDbType.NVarChar, 50);
SqlParameter paramVoucherTime = new SqlParameter("@VoucherTime", SqlDbType.DateTime);
SqlParameter paramSysUserSysNo = new SqlParameter("@SysUserSysNo", SqlDbType.Int, 4);
SqlParameter paramDateStamp = new SqlParameter("@DateStamp", SqlDbType.DateTime);
if (oParam.SysNo != AppConst.IntNull)
{
paramSysNo.Value = oParam.SysNo;
}
else
{
paramSysNo.Value = System.DBNull.Value;
}
if (oParam.FSISysNo != AppConst.IntNull)
{
paramFSISysNo.Value = oParam.FSISysNo;
}
else
{
paramFSISysNo.Value = System.DBNull.Value;
}
if (oParam.VoucherID != AppConst.StringNull)
{
paramVoucherID.Value = oParam.VoucherID;
}
else
{
paramVoucherID.Value = System.DBNull.Value;
}
if (oParam.VoucherTime != AppConst.DateTimeNull)
{
paramVoucherTime.Value = oParam.VoucherTime;
}
else
{
paramVoucherTime.Value = System.DBNull.Value;
}
if (oParam.SysUserSysNo != AppConst.IntNull)
{
paramSysUserSysNo.Value = oParam.SysUserSysNo;
}
else
{
paramSysUserSysNo.Value = System.DBNull.Value;
}
if (oParam.DateStamp != AppConst.DateTimeNull)
{
paramDateStamp.Value = oParam.DateStamp;
}
else
{
paramDateStamp.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramFSISysNo);
cmd.Parameters.Add(paramVoucherID);
cmd.Parameters.Add(paramVoucherTime);
cmd.Parameters.Add(paramSysUserSysNo);
cmd.Parameters.Add(paramDateStamp);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public int Insert(SOIncomeVoucherInfo oParam)
{
string sql = @"INSERT INTO Finance_SoIncome_Voucher
(
FSISysNo, VoucherID, VoucherTime, SysUserSysNo,
DateStamp
)
VALUES (
@FSISysNo, @VoucherID, @VoucherTime, @SysUserSysNo,
@DateStamp
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramFSISysNo = new SqlParameter("@FSISysNo", SqlDbType.Int, 4);
SqlParameter paramVoucherID = new SqlParameter("@VoucherID", SqlDbType.NVarChar, 50);
SqlParameter paramVoucherTime = new SqlParameter("@VoucherTime", SqlDbType.DateTime);
SqlParameter paramSysUserSysNo = new SqlParameter("@SysUserSysNo", SqlDbType.Int, 4);
SqlParameter paramDateStamp = new SqlParameter("@DateStamp", SqlDbType.DateTime);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.FSISysNo != AppConst.IntNull)
{
paramFSISysNo.Value = oParam.FSISysNo;
}
else
{
paramFSISysNo.Value = System.DBNull.Value;
}
if (oParam.VoucherID != AppConst.StringNull)
{
paramVoucherID.Value = oParam.VoucherID;
}
else
{
paramVoucherID.Value = System.DBNull.Value;
}
if (oParam.VoucherTime != AppConst.DateTimeNull)
{
paramVoucherTime.Value = oParam.VoucherTime;
}
else
{
paramVoucherTime.Value = System.DBNull.Value;
}
if (oParam.SysUserSysNo != AppConst.IntNull)
{
paramSysUserSysNo.Value = oParam.SysUserSysNo;
}
else
{
paramSysUserSysNo.Value = System.DBNull.Value;
}
if (oParam.DateStamp != AppConst.DateTimeNull)
{
paramDateStamp.Value = oParam.DateStamp;
}
else
{
paramDateStamp.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramFSISysNo);
cmd.Parameters.Add(paramVoucherID);
cmd.Parameters.Add(paramVoucherTime);
cmd.Parameters.Add(paramSysUserSysNo);
cmd.Parameters.Add(paramDateStamp);
return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
}
