private void map(EqifaLogInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.SOSysNo = Util.TrimIntNull(tempdr["SOSysNo"]);
oParam.ProductSysNo = Util.TrimIntNull(tempdr["ProductSysNo"]);
oParam.Quantity = Util.TrimIntNull(tempdr["Quantity"]);
oParam.Price = Util.TrimDecimalNull(tempdr["Price"]);
oParam.EqifaLog = Util.TrimNull(tempdr["EqifaLog"]);
}
public int Insert(EqifaLogInfo oParam)
{
return(new EqifaLogDac().Insert(oParam));
}
public int Update(EqifaLogInfo oParam)
{
string sql = @"UPDATE Eqifa_Log SET
SOSysNo=@SOSysNo, ProductSysNo=@ProductSysNo,
Quantity=@Quantity, Price=@Price,
EqifaLog=@EqifaLog
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 paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
SqlParameter paramQuantity = new SqlParameter("@Quantity", SqlDbType.Int, 4);
SqlParameter paramPrice = new SqlParameter("@Price", SqlDbType.Decimal, 9);
SqlParameter paramEqifaLog = new SqlParameter("@EqifaLog", SqlDbType.NVarChar, 2000);
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.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;
}
if (oParam.Price != AppConst.DecimalNull)
{
paramPrice.Value = oParam.Price;
}
else
{
paramPrice.Value = System.DBNull.Value;
}
if (oParam.EqifaLog != AppConst.StringNull)
{
paramEqifaLog.Value = oParam.EqifaLog;
}
else
{
paramEqifaLog.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramSOSysNo);
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramQuantity);
cmd.Parameters.Add(paramPrice);
cmd.Parameters.Add(paramEqifaLog);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public int Insert(EqifaLogInfo oParam)
{
string sql = @"INSERT INTO Eqifa_Log
(
SOSysNo, ProductSysNo, Quantity, Price,
EqifaLog
)
VALUES (
@SOSysNo, @ProductSysNo, @Quantity, @Price,
@EqifaLog
);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 paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
SqlParameter paramQuantity = new SqlParameter("@Quantity", SqlDbType.Int, 4);
SqlParameter paramPrice = new SqlParameter("@Price", SqlDbType.Decimal, 9);
SqlParameter paramEqifaLog = new SqlParameter("@EqifaLog", SqlDbType.NVarChar, 2000);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.SOSysNo != AppConst.IntNull)
{
paramSOSysNo.Value = oParam.SOSysNo;
}
else
{
paramSOSysNo.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;
}
if (oParam.Price != AppConst.DecimalNull)
{
paramPrice.Value = oParam.Price;
}
else
{
paramPrice.Value = System.DBNull.Value;
}
if (oParam.EqifaLog != AppConst.StringNull)
{
paramEqifaLog.Value = oParam.EqifaLog;
}
else
{
paramEqifaLog.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramSOSysNo);
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramQuantity);
cmd.Parameters.Add(paramPrice);
cmd.Parameters.Add(paramEqifaLog);
return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
}
