public DataTable SelectByID(M_Adbuy mAdbuy)
{
string strSql = "select * from [ZL_Adbuy] where ID=@ID";
SqlParameter[] sp = mAdbuy.GetParameters();
return(SqlHelper.ExecuteTable(CommandType.Text, strSql, sp));
}
public int Add(M_Adbuy mAdbuy)
{
string strSql = "INSERT INTO ZL_Adbuy(ADID,UID,Time,ShowTime,Scale,Ptime,Content,Files,State,Price,Audit)";
strSql += "values(@ADID,@UID,@Time,@ShowTime,@Scale,@Ptime,@Content,@Files,@State,@Price,@Audit)";
SqlParameter[] sp = mAdbuy.GetParameters();
return(Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, strSql, sp)));
}
public ActionResult AdPlanAdd()
{
DataTable dt = B_ADZone.ADZone_ID();
ViewBag.noad = dt == null || dt.Rows.Count < 1;
int id = DataConverter.CLng(Request["ID"]);
M_Adbuy adbMod = adbBll.SelectId(id);
ViewBag.ADID_DT = dt;
return(View(adbMod));
}
public void AdPlan_Add()
{
int Mid = DataConverter.CLng(Request["id"]);
M_Adbuy adMod = adbBll.SelectId(Mid);
adMod.ADID = DataConverter.CLng(Request.Form["ADID"]);
adMod.Ptime = DataConverter.CDate(Request.Form["PTime"]);
adMod.ShowTime = DataConverter.CLng(Request.Form["ShowTime"]);
adMod.Scale = DataConverter.CLng(Request.Form["scale"]);
adMod.Price = DataConverter.CDecimal(Request.Form["price"]);
adMod.Content = Request.Form["content"];
if (adMod.ID > 0)
{
adbBll.Update(adMod);
function.WriteSuccessMsg("修改成功!!", "AdPlan");
}
else
{
adMod.UID = mu.UserID;
adMod.Time = DateTime.Now;
adbBll.Add(adMod);
function.WriteSuccessMsg("恭喜，您的广告计划提交成功，请尽快付款完成购买!!", "AdPlan");
}
}
public int insert(M_Adbuy model)
{
return(Sql.insert(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public bool Update(M_Adbuy model)
{
return(Sql.UpdateByIDs(strTableName, PK, model.ID.ToString(), BLLCommon.GetFieldAndPara(model), model.GetParameters()));
}
