public bool InsertAddActive(AddActiveParam addActiveParam, string shopId)
{
StringBuilder selectBuilder = new StringBuilder();
selectBuilder.AppendFormat(ActiceSqls.INSERT_T_BUSS_ACTIVE, shopId, addActiveParam.activeType, addActiveParam.date[0], addActiveParam.date[1], addActiveParam.activeRemark, "0");
string select = selectBuilder.ToString();
if (DatabaseOperationWeb.ExecuteDML(select))
{
return(true);
}
else
{
return(false);
}
}
public string SelectAddActive(AddActiveParam addActiveParam, string shopId)
{
StringBuilder selectBuilder = new StringBuilder();
selectBuilder.AppendFormat(ActiceSqls.SELECT_T_BUSS_ACTIVE_BY_ACTIVE_ID,
shopId, addActiveParam.activeType, addActiveParam.date[0], addActiveParam.date[1], addActiveParam.activeRemark);
string select = selectBuilder.ToString();
string id = "";
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(select, "T").Tables[0];
if (dt.Rows.Count > 0)
{
id = dt.Rows[0][0].ToString();
}
return(id);
}
public bool InsertActiveConsume(AddActiveParam addActiveParam, string id)
{
StringBuilder selectBuilder = new StringBuilder();
selectBuilder.AppendFormat(ActiceSqls.INSERT_T_BUSS_ACTIVE_CONSUME, addActiveParam.consume, addActiveParam.itemNums, addActiveParam.ItemValue, id, addActiveParam.valueType);
string select = selectBuilder.ToString();
if (DatabaseOperationWeb.ExecuteDML(select))
{
return(true);
}
else
{
return(false);
}
}
