public int Update(SOAdwaysInfo oParam)
{
string sql = @"UPDATE SO_Adways SET
CustomerSysNo=@CustomerSysNo, AdwaysID=@AdwaysID,
AdwaysEmail=@AdwaysEmail, SOSysNo=@SOSysNo,
ShipPrice=@ShipPrice
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4);
SqlParameter paramAdwaysID = new SqlParameter("@AdwaysID", SqlDbType.NVarChar, 50);
SqlParameter paramAdwaysEmail = new SqlParameter("@AdwaysEmail", SqlDbType.NVarChar, 200);
SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4);
SqlParameter paramShipPrice = new SqlParameter("@ShipPrice", SqlDbType.Decimal, 9);
if (oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if (oParam.CustomerSysNo != AppConst.IntNull)
paramCustomerSysNo.Value = oParam.CustomerSysNo;
else
paramCustomerSysNo.Value = System.DBNull.Value;
if (oParam.AdwaysID != AppConst.StringNull)
paramAdwaysID.Value = oParam.AdwaysID;
else
paramAdwaysID.Value = System.DBNull.Value;
if (oParam.AdwaysEmail != AppConst.StringNull)
paramAdwaysEmail.Value = oParam.AdwaysEmail;
else
paramAdwaysEmail.Value = System.DBNull.Value;
if (oParam.SOSysNo != AppConst.IntNull)
paramSOSysNo.Value = oParam.SOSysNo;
else
paramSOSysNo.Value = System.DBNull.Value;
if (oParam.ShipPrice != AppConst.DecimalNull)
paramShipPrice.Value = oParam.ShipPrice;
else
paramShipPrice.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramCustomerSysNo);
cmd.Parameters.Add(paramAdwaysID);
cmd.Parameters.Add(paramAdwaysEmail);
cmd.Parameters.Add(paramSOSysNo);
cmd.Parameters.Add(paramShipPrice);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Insert(SOAdwaysInfo oParam)
{
string sql = @"INSERT INTO SO_Adways
(
CustomerSysNo, AdwaysID, AdwaysEmail, SOSysNo,
ShipPrice
)
VALUES (
@CustomerSysNo, @AdwaysID, @AdwaysEmail, @SOSysNo,
@ShipPrice
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramCustomerSysNo = new SqlParameter("@CustomerSysNo", SqlDbType.Int, 4);
SqlParameter paramAdwaysID = new SqlParameter("@AdwaysID", SqlDbType.NVarChar, 50);
SqlParameter paramAdwaysEmail = new SqlParameter("@AdwaysEmail", SqlDbType.NVarChar, 200);
SqlParameter paramSOSysNo = new SqlParameter("@SOSysNo", SqlDbType.Int, 4);
SqlParameter paramShipPrice = new SqlParameter("@ShipPrice", SqlDbType.Decimal, 9);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.CustomerSysNo != AppConst.IntNull)
paramCustomerSysNo.Value = oParam.CustomerSysNo;
else
paramCustomerSysNo.Value = System.DBNull.Value;
if (oParam.AdwaysID != AppConst.StringNull)
paramAdwaysID.Value = oParam.AdwaysID;
else
paramAdwaysID.Value = System.DBNull.Value;
if (oParam.AdwaysEmail != AppConst.StringNull)
paramAdwaysEmail.Value = oParam.AdwaysEmail;
else
paramAdwaysEmail.Value = System.DBNull.Value;
if (oParam.SOSysNo != AppConst.IntNull)
paramSOSysNo.Value = oParam.SOSysNo;
else
paramSOSysNo.Value = System.DBNull.Value;
if (oParam.ShipPrice != AppConst.DecimalNull)
paramShipPrice.Value = oParam.ShipPrice;
else
paramShipPrice.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramCustomerSysNo);
cmd.Parameters.Add(paramAdwaysID);
cmd.Parameters.Add(paramAdwaysEmail);
cmd.Parameters.Add(paramSOSysNo);
cmd.Parameters.Add(paramShipPrice);
return SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo);
}
private void map(SOAdwaysInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.CustomerSysNo = Util.TrimIntNull(tempdr["CustomerSysNo"]);
oParam.AdwaysID = Util.TrimNull(tempdr["AdwaysID"]);
oParam.AdwaysEmail = Util.TrimNull(tempdr["AdwaysEmail"]);
oParam.SOSysNo = Util.TrimIntNull(tempdr["SOSysNo"]);
oParam.ShipPrice = Util.TrimDecimalNull(tempdr["ShipPrice"]);
}
public int UpdateSOAdways(SOAdwaysInfo oParam)
{
return new SOAdwaysDac().Update(oParam);
}
public SOAdwaysInfo LoadSOAdwaysBySOSysNo(int SOSysNo)
{
string sql = @"select * from so_adways where sosysno=" + SOSysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
SOAdwaysInfo oInfo = new SOAdwaysInfo();
if (Util.HasMoreRow(ds))
map(oInfo, ds.Tables[0].Rows[0]);
else
oInfo = null;
return oInfo;
}
public SOAdwaysInfo LoadSOAdways(string AdwaysID)
{
string sql = @"select top 1 * from so_adways where adwaysid=" + Util.ToSqlString(AdwaysID);
DataSet ds = SqlHelper.ExecuteDataSet(sql);
SOAdwaysInfo oInfo = new SOAdwaysInfo();
if (Util.HasMoreRow(ds))
map(oInfo, ds.Tables[0].Rows[0]);
else
oInfo = null;
return oInfo;
}
public int InsertSOAdways(SOAdwaysInfo oParam)
{
return new SOAdwaysDac().Insert(oParam);
}
