public int Update(SOVoucherInfo oParam)
{
string sql = @"UPDATE SO_Voucher SET
SOSysNo=@SOSysNo, VoucherID=@VoucherID,
Status=@Status
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4);
SqlParameter paramVoucherID = new SqlParameter("@VoucherID", SqlDbType.NVarChar, 50);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
if (oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if (oParam.SOSysNo != AppConst.IntNull)
paramSOSysNo.Value = oParam.SOSysNo;
else
paramSOSysNo.Value = System.DBNull.Value;
if (oParam.VoucherID != AppConst.StringNull)
paramVoucherID.Value = oParam.VoucherID;
else
paramVoucherID.Value = System.DBNull.Value;
if (oParam.Status != AppConst.IntNull)
paramStatus.Value = oParam.Status;
else
paramStatus.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramSOSysNo);
cmd.Parameters.Add(paramVoucherID);
cmd.Parameters.Add(paramStatus);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Insert(SOVoucherInfo oParam)
{
string sql = @"INSERT INTO SO_Voucher
(
SOSysNo, VoucherID, Status
)
VALUES (
@SOSysNo, @VoucherID, @Status
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4);
SqlParameter paramVoucherID = new SqlParameter("@VoucherID", SqlDbType.NVarChar, 50);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.SOSysNo != AppConst.IntNull)
paramSOSysNo.Value = oParam.SOSysNo;
else
paramSOSysNo.Value = System.DBNull.Value;
if (oParam.VoucherID != AppConst.StringNull)
paramVoucherID.Value = oParam.VoucherID;
else
paramVoucherID.Value = System.DBNull.Value;
if (oParam.Status != AppConst.IntNull)
paramStatus.Value = oParam.Status;
else
paramStatus.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramSOSysNo);
cmd.Parameters.Add(paramVoucherID);
cmd.Parameters.Add(paramStatus);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
public int InsertSOVoucher(SOVoucherInfo oParam)
{
return new SOVoucherDac().Insert(oParam);
}
private void map(SOVoucherInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.SOSysNo = Util.TrimIntNull(tempdr["SOSysNo"]);
oParam.VoucherID = Util.TrimNull(tempdr["VoucherID"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
}
private SOVoucherInfo LoadSOVoucher(SOVoucherInfo oParam)
{
string sql = "select * from so_voucher where sosysno=" + oParam.SOSysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
SOVoucherInfo newInfo = new SOVoucherInfo();
map(newInfo, ds.Tables[0].Rows[0]);
return newInfo;
}
else
{
return null;
}
}
public int UpdateSOVoucher(SOVoucherInfo oParam)
{
return new SOVoucherDac().Update(oParam);
}
public Hashtable LoadSOVoucherList(string VoucherID)
{
string sql = "select * from so_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)
{
SOVoucherInfo oInfo = new SOVoucherInfo();
map(oInfo, dr);
ht.Add(oInfo, null);
}
return ht;
}
else
return null;
}