public int Insert(SaleGiftInfo oParam)
{
string sql = @"INSERT INTO Sale_Gift
(
ProductSysNo, GiftSysNo, ListOrder,
CreateUserSysNo)
VALUES (
@ProductSysNo, @GiftSysNo, @ListOrder,
@CreateUserSysNo)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int,4);
SqlParameter paramGiftSysNo = new SqlParameter("@GiftSysNo", SqlDbType.Int,4);
SqlParameter paramListOrder = new SqlParameter("@ListOrder", SqlDbType.NVarChar,10);
SqlParameter paramCreateUserSysNo = new SqlParameter("@CreateUserSysNo", SqlDbType.Int,4);
if ( oParam.ProductSysNo != AppConst.IntNull)
paramProductSysNo.Value = oParam.ProductSysNo;
else
paramProductSysNo.Value = System.DBNull.Value;
if ( oParam.GiftSysNo != AppConst.IntNull)
paramGiftSysNo.Value = oParam.GiftSysNo;
else
paramGiftSysNo.Value = System.DBNull.Value;
if ( oParam.ListOrder != AppConst.StringNull)
paramListOrder.Value = oParam.ListOrder;
else
paramListOrder.Value = System.DBNull.Value;
if ( oParam.CreateUserSysNo != AppConst.IntNull)
paramCreateUserSysNo.Value = oParam.CreateUserSysNo;
else
paramCreateUserSysNo.Value = System.DBNull.Value;
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramGiftSysNo);
cmd.Parameters.Add(paramListOrder);
cmd.Parameters.Add(paramCreateUserSysNo);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Update(SaleGiftInfo oParam)
{
string sql = @"UPDATE Sale_Gift SET
Status=@Status,AbandonUserSysNo=@AbandonUserSysNo,
AbandonTime=@AbandonTime
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);
SqlParameter paramAbandonUserSysNo = new SqlParameter("@AbandonUserSysNo", SqlDbType.Int,4);
SqlParameter paramAbandonTime = new SqlParameter("@AbandonTime", SqlDbType.DateTime);
if ( oParam.SysNo != AppConst.IntNull)
paramSysNo.Value = oParam.SysNo;
else
paramSysNo.Value = System.DBNull.Value;
if ( oParam.Status != AppConst.IntNull)
paramStatus.Value = oParam.Status;
else
paramStatus.Value = System.DBNull.Value;
if ( oParam.AbandonUserSysNo != AppConst.IntNull)
paramAbandonUserSysNo.Value = oParam.AbandonUserSysNo;
else
paramAbandonUserSysNo.Value = System.DBNull.Value;
if ( oParam.AbandonTime != AppConst.DateTimeNull)
paramAbandonTime.Value = oParam.AbandonTime;
else
paramAbandonTime.Value = System.DBNull.Value;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramAbandonUserSysNo);
cmd.Parameters.Add(paramAbandonTime);
return SqlHelper.ExecuteNonQuery(cmd);
}
private void map(SaleGiftInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.ProductSysNo = Util.TrimIntNull(tempdr["ProductSysNo"]);
oParam.GiftSysNo = Util.TrimIntNull(tempdr["GiftSysNo"]);
oParam.ListOrder = Util.TrimNull(tempdr["ListOrder"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
oParam.CreateUserSysNo = Util.TrimIntNull(tempdr["CreateUserSysNo"]);
oParam.CreateTime = Util.TrimDateNull(tempdr["CreateTime"]);
oParam.AbandonUserSysNo = Util.TrimIntNull(tempdr["AbandonUserSysNo"]);
oParam.AbandonTime = Util.TrimDateNull(tempdr["AbandonTime"]);
}
public void UpdateSaleGift(SaleGiftInfo oParam)
{
new SaleGiftDac().Update(oParam);
}
//������Ʒ��Ϣ��������������
public void UpdateAllGiftInfo(SaleGiftInfo oParam)
{
new SaleGiftDac().UpdateGift(oParam);
}
public int InsertSaleGift(SaleGiftInfo oParam)
{
return new SaleGiftDac().Insert(oParam);
}
public Hashtable GetSaleGiftHash(Hashtable sysNoHash)
{
Hashtable sgInfoHash = new Hashtable(2);
if(sysNoHash.Count!=0)
{
string strSysNo = "(";
foreach(int sysNo in sysNoHash.Keys)
{
strSysNo += "'"+sysNo+"',";
}
strSysNo = strSysNo.TrimEnd(',');
strSysNo += ")";
string sql = @"select
*
from
sale_gift
where
status = "+(int)AppEnum.BiStatus.Valid+" and sysno in "+strSysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if(Util.HasMoreRow(ds))
{
foreach(DataRow dr in ds.Tables[0].Rows)
{
SaleGiftInfo sgInfo = new SaleGiftInfo();
this.map(sgInfo,dr);
sgInfoHash.Add(sgInfo.SysNo,sgInfo);
}
}
}
return sgInfoHash;
}