protected void btnUpdateAd_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["upid"]))
{
if (EnshineUnionManager.model.SearchDataClass.IsNumber(Request["upid"]) == true)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
Advertisement upNot = db.Advertisement.Single(x => x.AdID == int.Parse(Request["upid"]));
upNot.AdTitle = txtTitle.Value.Trim();
upNot.Company = txtCompany.Value;
upNot.AdContent = txtFckContent.Value.Trim();
if (!string.IsNullOrEmpty(HFurl.Value))
{
upNot.AdImg = HFurl.Value.Trim();
}
//upNot.Addtime = DateTime.Now;
upNot.setindex = Convert.ToChar(drpSetIndex.SelectedValue);
upNot.goodscode = txtGoodsCode.Value;
db.SubmitChanges();
}
}
Response.Redirect("AdManager.aspx?mid=" + Request["mid"]);
}
}
protected void btnUpdateUserInfo_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["upid"]))
{
if (EnshineUnionManager.model.SearchDataClass.IsNumber(Request["upid"]) == true)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
UserInfo upNot = db.UserInfo.Single(x => x.Id == int.Parse(Request["upid"]));
upNot.nickname = txtNickName.Value.Trim();
upNot.name = txtName.Value.Trim();
upNot.tel = txtTel.Value.Trim();
upNot.email = txtEmail.Value.Trim();
upNot.sex = Convert.ToChar(drpSex.SelectedValue);
upNot.address = txtAddress.Value.Trim();
upNot.areacity = seachprov.SelectedItem.Text + " " + seachcity.SelectedItem.Text + " " +
seachdistrict.SelectedItem.Text;//txtAreacity.Value.Trim();
upNot.pass = txtPass.Value.Trim();
upNot.cardno = txtCardNo.Value;
upNot.plantnum = txtPlantNum.Value;
upNot.homenum = txtHomeNum.Value;
db.SubmitChanges();
}
}
Response.Redirect("UserinfoManager.aspx");
}
}
protected void btnAddUserInfo_Click(object sender, EventArgs e)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
UserInfo adNot = new UserInfo();
adNot.nickname = txtNickName.Value.Trim();
adNot.name = txtName.Value.Trim();;
adNot.tel = txtTel.Value.Trim();;
adNot.email = txtEmail.Value.Trim();;
adNot.sex = Convert.ToChar(drpSex.SelectedValue);
adNot.address = txtAddress.Value.Trim();;
adNot.areacity = seachprov.SelectedItem.Text + " " + seachcity.SelectedItem.Text + " " +
seachdistrict.SelectedItem.Text;
//txtAreacity.Value.Trim();
adNot.pass = txtPass.Value.Trim();;
adNot.invitedcode = txtTel.Value.Trim(); // 20160220 del txtInvitedCode.Value.Trim();
adNot.cardno = txtCardNo.Value;
adNot.plantnum = txtPlantNum.Value;
adNot.homenum = txtHomeNum.Value;
adNot.addtime = DateTime.Now;
db.UserInfo.InsertOnSubmit(adNot);
db.SubmitChanges();
}
Response.Redirect("UserinfoManager.aspx");
}
protected void btnAddGroupBuy_Click(object sender, EventArgs e)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
goodstuan addTuan = new goodstuan();
addTuan.title = txtTitle.Value;
addTuan.content = SearchDataClass.CheckStr(txtFckContent.Value);
addTuan.starttime = Convert.ToDateTime(txtTimeSelect.Value.Split('-')[0]);
var endtime = txtTimeSelect.Value.Split('-')[1] + " 23:59:59";
addTuan.endtime = Convert.ToDateTime(endtime);
addTuan.validate = Convert.ToChar(drpValidate.SelectedValue);
addTuan.setindex = Convert.ToChar(drpSetIndex.SelectedValue);
addTuan.quantity = int.Parse(txtQuantily.Value);
addTuan.price = Convert.ToDecimal(txtGoodsPrice.Value);
addTuan.costprice = Convert.ToDecimal(txtGoodsCost.Value);
addTuan.weight = txtWeight.Value.ToString();
//addTuan.community = int.Parse(drpCommunity.SelectedValue);
//addTuan.shopid = int.Parse(drpShop.SelectedValue);
addTuan.batch = txtGroupNum.Value;
addTuan.img = HFurl.Value;
addTuan.imgtwo = HFurl1.Value;
addTuan.groupsort = int.Parse(drpGoodsSort.SelectedValue);
addTuan.groupsortimg = HFurl2.Value.Trim();
addTuan.tuansummary = txtSummary.Value;
addTuan.tuansummary1 = txtSummary1.Value;
addTuan.tuansummary2 = txtSummary2.Value;
addTuan.addtime = DateTime.Now;
addTuan.selectytsort = Convert.ToChar(drpSaleGoodsSort.SelectedValue);
addTuan.goodscode = txtGoodsCode.Value;
addTuan.getgoodpoint = int.Parse(txtGetGoodPoint.Value);
db.goodstuan.InsertOnSubmit(addTuan);
db.SubmitChanges();
}
Response.Redirect("GroupBuyManager.aspx?mid=" + Request["mid"] + "&type=" + Request["type"]);
}
protected void btnUpdateHuoDong_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["upid"]))
{
if (EnshineUnionManager.model.SearchDataClass.IsNumber(Request["upid"]) == true)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
HuoDong upNot = db.HuoDong.Single(x => x.huodongId == int.Parse(Request["upid"]));
upNot.huodongTitle = txtTitle.Value.Trim();
upNot.huodongPeople = txtPeople.Value;
upNot.huodongKeyWord = txtKeyWord.Value;
upNot.huodongDate = txtTimeSelect.Value;
upNot.huodongContent = txtFckContent.Value.Trim();
upNot.huodongImg = HFurl.Value.Trim();
upNot.huodongsort = int.Parse(drpHuoDongSort.SelectedValue);
//upNot.addTime = DateTime.Now;
upNot.setindex = Convert.ToChar(drpSetIndex.SelectedValue);
db.SubmitChanges();
}
}
Response.Redirect("HuoDongManager.aspx?mid=" + Request["mid"]);
}
}
protected void btnMemberExtrac_ServerClick(object sender, EventArgs e)
{
HttpCookie getCookies = Request.Cookies["UserLogin"];
if (getCookies != null)
{
if (Convert.ToDecimal(txtMemberExtrac.Value) > Convert.ToDecimal(spMoney.InnerText))
{
ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('提现不能超过账户余额。');</script>");
return;
}
else
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
memberextract ext = new memberextract();
ext.extno = DateTime.Now.ToString("yymmssffff");
ext.extmoney = Convert.ToDecimal(txtMemberExtrac.Value);
ext.exttel = getCookies["ClientName"];
ext.extuserid = int.Parse(getCookies["ClientUserID"]);
ext.extcontent = "提现";
ext.extcardno = txtCardNo.Value;
ext.exttime = DateTime.Now;
db.memberextract.InsertOnSubmit(ext);
db.SubmitChanges();
ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('提现成功等待财务审核后进行手工打款。');window.location.href='MyPayMoney.aspx';</script>");
}
}
}
}
protected void btnUpdatePlantDoctor_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["upid"]))
{
if (EnshineUnionManager.model.SearchDataClass.IsNumber(Request["upid"]) == true)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
plantdoctor upNot = db.plantdoctor.Single(x => x.Id == int.Parse(Request["upid"]));
upNot.title = txtTitle.Value.Trim();
upNot.content = SearchDataClass.CheckStr(txtFckContent.Value);
upNot.validate = Convert.ToChar(drpValidate.SelectedValue);
upNot.setindex = Convert.ToChar(drpSetIndex.SelectedValue);
upNot.plantdoctorsort = int.Parse(drpPlantDoctorSort.SelectedValue);
if (!string.IsNullOrEmpty(HFurl.Value))
{
upNot.img = HFurl.Value.Trim();
}
upNot.addtime = DateTime.Now;
db.SubmitChanges();
}
}
Response.Redirect("PlantDoctorManager.aspx");
}
}
protected void btnAddNotices_Click(object sender, EventArgs e)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
notices addNot = new notices();
addNot.title = SearchDataClass.CheckStr(txtTitle.Value.Trim());;
addNot.content = txtFckContent.Value; // SearchDataClass.CheckStr(txtFckContent.Value);
//addNot.validate = Convert.ToChar(drpValidate.SelectedValue);
//addNot.setindex = Convert.ToChar(drpSetIndex.SelectedValue);
addNot.newssort = int.Parse(drpNewsSort.SelectedValue);
addNot.img = HFurl.Value.Trim();
addNot.img1 = HFurl1.Value.Trim();
addNot.img2 = HFurl2.Value.Trim();
addNot.newssource = txtSource.Value.Trim();
addNot.likenum = 0;
addNot.discussnum = 0;
addNot.browses = 0;
addNot.addtime = DateTime.Now;
db.notices.InsertOnSubmit(addNot);
db.SubmitChanges();
}
Response.Redirect("NewsNoticesManager.aspx?mid=" + Request["mid"]);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
HttpCookie getCookies = Request.Cookies["UserLogin"];
if (getCookies != null)
{
spClientName.InnerHtml = "【" + Server.UrlDecode(getCookies["ClientName"].ToString()) + "】 Welcome To 益生联盟数据平台";
string[] Day = new string[] { "星期日", "星期一", "星期二", "星期三", "星期四", "星期五", "星期六" };
var hour = string.Empty;
if (DateTime.Now.Hour > 12)
{
hour = "下午" + DateTime.Now.Hour + "\n时";
}
else
{
hour = "上午" + DateTime.Now.Hour + "\n时";
}
spNowTime.InnerText = DateTime.Now.ToString("yyyy年MM月dd日") + "\n" + Day[Convert.ToInt16(DateTime.Now.DayOfWeek)] + "\n" + hour;;
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
var getSoStatus = from p in db.goodssort select new { p.sortId, p.sortName, p.sortFatherId, p.sortPath };
if (getSoStatus.Count() <= 0)
{
goodssort insert = new goodssort {
sortName = "无上级分类", sortFatherId = -1, sortPath = "-1", addTime = DateTime.Now
};
db.goodssort.InsertOnSubmit(insert);
db.SubmitChanges();
}
DataTable dtSort = SearchDataClass.ToDataTable(getSoStatus);
//添加根目录
DataRow[] drs = dtSort.Select("sortFatherId=-1");
for (var i = 0; i < drs.Length; i++)
{
string nodeid = drs[i]["sortId"].ToString();
string text = drs[i]["sortName"].ToString();
text = "╋" + text;
this.drpGoodstSort.Items.Add(new ListItem(text, nodeid));
this.drpEditGoodstSort.Items.Add(new ListItem(text, nodeid));
int sonparentid = int.Parse(nodeid);
SearchDataClass.addOtherDll("", sonparentid, dtSort, 1, drpGoodstSort);
SearchDataClass.addOtherDll("", sonparentid, dtSort, 1, drpEditGoodstSort);
}
drpGoodstSort.DataBind();
drpGoodstSort.Items.Insert(0, new ListItem("-请选择商品类型-"));
drpEditGoodstSort.DataBind();
drpEditGoodstSort.Items.Insert(0, new ListItem("-请选择商品类型-"));
}
}
else
{
ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('请登录在进行查询。');window.location.href='Login.aspx';</script>");
}
}
}
protected void btnAddUserRPoint_Click(object sender, EventArgs e)
{
//充值成功状态
var result = false;
var chongzhipoint = int.Parse(txtPoint.Value);
if (chongzhipoint > 0)
{
//积分
int addpoint = 0;
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
try
{
pointdetails pointadd = new pointdetails();
pointadd.userid = int.Parse(hfuserid.Value);
pointadd.getpoint = chongzhipoint;
pointadd.getpointreason = txtFckContent.Value;
pointadd.getpointtime = DateTime.Now;
db.pointdetails.InsertOnSubmit(pointadd);
db.SubmitChanges();
result = true;
}
catch (Exception ex)
{
result = false;
}
finally
{
if (result) //成功后更新余额
{
//检索剩余金额+刚充值金额 +积分
using (EnshineUnionDataContext dbup = new EnshineUnionDataContext())
{
var userpoint = dbup.UserInfo.SingleOrDefault(x => x.Id == int.Parse(hfuserid.Value)).point;
UserInfo upinfo = dbup.UserInfo.Single(x => x.Id == int.Parse(hfuserid.Value));
addpoint = int.Parse(userpoint.ToString()) + int.Parse(txtPoint.Value);
upinfo.point = addpoint;
dbup.SubmitChanges();
}
}
}
}
spMessage.InnerHtml = "手机号为：" + txtRecTel.Value + "充值积分成功，账户积分为：" + addpoint + "分,请等待5秒系统自动会自动跳转。<script>setTimeout(function(){window.location.href='UserRecharge.aspx';},5000);</script>";
txtFckContent.Value = ""; txtRecTel.Value = ""; txtRecMoney.Value = "";
hfuserid.Value = ""; txtPoint.Value = "";
}
else
{
ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('充值积分不能为0');</script>");
}
}
protected void btnAddPlantDoctorSort_ServerClick(object sender, EventArgs e)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
//取得选择父分类的sortpath以便更新新添加分类path
var sortPath = db.plantdoctorsort.Single(x =>
x.sortId == Convert.ToInt32(drpPlantSort.SelectedValue)).sortPath;
//判断三级分类只能三级
if (sortPath.Split(',').Length <= 3)
{
plantdoctorsort addOk = new plantdoctorsort();
addOk.sortFatherId = int.Parse(drpPlantSort.SelectedValue);
addOk.sortName = txtPlantDoctorSort.Value;
// addOk.sortSonId = int.Parse(drpPlantSort.SelectedValue);
//获取信息
addOk.sortImg = HFurl.Value;
addOk.addTime = DateTime.Now;
db.plantdoctorsort.InsertOnSubmit(addOk); db.SubmitChanges();
//取得新添加分类ID
var sortId = db.plantdoctorsort.Max(x => x.sortId);
//获取选择父分类的sortSonId（更新时默认本ID）
//var sortSonId=db.plantdoctorsort.Single(x =>
// x.sortId == Convert.ToInt32(drpPlantSort.SelectedValue)).sortSonId;
plantdoctorsort upSonID = db.plantdoctorsort.Single(x => x.sortId == Convert.ToInt32(drpPlantSort.SelectedValue));
upSonID.sortSonId = sortId;
plantdoctorsort updateOK = db.plantdoctorsort.Single(x => x.sortId == Convert.ToInt32(sortId));
if (!string.IsNullOrEmpty(sortPath) && sortPath != "-1")
{
updateOK.sortPath = sortPath + "," + sortId;
}
else
{
updateOK.sortPath = drpPlantSort.SelectedValue + "," + sortId;
}
db.SubmitChanges();
}
else
{
ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('不能创建超过三级的植保分类,当前为第三级。');</script>");
}
}
/// Response.Redirect("PlantDoctorSortManger.aspx");
}
protected void btnAddUserInfo_Click(object sender, EventArgs e)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
UserInfo adNot = new UserInfo();
adNot.nickname = txtNickName.Value.Trim();
adNot.name = txtName.Value.Trim();;
adNot.tel = txtTel.Value.Trim();;
adNot.email = txtEmail.Value.Trim();;
adNot.sex = Convert.ToChar(drpSex.SelectedValue);
adNot.address = txtAddress.Value.Trim();;
//20161031 更新空格到逗号分割
// adNot.areacity = seachprov.SelectedItem.Text + " " + seachcity.SelectedItem.Text + " " +
//seachdistrict.SelectedItem.Text;
adNot.areacity = seachprov.SelectedItem.Text + "," + seachcity.SelectedItem.Text + "," +
seachdistrict.SelectedItem.Text;
//txtAreacity.Value.Trim();
adNot.pass = txtPass.Value.Trim();;
adNot.invitedcode = txtInvitedCode.Value.Trim();
//adNot.cardno = txtCardNo.Value;
//adNot.plantnum = txtPlantNum.Value;
//adNot.homenum = txtHomeNum.Value;
//adNot.homeinfo = txtHomeInfo.Value;
//adNot.plantsort = txtPlantSort.Value;
adNot.cardimg = HFurl.Value;
adNot.shopset = int.Parse(drpSelectShop.SelectedValue);
adNot.remarks = txtRemarks.Value;
adNot.paypassword = txtPayPwd.Value;
// adNot.highestgudong = txtHighstGudong.Value;
adNot.housemoney = 0.00m;
adNot.point = 0;
var getUserID = from p in db.UserInfo where p.tel == txtInvitedCode.Value select p.Id;
if (getUserID.Count() > 0)
{
foreach (var item in getUserID)
{
adNot.fenxiaoid = item;
}
}
//20160301 add
adNot.juese = txtJueSe.Value;
//adNot.gudongjibie= txtGuDongJibie.Value ;
//adNot.suozhangufen=txtSuoZhanGuFen.Value ;
// adNot.xiangzhen=txtXiangZhen.Value;
// adNot.xiangcun= txtXiangCun.Value;
//adNot.shangjigudong= hfShangJiGuDong.Value;;
// adNot.shangjizhanzhang = hfShangJiZhanZhang.Value;
adNot.addtime = DateTime.Now;
db.UserInfo.InsertOnSubmit(adNot);
db.SubmitChanges();
}
Response.Redirect("UserinfoManager.aspx?mid=" + Request["mid"]);
}
public void BindShowUpInfo(string strUpid)
{
if (!string.IsNullOrEmpty(strUpid))
{
if (SearchDataClass.IsNumber(strUpid) == true)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
goodstuan getOrderBy = db.goodstuan.Single(x => x.Id == int.Parse(strUpid));
txtTitle.Value = getOrderBy.title;
txtFckContent.Value = SearchDataClass.CheckStr(getOrderBy.content);
txtTimeSelect.Value = Convert.ToDateTime(getOrderBy.starttime).ToString("yyyy/MM/dd") + "-" + Convert.ToDateTime(getOrderBy.endtime).ToString("yyyy/MM/dd");
drpValidate.SelectedValue = getOrderBy.validate.ToString();
drpSetIndex.SelectedValue = getOrderBy.setindex.ToString();
txtQuantily.Value = getOrderBy.quantity.ToString();
txtGoodsPrice.Value = Convert.ToString(getOrderBy.price);
txtGoodsCost.Value = Convert.ToString(getOrderBy.costprice.ToString());
txtWeight.Value = getOrderBy.weight.ToString();
// drpCommunity.SelectedValue = getOrderBy.community.ToString();
//drpShop.SelectedValue = getOrderBy.shopid.ToString();
txtGroupNum.Value = getOrderBy.batch.ToString();
txtSummary.Value = getOrderBy.tuansummary;
txtSummary1.Value = getOrderBy.tuansummary1;
txtSummary2.Value = getOrderBy.tuansummary2;
this.hfDel.Value = getOrderBy.img;
this.HFurl.Value = getOrderBy.img;
this.iShowPhoto.Src = getOrderBy.img == "" ? "assets/images/nophoto.gif" : getOrderBy.img;;
this.hfDel1.Value = getOrderBy.imgtwo;
this.HFurl1.Value = getOrderBy.imgtwo;
this.iShowPhoto1.Src = getOrderBy.imgtwo == "" ? "assets/images/nophoto.gif" : getOrderBy.imgtwo;
this.hfDel2.Value = getOrderBy.groupsortimg;
this.HFurl2.Value = getOrderBy.groupsortimg;
if (!string.IsNullOrEmpty(getOrderBy.groupsortimg))
{
this.iShowPhoto2.Src = getOrderBy.groupsortimg;
}
else
{
this.iShowPhoto2.Src = "assets/images/nophoto.gif";
}
drpGoodsSort.SelectedIndex = getOrderBy.groupsort;
drpSaleGoodsSort.SelectedValue = getOrderBy.selectytsort.ToString();
txtGoodsCode.Value = getOrderBy.goodscode;
txtGetGoodPoint.Value = getOrderBy.getgoodpoint.ToString();
db.SubmitChanges();
}
}
}
}
protected void btnAddRole_Click(object sender, EventArgs e)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
userrole url = new userrole();
url.rolename = txtRoleName.Value.Trim();
url.roledescribe = txtFckContent.Value.Trim();
url.powerid = hfRole.Value.Trim().TrimEnd(',');
url.addTime = DateTime.Now;;
db.userrole.InsertOnSubmit(url);
db.SubmitChanges();
}
Response.Redirect("UserRoleManager.aspx?mid=" + Request["mid"]);
}
protected void btnUpdateGoods_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["upid"]))
{
if (EnshineUnionManager.model.SearchDataClass.IsNumber(Request["upid"]) == true)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
goodspackage upNot = db.goodspackage.Single(x => x.goodsId == int.Parse(Request["upid"]));
upNot.goodstitle = txtTitle.Value.Trim();
upNot.goodscontent = SearchDataClass.CheckStr(txtFckContent.Value);
upNot.goodsvalidate = Convert.ToChar(drpValidate.SelectedValue);
upNot.setindex = Convert.ToChar(drpSetIndex.SelectedValue);
upNot.goodscode = txtGoodsCode.Value;
upNot.goodsprice = Convert.ToDecimal(txtGoodsPrice.Value);
upNot.goodssort = int.Parse(drpGoodsSort.SelectedValue);
if (!string.IsNullOrEmpty(HFurl.Value))
{
upNot.goodsimg = HFurl.Value.Trim();
}
upNot.goodstock = int.Parse(txtStockNum.Value);
upNot.goodsSales = Convert.ToChar(drpSales.SelectedValue);
upNot.goodscost = Convert.ToDecimal(txtGoodsCost.Value);
upNot.ifexchange = Convert.ToChar(drpExchangeGood.SelectedValue);
if (!string.IsNullOrEmpty(txtExchangePoint.Value))
{
upNot.exchangepoint = int.Parse(txtExchangePoint.Value);
}
if (!string.IsNullOrEmpty(txtGetGoodPoint.Value))
{
upNot.getgoodpoint = int.Parse(txtGetGoodPoint.Value);
}
upNot.tichengpoint = ticheng.Value == "" ? "0/20/20/10" : ticheng.Value;
//upNot.goodgoldprice = Convert.ToDecimal(txtGoldPrice.Value);
//upNot.goodsilverprice = Convert.ToDecimal(txtSilverprice.Value);
upNot.ifxiangou = Convert.ToChar(drpXianGou.SelectedValue);
upNot.xiangounumber = txtXianGouNumber.Value == "" ? "0/0/0" : txtXianGouNumber.Value;;
upNot.goodsspec = txtGoodsSpec.Value;
upNot.goodscompany = txtGoodsCompany.Value;
//upNot.iftuangou = Convert.ToChar(drpGroupBy.SelectedValue);
// upNot.expiredate = Convert.ToDateTime(txtExpireDate.Value);
// upNot.selectytsort = Convert.ToChar(drpSaleGoodsSort.SelectedValue);
db.SubmitChanges();
}
}
Response.Redirect("GoodsPackageManager.aspx?mid=" + Request["mid"]);
}
}
protected void btnAddAd_Click(object sender, EventArgs e)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
Advertisement addNot = new Advertisement();
addNot.AdTitle = txtTitle.Value.Trim();
addNot.AdContent = txtFckContent.Value.Trim();
addNot.Company = txtCompany.Value;
addNot.AdImg = HFurl.Value.Trim();
addNot.Addtime = DateTime.Now;
addNot.setindex = Convert.ToChar(drpSetIndex.SelectedValue);
addNot.goodscode = txtGoodsCode.Value;
db.Advertisement.InsertOnSubmit(addNot);
db.SubmitChanges();
}
Response.Redirect("AdManager.aspx?mid=" + Request["mid"]);
}
protected void btnAddNotices_Click(object sender, EventArgs e)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
superadmin addNot = new superadmin();
addNot.name = txtlogname.Value.Trim();
addNot.pass = txtPass.Value;
addNot.truename = txttruename.Value;
addNot.contacttel = txtTel.Value;
addNot.roleid = int.Parse(ddlrole.SelectedValue);
var ifdisable = cbifdisable.Checked == true ? 'Y' : 'N';
addNot.ifdisable = ifdisable;
addNot.addtime = DateTime.Now;
db.superadmin.InsertOnSubmit(addNot);
db.SubmitChanges();
}
Response.Redirect("AdminManager.aspx?mid=" + Request["mid"]);
}
protected void btnAddPlantDoctor_Click(object sender, EventArgs e)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
plantdoctor addNot = new plantdoctor();
addNot.title = txtTitle.Value.Trim();
addNot.content = SearchDataClass.CheckStr(txtFckContent.Value);
addNot.validate = Convert.ToChar(drpValidate.SelectedValue);
addNot.setindex = Convert.ToChar(drpSetIndex.SelectedValue);
addNot.plantdoctorsort = int.Parse(drpPlantDoctorSort.SelectedValue);
addNot.img = HFurl.Value.Trim();
addNot.addtime = DateTime.Now;
db.plantdoctor.InsertOnSubmit(addNot);
db.SubmitChanges();
}
Response.Redirect("PlantDoctorManager.aspx");
}
protected void btnUpdateRole_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["upid"]))
{
if (EnshineUnionManager.model.SearchDataClass.IsNumber(Request["upid"]) == true)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
userrole upurl = db.userrole.Single(x => x.roleid == int.Parse(Request["upid"]));
upurl.rolename = txtRoleName.Value.Trim();
upurl.roledescribe = txtFckContent.Value.Trim();
upurl.powerid = hfRole.Value.Trim().TrimEnd(',');
db.SubmitChanges();
}
}
Response.Redirect("UserRoleManager.aspx?mid=" + Request["mid"]);
}
}
protected void btnUpdateNotices_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["upid"]))
{
if (EnshineUnionManager.model.SearchDataClass.IsNumber(Request["upid"]) == true)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
notices upNot = db.notices.Single(x => x.Id == int.Parse(Request["upid"]));
upNot.title = SearchDataClass.CheckStr(txtTitle.Value.Trim());;
upNot.content = txtFckContent.Value; //SearchDataClass.CheckStr(txtFckContent.Value);
//upNot.validate = Convert.ToChar(drpValidate.SelectedValue);
//upNot.setindex = Convert.ToChar(drpSetIndex.SelectedValue);
upNot.newssort = int.Parse(drpNewsSort.SelectedValue);
if (!string.IsNullOrEmpty(HFurl.Value))
{
upNot.img = HFurl.Value.Trim();
}
if (!string.IsNullOrEmpty(HFurl.Value))
{
upNot.img1 = HFurl1.Value.Trim();
}
if (!string.IsNullOrEmpty(HFurl.Value))
{
upNot.img2 = HFurl2.Value.Trim();
}
upNot.newssource = txtSource.Value.Trim();
upNot.addtime = DateTime.Now;
db.SubmitChanges();
}
}
Response.Redirect("NewsNoticesManager.aspx?mid=" + Request["mid"]);
}
}
protected void btnUpdateNotices_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["upid"]))
{
if (EnshineUnionManager.model.SearchDataClass.IsNumber(Request["upid"]) == true)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
superadmin upNot = db.superadmin.Single(x => x.Id == int.Parse(Request["upid"]));
upNot.name = txtlogname.Value.Trim();
upNot.pass = txtPass.Value;
upNot.truename = txttruename.Value;
upNot.contacttel = txtTel.Value;
upNot.roleid = int.Parse(ddlrole.SelectedValue);
var ifdisable = cbifdisable.Checked == true ? 'Y' : 'N';
upNot.ifdisable = ifdisable;
db.SubmitChanges();
}
}
Response.Redirect("AdminManager.aspx?mid=" + Request["mid"]);
}
}
protected void btnAddGoods_Click(object sender, EventArgs e)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
goodspackage addNot = new goodspackage();
addNot.goodstitle = txtTitle.Value.Trim();
addNot.goodscontent = SearchDataClass.CheckStr(txtFckContent.Value);
addNot.goodsvalidate = Convert.ToChar(drpValidate.SelectedValue);
addNot.setindex = Convert.ToChar(drpSetIndex.SelectedValue);
addNot.goodscode = txtGoodsCode.Value;
addNot.goodsprice = Convert.ToDecimal(txtGoodsPrice.Value);
addNot.goodssort = int.Parse(drpGoodsSort.SelectedValue);
addNot.goodsimg = HFurl.Value.Trim();
addNot.addtime = DateTime.Now;
addNot.goodstock = int.Parse(txtStockNum.Value);
addNot.goodsSales = Convert.ToChar(drpSales.SelectedValue);
addNot.getgoodpoint = txtGetGoodPoint.Value == "" ? 0 : int.Parse(txtGetGoodPoint.Value);
addNot.goodscost = txtGoodsCost.Value == "" ? 0.00m : Convert.ToDecimal(txtGoodsCost.Value);
addNot.ifexchange = Convert.ToChar(drpExchangeGood.SelectedValue);
addNot.exchangepoint = txtExchangePoint.Value == "" ? 0 : int.Parse(txtExchangePoint.Value);
addNot.tichengpoint = ticheng.Value == "" ? "0/20/20/10" : ticheng.Value;
//addNot.goodgoldprice = txtGoldPrice.Value == "" ? 0.00m : Convert.ToDecimal(txtGoldPrice.Value);
//addNot.goodsilverprice = txtSilverprice.Value == "" ? 0.00m : Convert.ToDecimal(txtSilverprice.Value);
addNot.ifxiangou = Convert.ToChar(drpXianGou.SelectedValue);
addNot.xiangounumber = txtXianGouNumber.Value == "" ? "0/0/0" : txtXianGouNumber.Value;
addNot.goodsspec = txtGoodsSpec.Value;
addNot.goodscompany = txtGoodsCompany.Value;
//addNot.iftuangou = Convert.ToChar(drpGroupBy.SelectedValue);
//addNot.expiredate = Convert.ToDateTime(txtExpireDate.Value);
//addNot.selectytsort = Convert.ToChar(drpSaleGoodsSort.SelectedValue);
db.goodspackage.InsertOnSubmit(addNot);
db.SubmitChanges();
}
Response.Redirect("GoodsPackageManager.aspx?mid=" + Request["mid"]);
}
protected void btnAddHuoDong_Click(object sender, EventArgs e)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
HuoDong addNot = new HuoDong();
addNot.huodongTitle = txtTitle.Value.Trim();
addNot.huodongContent = txtFckContent.Value.Trim();
addNot.huodongPeople = txtPeople.Value;
addNot.huodongKeyWord = txtKeyWord.Value;
addNot.huodongDate = txtTimeSelect.Value;
if (!string.IsNullOrEmpty(HFurl.Value))
{
addNot.huodongImg = HFurl.Value.Trim();
}
addNot.huodongActive = 'N';
addNot.addTime = DateTime.Now;
addNot.setindex = Convert.ToChar(drpSetIndex.SelectedValue);
addNot.huodongsort = int.Parse(drpHuoDongSort.SelectedValue);
db.HuoDong.InsertOnSubmit(addNot);
db.SubmitChanges();
}
Response.Redirect("HuoDongManager.aspx?mid=" + Request["mid"]);
}
protected void btnUpPlantDoctorSort_ServerClick(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(hfPlantDoctorSortId.Value))
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
plantdoctorsort updateOK = db.plantdoctorsort.Single(x => x.sortId == Convert.ToInt32(hfPlantDoctorSortId.Value));
updateOK.sortFatherId = int.Parse(drpPlantSort.SelectedValue);
updateOK.sortName = txtPlantDoctorSort.Value;
if (db.plantdoctorsort.Single(x =>
x.sortId == int.Parse(drpPlantSort.SelectedValue)).sortFatherId != int.Parse(drpPlantSort.SelectedValue))
{
updateOK.sortPath = db.plantdoctorsort.Single(x =>
x.sortId == int.Parse(drpPlantSort.SelectedValue)).sortPath + "," + hfPlantDoctorSortId.Value;
}
if (!string.IsNullOrEmpty(HFurl.Value))
{
updateOK.sortImg = HFurl.Value;
}
db.SubmitChanges();
}
}
ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('植保分类修改成功。');window.location.href='PlantDoctorSortManger.aspx';</script>");
}
protected void btnAddUserRecharge_Click(object sender, EventArgs e)
{
//充值成功状态
var result = false;
var chongzhiprice = Convert.ToDecimal(txtRecMoney.Value.Trim());
var chongzhipoint = int.Parse(txtPoint.Value);
if (chongzhiprice != 0.00m)
{
//存放账号剩余金额
decimal shengxiamoney = 0.0m;
//积分
int addpoint = 0;
var recno = DateTime.Now.ToString("yyyyMMddHHmmssffff");
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
try
{
userrecharge addrec = new userrecharge();
addrec.recno = recno; //txtTitle.Value.Trim();
addrec.content = txtFckContent.Value;
addrec.tel = txtRecTel.Value.Trim();
if (hfuserid.Value == "NoData")
{
addrec.validate = 'N';
}
else
{
addrec.validate = 'Y';
addrec.userid = int.Parse(hfuserid.Value);
}
addrec.recmoney = Convert.ToDecimal(txtRecMoney.Value.Trim());
addrec.addtime = DateTime.Now;
db.userrecharge.InsertOnSubmit(addrec);
db.SubmitChanges();
if (chongzhipoint > 0)
{
//积分
pointdetails pointadd = new pointdetails();
pointadd.userid = int.Parse(hfuserid.Value);
pointadd.getpoint = int.Parse(txtPoint.Value);
pointadd.getpointreason = txtFckContent.Value;
pointadd.recno = recno;
pointadd.getpointtime = DateTime.Now;
db.pointdetails.InsertOnSubmit(pointadd);
db.SubmitChanges();
}
result = true;
}
catch (Exception ex)
{
result = false;
}
finally
{
if (result) //成功后更新余额
{
//检索剩余金额+刚充值金额 +积分
using (EnshineUnionDataContext dbup = new EnshineUnionDataContext())
{
//记录充值信息到收入明细中
////moenydetails md = new moenydetails();
////md.moneycode = DateTime.Now.ToString("yyyyMMddHHmmssffff");
////md.money = Convert.ToDecimal(txtRecMoney.Value.Trim());
////md.moneyreason = txtFckContent.Value;
////md.userid = int.Parse(hfuserid.Value);
////md.moneytime = DateTime.Now;
////md.recno = recno;
////db.moenydetails.InsertOnSubmit(md);
////db.SubmitChanges();
var usermoney = dbup.UserInfo.SingleOrDefault(x => x.Id == int.Parse(hfuserid.Value)).housemoney;
var userpoint = dbup.UserInfo.SingleOrDefault(x => x.Id == int.Parse(hfuserid.Value)).point;
UserInfo upinfo = dbup.UserInfo.Single(x => x.Id == int.Parse(hfuserid.Value));
shengxiamoney = Convert.ToDecimal(usermoney == null ? 0.0m : usermoney) + Convert.ToDecimal(txtRecMoney.Value.Trim());
upinfo.housemoney = shengxiamoney;
upinfo.usertype = drpHuiYuanJIbie.SelectedIndex;
if (userpoint == null)
{
addpoint = 0;
}
else
{
addpoint = int.Parse(txtPoint.Value);
}
upinfo.point = addpoint;
dbup.SubmitChanges();
}
}
}
}
spMessage.InnerHtml = "手机号为：" + txtRecTel.Value + "充值成功，充值金额为" + txtRecMoney.Value + "元，账户余额为：" + shengxiamoney + "元，账户积分为：" + addpoint + "分,请等待5秒系统自动会自动跳转。<script>setTimeout(function(){window.location.href='UserRecharge.aspx';},5000);</script>";
txtFckContent.Value = ""; txtRecTel.Value = ""; txtRecMoney.Value = "";
hfuserid.Value = ""; txtPoint.Value = "";
}
else
{
ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alert('充值金额不能为0');</script>");
}
}
protected void btnUpdateUserInfo_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["upid"]))
{
if (EnshineUnionManager.model.SearchDataClass.IsNumber(Request["upid"]) == true)
{
using (EnshineUnionDataContext db = new EnshineUnionDataContext())
{
UserInfo upNot = db.UserInfo.Single(x => x.Id == int.Parse(Request["upid"]));
upNot.nickname = txtNickName.Value.Trim();
upNot.name = txtName.Value.Trim();
upNot.tel = txtTel.Value.Trim();
upNot.email = txtEmail.Value.Trim();
upNot.sex = Convert.ToChar(drpSex.SelectedValue);
upNot.address = txtAddress.Value.Trim();
//20161031
//upNot.areacity = seachprov.SelectedItem.Text + " " + seachcity.SelectedItem.Text + " " +
//seachdistrict.SelectedItem.Text;//txtAreacity.Value.Trim();
upNot.areacity = seachprov.SelectedItem.Text + "," + seachcity.SelectedItem.Text + "," +
seachdistrict.SelectedItem.Text;
upNot.pass = txtPass.Value.Trim();
//upNot.cardno = txtCardNo.Value;
//upNot.plantnum = txtPlantNum.Value;
//upNot.homenum = txtHomeNum.Value;
upNot.invitedcode = txtInvitedCode.Value;
// upNot.homeinfo = txtHomeInfo.Value;
// upNot.plantsort = txtPlantSort.Value;
if (!string.IsNullOrEmpty(HFurl.Value))
{
upNot.cardimg = HFurl.Value;
}
upNot.shopset = int.Parse(drpSelectShop.SelectedValue);
upNot.remarks = txtRemarks.Value;
upNot.paypassword = txtPayPwd.Value;
// upNot.highestgudong = txtHighstGudong.Value;
var getUserID = from p in db.UserInfo where p.tel == txtInvitedCode.Value select p.Id;
if (getUserID.Count() > 0)
{
foreach (var item in getUserID)
{
upNot.fenxiaoid = item;
}
}
//20160301 add
upNot.juese = txtJueSe.Value;
// upNot.gudongjibie = txtGuDongJibie.Value;
upNot.usertype = drpHuiYuanJIbie.SelectedIndex;
// upNot.suozhangufen = txtSuoZhanGuFen.Value;
// upNot.xiangzhen = txtXiangZhen.Value;
// upNot.xiangcun = txtXiangCun.Value;
// upNot.shangjigudong = hfShangJiGuDong.Value; ;
// upNot.shangjizhanzhang = hfShangJiZhanZhang.Value;
db.SubmitChanges();
}
}
Response.Redirect("UserinfoManager.aspx?mid=" + Request["mid"]);
}
}
