/// <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(); }