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