private void InitPage() { ConfigModel model = ConfigSetBLL.GetConfig(Convert.ToInt32(ddlExpectNum.SelectedValue)); if (model == null) { Response.Redirect("ConfigParam.aspx", true); } this.txtPara1.Text = model.Para1.ToString(); this.txtPara2.Text = model.Para2.ToString(); this.txtPara3.Text = model.Para3.ToString(); this.txtPara4.Text = model.Para4.ToString(); this.txtPara5.Text = model.Para5.ToString(); this.txtPara6.Text = model.Para6.ToString(); this.txtPara7.Text = model.Para7.ToString(); this.txtPara8.Text = model.Para8.ToString(); this.txtPara9.Text = model.Para9.ToString(); this.txtPara10.Text = model.Para10.ToString(); this.txtPara11.Text = model.Para11.ToString(); this.txtPara12.Text = model.Para12.ToString(); this.txtPara13.Text = model.Para13.ToString(); this.txtPara14.Text = model.Para14.ToString(); this.txtPara15.Text = model.Para15.ToString(); this.txtPara16.Text = model.Para16.ToString(); this.txtPara17.Text = model.Para17.ToString(); this.txtPara18.Text = model.Para18.ToString(); this.txtPara19.Text = model.Para19.ToString(); this.txtPara19.Text = model.Para19.ToString(); this.txtPara20.Text = model.Para20.ToString(); this.txtPara21.Text = model.Para21.ToString(); this.txtPara22.Text = model.Para22.ToString(); this.txtPara23.Text = model.Para23.ToString(); this.txtPara24.Text = model.Para24.ToString(); this.txtPara25.Text = model.Para25.ToString(); this.txtPara26.Text = model.Para26.ToString(); this.txtPara27.Text = model.Para27.ToString(); this.txtPara28.Text = model.Para28.ToString(); this.txtPara29.Text = model.Para29.ToString(); //SqlDataReader sdr = DAL.DBHelper.ExecuteReader("Select Top 1 * From jykz ORDER BY ID"); //while (sdr.Read()) //{ // this.txtPara20.Text = sdr["mrMinjf"].ToString().Trim(); // this.txtPara21.Text = sdr["mrMaxjf"].ToString(); // this.txtPara22.Text = sdr["mcMinjf"].ToString(); // this.txtPara23.Text = sdr["mcMaxjf"].ToString(); // this.txtPara24.Text = sdr["Mrzs"].ToString(); //} //sdr.Close(); //sdr.Dispose(); }
private void InitPage() { ConfigModel model = ConfigSetBLL.GetConfig2(Convert.ToInt32(ddlExpectNum.SelectedValue)); if (model == null) { Response.Redirect("ConfigParam.aspx", true); } this.txtPara1.Text = model.Para1.ToString(); this.txtPara2.Text = model.Para2.ToString(); this.txtPara3.Text = model.Para3.ToString(); this.txtPara4.Text = model.Para4.ToString(); this.txtPara5.Text = model.Para5.ToString(); this.txtPara6.Text = model.Para6.ToString(); this.txtPara7.Text = model.Para7.ToString(); this.txtPara8.Text = model.Para8.ToString(); this.txtPara9.Text = model.Para9.ToString(); this.txtPara10.Text = model.Para10.ToString(); this.txtPara11.Text = model.Para11.ToString(); this.txtPara12.Text = model.Para12.ToString(); this.txtPara13.Text = model.Para13.ToString(); this.txtPara14.Text = model.Para14.ToString(); this.txtPara15.Text = model.Para15.ToString(); this.txtPara16.Text = model.Para16.ToString(); this.txtPara17.Text = model.Para17.ToString(); this.txtPara18.Text = model.Para18.ToString(); this.txtPara19.Text = model.Para19.ToString(); this.txtPara20.Text = model.Para20.ToString(); this.txtPara21.Text = model.Para21.ToString(); this.txtPara22.Text = model.Para22.ToString(); this.txtPara23.Text = model.Para23.ToString(); this.txtPara24.Text = model.Para24.ToString(); this.txtPara25.Text = model.Para25.ToString(); this.txtPara26.Text = model.Para26.ToString(); this.txtPara27.Text = model.Para27.ToString(); this.txtPara28.Text = model.Para28.ToString(); this.txtPara29.Text = model.Para29.ToString(); }
protected void btnEdit_Click(object sender, EventArgs e) { if (ViewState["ExpectNum"] == null || (int)ViewState["ExpectNum"] < 0 || (int)ViewState["ExpectNum"] > CommonDataBLL.GetMaxqishu()) { return; } ConfigModel model = null; try { model = new ConfigModel(); model.ExpectNum = (int)ViewState["ExpectNum"]; model.Para1 = float.Parse(this.txtPara1.Text); model.Para2 = float.Parse(this.txtPara2.Text); model.Para3 = float.Parse(this.txtPara3.Text); model.Para4 = float.Parse(this.txtPara4.Text); model.Para5 = float.Parse(this.txtPara5.Text); model.Para6 = float.Parse(this.txtPara6.Text); model.Para7 = float.Parse(this.txtPara7.Text); model.Para8 = float.Parse(this.txtPara8.Text); model.Para9 = float.Parse(this.txtPara9.Text); model.Para10 = float.Parse(this.txtPara10.Text); model.Para11 = float.Parse(this.txtPara11.Text); model.Para12 = float.Parse(this.txtPara12.Text); model.Para13 = float.Parse(this.txtPara13.Text); model.Para14 = float.Parse(this.txtPara14.Text); model.Para15 = float.Parse(this.txtPara15.Text); model.Para16 = float.Parse(this.txtPara16.Text); model.Para17 = float.Parse(this.txtPara17.Text); model.Para18 = float.Parse(this.txtPara18.Text); model.Para19 = float.Parse(this.txtPara19.Text); model.Para20 = float.Parse(this.txtPara20.Text); model.Para21 = double.Parse(this.txtPara21.Text); model.Para22 = double.Parse(this.txtPara22.Text); model.Para23 = double.Parse(this.txtPara23.Text); model.Para24 = double.Parse(this.txtPara24.Text); model.Para25 = double.Parse(this.txtPara25.Text); model.Para26 = double.Parse(this.txtPara26.Text); model.Para27 = double.Parse(this.txtPara27.Text); model.Para28 = double.Parse(this.txtPara28.Text); model.Para29 = double.Parse(this.txtPara29.Text); } catch (FormatException) { ScriptHelper.SetAlert(Page, GetTran("000969", "请输入数值")); InitPage(); return; } if (CheckNum(model.Para1) && CheckNum(model.Para2) && CheckNum(model.Para3) && CheckNum(model.Para4) && CheckNum(model.Para5) && CheckNum(model.Para6) && CheckNum(model.Para7) && CheckNum(model.Para8) && CheckNum(model.Para9) && CheckNum(model.Para10) && CheckNum(model.Para11) && CheckNum(model.Para12) && CheckNum(model.Para13) && CheckNum(model.Para14) && CheckNum(model.Para15) && CheckNum(model.Para16) && CheckNum(model.Para17) && CheckNum(model.Para18) && CheckNum(model.Para1) && CheckNum(model.Para19) && CheckNum(model.Para20)) { } else { ScriptHelper.SetAlert(Page, GetTran("001274", "请输入正数")); InitPage(); return; } ChangeLogs cl = new ChangeLogs("tkconfig", "ExpectNum"); cl.AddRecord((int)ViewState["ExpectNum"]); int n = ConfigSetBLL.UpdateConfig2(model); if (n == 1) { cl.ModifiedIntoLogs(ChangeCategory.company16, model.ExpectNum.ToString() + "期", ENUM_USERTYPE.objecttype3); ScriptHelper.SetAlert(Page, GetTran("000001", "修改成功") + "。"); } else { ScriptHelper.SetAlert(Page, GetTran("000002", "修改失败") + "。"); } InitPage(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { loadff(); //Session["page"] = "first.aspx"; if (Session["page"] == null && Session["page"] == "first.aspx") { Response.Redirect("first.aspx"); } else if (Session["page"] != null && (Session["page"].ToString() != "first.aspx")) { if (Session["page"].ToString().ToLower() == "registermember.aspx") { Response.Redirect("../RegisterMember/" + Session["page"].ToString()); } else { Response.Redirect(Session["page"].ToString()); } } jfdtx = Permissions.GetPermissions(EnumCompanyPermission.AccountFlowManagerWYJF); //else //{ // Response.Redirect(Session["page"].ToString()); //} } //查询今天未审核订单 String data = DateTime.Now.ToString("yyyy-MM-dd"); String sql = "select COUNT(*) from [MemberInfo]as A,MemberOrder as B where B.Number=A.Number and B.DefrayState = 0 and B.OrderDate Between '" + data + " 00:00:00' And '" + data + " 23:59:59'"; int count = (int)DAL.DBHelper.ExecuteScalar(sql); Permissions.ComRedirect(Page, Permissions.redirUrl); //this.b1.Attributes.Remove("onload"); //if (!this.IsPostBack) //{ SqlParameter[] parm0 = { new SqlParameter("@manageid", SqlDbType.VarChar, 50) }; parm0[0].Value = Session["Company"].ToString(); var configvalue = GetConfig(); double mubimax = 0; double mubiuse = 0; if (configvalue == null) { mubimax = 0; // labmubimax.Text = "石斛积分初始发行量 0"; } else { mubimax = configvalue.Para15; //labmubimax.Text = "石斛积分初始发行量 " + " <font color='red'><strong>" + configvalue.Para15 + "</strong></font> "; } ConfigModel model = ConfigSetBLL.GetConfig(CommonDataBLL.GetMaxqishu()); string mubisql = @"select isnull(SUM(InvestJB), 0) as InvestJB from MemberOrder where ordertype=" + 31; // string jjtj = "select isnull(SUM(AwardIn), 0) as AwardIn from memberinfo"; var dtvalue = DBHelper.ExecuteDataTable(mubisql); //var jjvalue = DBHelper.ExecuteDataTable(jjtj); //mbfd.Text = model.Para16.ToString(); //csmb.Text = model.Para15.ToString(); if (dtvalue.Rows.Count > 0) { mubiuse = Convert.ToDouble(dtvalue.Rows[0]["InvestJB"].ToString()); shyfx.Text = dtvalue.Rows[0]["InvestJB"].ToString(); } else { mubiuse = 0; shyfx.Text = "0"; } //if (jjvalue.Rows.Count > 0) //{ // labyjzj.Text = "业绩奖总计 " + " <font color='red'><strong>" + jjvalue.Rows[0]["AwardIn"].ToString() + "</strong></font> "; // myjzjb.Text = jjvalue.Rows[0]["AwardIn"].ToString(); //} //else { // labyjzj.Text = "业绩奖总计 0"; //} string sqls = "select SUM(happenmoney) as zsf from MemberAccount where Direction=0 and SfType=1 and KmType=29"; DataTable dtt = DAL.DBHelper.ExecuteDataTable(sqls); foreach (DataRow item in dtt.Rows) { // zsf.Text = "积分释放总额:" + " <font color='red'><strong>" + item["zsf"].ToString() + "</strong></font> "; } DataTable dt = DBHelper.ExecuteDataTable("getcompanydata", parm0, CommandType.StoredProcedure); jrrs.Text = dt.Rows[0][2].ToString(); //zcrs.Text = dt.Rows[0]["mem_count"].ToString(); //jtsf.Text = dt.Rows[0]["jtyj"].ToString(); //dtsf.Text = dt.Rows[0]["dtyj"].ToString(); //zrjt.Text = dt.Rows[0]["ztjtyj"].ToString(); //zrdt.Text = dt.Rows[0]["ztdtyj"].ToString(); //jfzsf.Text = (Convert.ToInt32(dt.Rows[0]["jtyj"]) + Convert.ToInt32(dt.Rows[0]["dtyj"])).ToString(); //zrzsf.Text = (Convert.ToInt32(dt.Rows[0]["ztjtyj"]) + Convert.ToInt32(dt.Rows[0]["ztdtyj"])).ToString(); //hyjf.Text = dt.Rows[0]["schy"].ToString(); //double jjfxsr=Convert.ToDouble(dt.Rows[0]["jjfx"]); //jjfx.Text = jjfxsr.ToString("0.0000"); //DataTable dtss = DAL.DBHelper.ExecuteDataTable("select top 1 * from DayPrice order by NowPrice desc"); //if (dtss != null && dtss.Rows.Count > 0) //{ // shjg.Text = dtss.Rows[0]["NowPrice"].ToString(); // zzl.Text = dtss.Rows[0]["Addrate"].ToString(); //} if (dt.Rows[0][0].ToString() == "0") { this.labgonggao.Text = GetTran("000130", "今天没有发布新公告!"); } else { this.labgonggao.Text = "<a href='ManageQueryGongGao.aspx?dd=" + dt.Rows[0][10].ToString() + "'>" + GetTran("000141", "今天有") + " <font color='red'><strong>" + dt.Rows[0][0].ToString() + "</strong></font> " + GetTran("000147", "条新公告") + "!</a>"; } if (dt.Rows[0][5].ToString() == "0") { this.labmembermoney.Text = GetTran("000536", "当前没有要审核的店铺退货!"); } else { this.labmembermoney.Text = "<a href='RefundmentOrderBrowse.aspx'>" + GetTran("000152", "当前有") + " <font color='red'><strong>" + dt.Rows[0][5].ToString() + "</strong></font> " + GetTran("000540", "笔需要审核的店铺退货") + "!</a>"; } if (dt.Rows[0][1].ToString() == "0") { this.labmail.Text = GetTran("000159", "当前没有未阅读邮件!"); } else { this.labmail.Text = "<a href='ManageMessage_Recive.aspx?type=1'>" + GetTran("000152", "当前有") + " <font color='red'><strong>" + dt.Rows[0][1].ToString() + "</strong></font> " + GetTran("000160", "封新邮件") + "!</a>"; } if (dt.Rows[0][6].ToString() == "0") { this.labstore.Text = GetTran("000544", "当前没有店铺未支付的订单!"); } else { this.labstore.Text = "<a href='OrderPayment.aspx?type=1'>" + GetTran("000152", "当前有") + " <font color='red'><strong>" + dt.Rows[0][6].ToString() + "</strong></font> " + GetTran("000548", "笔店铺未支付的订单") + "!</a>"; } if (dt.Rows[0][2].ToString() == "0") { this.labmemberregister.Text = GetTran("000165", "今日没有新注册会员!"); } else { this.labmemberregister.Text = "<a href='DisplayMemberInfo.aspx?dd=" + dt.Rows[0][10].ToString() + "'>" + GetTran("000141", "今日有") + " <font color='red'><strong>" + dt.Rows[0][2].ToString() + "</strong></font> " + GetTran("000167", "个新注册会员") + "!</a>"; } if (dt.Rows[0][7].ToString() == "0") { this.labordersent.Text = GetTran("000551", "现在没有公司未发货订单!"); } else { this.labordersent.Text = "<a href='CompanyConsign.aspx'>" + GetTran("000152", "当前有") + " <font color='red'><strong>" + dt.Rows[0][7].ToString() + "</strong></font> " + GetTran("000553", "条公司未发货订单") + "!</a>"; } if (dt.Rows[0][3].ToString() == "0") { this.labstoreaudting.Text = GetTran("000574", "现在没有要审核的店铺!"); } else { this.labstoreaudting.Text = "<a href='AuditingStoreRegister.aspx'>" + GetTran("000152", "当前有") + " <font color='red'><strong>" + dt.Rows[0][3].ToString() + "</strong></font> " + GetTran("000575", "家需要审核的店铺") + "!</a>"; } if (dt.Rows[0][8].ToString() == "0") { this.labmemberaudting.Text = GetTran("000577", "您今日没有要审核的会员报单!"); } else { //((Int32)dt.Rows[0][8] - 1).ToString() this.labmemberaudting.Text = "<a href='BrowseMemberOrders.aspx?dd=1'>" + GetTran("000152", "当前有") + " <font color='red'><strong>" + dt.Rows[0][8].ToString() + "</strong></font> " + GetTran("000582", "笔需要审核的会员报单") + "!</a>"; } if (dt.Rows[0][4].ToString() == "0") { this.labstoremoney.Text = GetTran("007589", "现在没有要审核的汇款!"); } else { this.labstoremoney.Text = "<a href='DoSeecan.aspx'>" + GetTran("000152", "当前有") + " <font color='red'><strong>" + dt.Rows[0][4].ToString() + "</strong></font> " + GetTran("007596", "笔需要审核的汇款") + "!</a>"; } if (dt.Rows[0][9].ToString() == "0") { this.labproduct.Text = GetTran("000590", "现在没有预警的产品!"); } else { this.labproduct.Text = "<a href='ProductAlert.aspx'>" + GetTran("000152", "当前有") + " <font color='red'><strong>" + dt.Rows[0][9].ToString() + "</strong></font> " + GetTran("000596", "个预警的产品") + "</a>!"; } if (dt.Rows[0]["Auti"].ToString() == "0") { this.Label1.Text = GetTran("007593", "现在没有未审核提现申请!"); } else { this.Label1.Text = "<a href='AuditWithdraw.aspx'>" + GetTran("000152", "当前有") + " <font color='red'><strong>" + dt.Rows[0]["Auti"].ToString() + "</strong></font> " + GetTran("000000", "条未审核提现申请") + "</a>!"; } if (dt.Rows[0]["Singledispute"].ToString() == "0") { this.labdispute.Text = GetTran("008241", "现在没有未处理的纠纷单!"); } else { this.labdispute.Text = "<a href='DisputeSheet.aspx'>" + GetTran("000152", "当前有") + " <font color='red'><strong>" + dt.Rows[0]["Singledispute"].ToString() + "</strong></font> " + GetTran("000000", "条未处理的纠纷单") + "</a>!"; } //删除超市报单 CommonDataBLL.DelOrderByState(); if (getdisCount() == 0) { Litw.Text = "当前没有需要处理的纠纷单"; } else { // Litw.Text=" 您当前有"+ getdisCount() +"条纠纷单未处理,请及时处理"; } Label2.Text = "<a href='Billoutorder.aspx'>当前有 <font color='red'><strong>" + DBHelper.ExecuteScalar("select COUNT(0) from StoreOrder where SendWay=0 and IsCheckOut='Y' and IsGeneOutBill='N'") + "</strong></font> 条服务机构要货订单</a>"; //} }
protected void btnEdit_Click(object sender, EventArgs e) { ConfigModel model = null; //decimal mrmin=300; //decimal mrmax=30000; //decimal mcmin=300; //decimal mcmax=30000; //decimal mrzs = 0.5m; try { model = new ConfigModel(); model.ExpectNum = (int)ViewState["ExpectNum"]; model.Para1 = double.Parse(this.txtPara1.Text); model.Para2 = double.Parse(this.txtPara2.Text); model.Para3 = double.Parse(this.txtPara3.Text); model.Para4 = double.Parse(this.txtPara4.Text); model.Para5 = double.Parse(this.txtPara5.Text); model.Para6 = double.Parse(this.txtPara6.Text); model.Para7 = double.Parse(this.txtPara7.Text); model.Para8 = double.Parse(this.txtPara8.Text); model.Para9 = double.Parse(this.txtPara9.Text); model.Para10 = double.Parse(this.txtPara10.Text); model.Para11 = double.Parse(this.txtPara11.Text); model.Para12 = double.Parse(this.txtPara12.Text); model.Para13 = double.Parse(this.txtPara13.Text); model.Para14 = double.Parse(this.txtPara14.Text); model.Para15 = double.Parse(this.txtPara15.Text); model.Para16 = double.Parse(this.txtPara16.Text); model.Para17 = double.Parse(this.txtPara17.Text); model.Para18 = double.Parse(this.txtPara18.Text); model.Para19 = double.Parse(this.txtPara19.Text); model.Para20 = double.Parse(this.txtPara20.Text); model.Para21 = double.Parse(this.txtPara21.Text); model.Para22 = double.Parse(this.txtPara22.Text); model.Para23 = double.Parse(this.txtPara23.Text); model.Para24 = double.Parse(this.txtPara24.Text); model.Para25 = double.Parse(this.txtPara25.Text); model.Para26 = double.Parse(this.txtPara26.Text); model.Para27 = double.Parse(this.txtPara27.Text); model.Para28 = double.Parse(this.txtPara28.Text); model.Para29 = double.Parse(this.txtPara29.Text); } catch (FormatException) { ScriptHelper.SetAlert(Page, GetTran("000969", "请输入数值")); InitPage(); return; } if (CheckNum(model.Para1) && CheckNum(model.Para2) && CheckNum(model.Para3) && CheckNum(model.Para4) && CheckNum(model.Para5) && CheckNum(model.Para6) && CheckNum(model.Para7) && CheckNum(model.Para8) && CheckNum(model.Para9) && CheckNum(model.Para10) && CheckNum(model.Para11) && CheckNum(model.Para12) && CheckNum(model.Para13) && CheckNum(model.Para14) && CheckNum(model.Para15) && CheckNum(model.Para16) && CheckNum(model.Para17) && CheckNum(model.Para18) && CheckNum(model.Para19)) { } else { ScriptHelper.SetAlert(Page, GetTran("001274", "请输入正数")); InitPage(); return; } ChangeLogs cl = new ChangeLogs("config", "ExpectNum"); cl.AddRecord((int)ViewState["ExpectNum"]); int n = ConfigSetBLL.UpdateConfig(model); //SqlParameter[] paras = new SqlParameter[]{ // new SqlParameter("@Para1",mrmin), // new SqlParameter("@Para2",mrmax), // new SqlParameter("@Para3",mcmin), // new SqlParameter("@Para4",mcmax), // new SqlParameter("@Para5",mrzs), // }; //string sql = @"UPDATE jykz SET mrMinjf =@Para1,mrMaxjf=@Para2,mcMinjf=@Para3,mcMaxjf=@Para4,Mrzs=@Para5"; //int m = DBHelper.ExecuteNonQuery(sql, paras, CommandType.Text); if (n == 1) { cl.ModifiedIntoLogs(ChangeCategory.company15, GetTran("000156", "第") + model.ExpectNum.ToString() + GetTran("000157", "期"), ENUM_USERTYPE.objecttype3); ScriptHelper.SetAlert(Page, GetTran("000001", "修改成功")); } else { ScriptHelper.SetAlert(Page, GetTran("000002", "修改失败") + "。"); } InitPage(); }