/// <summary>
/// 添加产品系列
/// </summary>
/// <param name="title"></param>
/// <param name="urlPic"></param>
/// <param name="urlVideo"></param>
/// <param name="tMemo"></param>
/// <param name="pbtime"></param>
/// <param name="oHide"></param>
/// <param name="pri"></param>
/// <returns></returns>
public bool InsertProduct(string title, string urlPic, string urlVideo, string tMemo, string pbtime, string oHide, string pri
, string vd, string tid, string oFree)
{
SqlParameter sid = new SqlParameter("@sid0", Convert.ToInt32(0));
SqlParameter VideoName = new SqlParameter("@vName", title);
SqlParameter tPic = new SqlParameter("@vPic", urlPic);
SqlParameter tVideo = new SqlParameter("@vUrl", "");
SqlParameter tMemos = new SqlParameter("@vMemo", tMemo);
SqlParameter dtAddTime = new SqlParameter("@addTime", Convert.ToDateTime(pbtime));
SqlParameter oHides = new SqlParameter("@oHide", int.Parse(oHide));
SqlParameter price = new SqlParameter("@Price", StringDelHTML.PriceToIntUp(pri));
SqlParameter vdiscrib = new SqlParameter("@vdiscrib", vd);
SqlParameter teacherID = new SqlParameter("@teacherID", tid);
SqlParameter ofree = new SqlParameter("@oFree", int.Parse(oFree));
SqlParameter[] count = { sid, VideoName, tPic, tVideo, tMemos, dtAddTime, oHides, price,
vdiscrib, teacherID, ofree };
string sql = @"insert into ML_VideoComment values (@sid0,@vMemo,@Price,@vName,@vPic,@vUrl,@oHide,@addTime
,@vdiscrib,@teacherID,@oFree)";
bool success = her.ExecuteNonQuery(sql, count);
if (success)
{
return(true);
}
return(false);
}
//修改产品系列
public bool UpdateProduct(string ID, string title, string urlPic, string urlVideo, string tMemo, string pbtime, string oHide, string pri
, string vd, string tid, string oFree)
{
SqlParameter sid = new SqlParameter("@sid0", Convert.ToInt32(0));
SqlParameter VideoName = new SqlParameter("@vName", title);
SqlParameter tPic = new SqlParameter("@vPic", urlPic);
SqlParameter tVideo = new SqlParameter("@vUrl", urlVideo);
SqlParameter tMemos = new SqlParameter("@vMemo", tMemo);
SqlParameter dtAddTime = new SqlParameter("@addTime", Convert.ToDateTime(pbtime));
SqlParameter oHides = new SqlParameter("@oHide", int.Parse(oHide));
SqlParameter price = new SqlParameter("@Price", StringDelHTML.PriceToIntUp(pri));
SqlParameter vdiscrib = new SqlParameter("@vdiscrib", vd);
SqlParameter teacherID = new SqlParameter("@teacherID", tid);
SqlParameter ofree = new SqlParameter("@oFree", int.Parse(oFree));
SqlParameter[] count = { sid, VideoName, tPic, tVideo, tMemos, dtAddTime, oHides, price,
vdiscrib, teacherID, ofree };
string sql = @"update ML_VideoComment set sid0=@sid0,vMemo=@vMemo,Price=@Price,vName=@vName,
vPic=@vPic,vUrl=@vUrl,oHide=@oHide,addTime=@addTime,vdiscrib=@vdiscrib,teacherID=@teacherID,oFree=@oFree where nID=" + ID;
bool success = her.ExecuteNonQuery(sql, count);
if (success)
{
return(true);
}
return(false);
}
protected void ImgSrs_Click(object sender, EventArgs e)
{
int money = StringDelHTML.PriceToIntUp(price.Text.Trim());
//插入全球分红，每日
DateTime dt = System.DateTime.Now;
if (dt.Hour > 10)//每天10点以后的数据
{
DataTable table = tj.GetUserByLevel(_level);
if (table.Rows.Count > 0)
{
if (tj.InsertFenHongLastDay(table, _level, money, true))
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('分红成功')</script>");
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('您已提交过昨日的分红')</script>");
}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('无可分红对象')</script>");
}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('每日10点后才能提交分红')</script>");
}
}
//修改产品
public bool UpdateProduct(string ID, string dropGroup, string title, string urlPic, string urlVideo, string tMemo, string oNew, string oTop, string pbtime, string oHide, string pri)
{
SqlParameter sid0 = new SqlParameter("@sid0", dropGroup);
//SqlParameter VideoCode = new SqlParameter("@VideoCode", "0");
SqlParameter VideoName = new SqlParameter("@VideoName", title);
SqlParameter tPic = new SqlParameter("@tPic", urlPic);
SqlParameter tVideo = new SqlParameter("@tVideo", urlVideo);
SqlParameter tMemos = new SqlParameter("@tMemo", tMemo);
SqlParameter oNewest = new SqlParameter("@oNewest", int.Parse(oNew));
SqlParameter oTops = new SqlParameter("@oTop", int.Parse(oTop));
SqlParameter dtPubTime = new SqlParameter("@dtPubTime", Convert.ToDateTime(pbtime));
SqlParameter dtAddTime = new SqlParameter("@dtAddTime", System.DateTime.Now);
SqlParameter oHides = new SqlParameter("@oHide", int.Parse(oHide));
SqlParameter price = new SqlParameter("@Price", StringDelHTML.PriceToIntUp(pri));
SqlParameter[] count = { sid0, VideoName, tPic, tVideo, tMemos, oNewest, oTops, dtPubTime, dtAddTime, oHides, price };
string sql = @"update ML_Video set sid0=@sid0,VideoName=@VideoName,tPic=@tPic,tVideo=@tVideo,
tMemo=@tMemo,oNewest=@oNewest,oTop=@oTop,dtPubTime=@dtPubTime,dtAddTime=@dtAddTime,oHide=@oHide,Price=@Price where nID=" + ID;
bool success = her.ExecuteNonQuery(sql, count);
if (success)
{
return(true);
}
return(false);
}
/// <summary>
/// 添加产品
/// </summary>
/// <param name="dropGroup"></param>
/// <param name="title"></param>
/// <param name="urlPic"></param>
/// <param name="urlVideo"></param>
/// <param name="tMemo"></param>
/// <param name="oNewest"></param>
/// <param name="oTop"></param>
/// <param name="pbtime"></param>
/// <param name="oHide"></param>
/// <returns></returns>
public bool InsertProduct(string dropGroup, string title, string urlPic, string urlVideo, string tMemo, string oNew, string oTop, string pbtime, string oHide, string pri)
{
SqlParameter sid0 = new SqlParameter("@sid0", dropGroup);
SqlParameter VideoCode = new SqlParameter("@VideoCode", 0);
SqlParameter VideoName = new SqlParameter("@VideoName", title);
SqlParameter tPic = new SqlParameter("@tPic", urlPic);
SqlParameter tVideo = new SqlParameter("@tVideo", urlVideo);
SqlParameter tMemos = new SqlParameter("@tMemo", tMemo);
SqlParameter oNewest = new SqlParameter("@oNewest", int.Parse(oNew));
SqlParameter oTops = new SqlParameter("@oTop", int.Parse(oTop));
SqlParameter dtPubTime = new SqlParameter("@dtPubTime", Convert.ToDateTime(pbtime));
SqlParameter dtAddTime = new SqlParameter("@dtAddTime", System.DateTime.Now);
SqlParameter oHides = new SqlParameter("@oHide", int.Parse(oHide));
SqlParameter price = new SqlParameter("@Price", StringDelHTML.PriceToIntUp(pri));
SqlParameter[] count = { sid0, VideoCode, VideoName, tPic, tVideo, tMemos, oNewest, oTops, dtPubTime, dtAddTime, oHides, price };
string sql = @"insert into ML_Video values (@sid0,@VideoCode,@VideoName,@tPic,@tVideo,@tMemo,@oNewest,@oTop,@dtPubTime,@dtAddTime,@oHide,@Price)";
bool success = her.ExecuteNonQuery(sql, count);
if (success)
{
return(true);
}
return(false);
}
private void GetProductPrice()
{
string sql = "select Price from ML_Video where nID=" + pID;
string price = her.ExecuteScalar(sql) == null ? "0.01" : her.ExecuteScalar(sql).ToString() == "" ? "0.01" : StringDelHTML.PriceToStringLow(Convert.ToInt32(her.ExecuteScalar(sql)));
LogUtil.WriteLog("产品价格=" + price);
this.proPrice = price;
orderprice.Value = StringDelHTML.PriceToIntUp(proPrice).ToString();
}
private void GetProductPrice()
{
string sql = "select Price from ML_VideoComment where nID=" + pID;
string price = her.ExecuteScalar(sql) == null ? "0.01" : her.ExecuteScalar(sql).ToString() == "" ? "0.01" : StringDelHTML.PriceToStringLow(Convert.ToInt32(her.ExecuteScalar(sql)));
LogUtil.WriteLog("产品价格=" + price);
//判断是否已经是会员
if (ph.Memberisfxs(nID))
{
//再次购买，产品打1折
price = (Convert.ToDouble(price) * 0.1).ToString();
huiyuanPrice = "您已享受会员价1折购买";
}
this.proPrice = price;
orderprice.Value = StringDelHTML.PriceToIntUp(proPrice).ToString();
}
