protected void Page_Load(object sender, EventArgs e)
{
string hid = Req.GetForm("hid");
if (hid == "1")
{
string cmd = Req.GetForm("cmd");
if (cmd == "reg")
{
Reg();
}
Response.Write(msgAjax.ReturnMessage);
Response.End();
}
if (!this.IsPostBack)
{
url = Req.GetQueryString("url");
if (url.Length == 0)
{
url = Req.GetUrlReferrer("/");
}
url = Server.UrlEncode(url);//新加
}
}
public void ProcessRequest(HttpContext context)
{
string t;
string key;
t = Req.GetForm("t");
key = Req.GetForm("key");
switch (t)
{
case "remove_all":
DbCache.GetInstance.RemoveCacheAll();
context.Response.Write("remove_all");
break;
case "remove_regex":
DbCache.GetInstance.RemoveCacheRegex(key);
context.Response.Write("remove_regex");
break;
case "remove":
DbCache.GetInstance.RemoveCache(key);
context.Response.Write("remove");
break;
default:
context.Response.Write("no");
break;
}
context.Response.Write("end");
}
private void Ord_QX()
{
string sStatusCancelRemark = Server.HtmlEncode(Req.GetForm("content").Trim());
if (sStatusCancelRemark.Length == 0 || sStatusCancelRemark.Length > 600)
{
msgAjax.Error("请输入备注，不超过600字");
return;
}
string sql = "update Ord_Info set Status=@Status,StatusCancelRemark=@StatusCancelRemark where OrdSN=" + id + " and FK_User="******" and Status=10 and getdate()<dateadd(dd,0,convert(varchar(10),ToMinTime,120))";
//凌晨时间
DateTime lc = DateTime.Parse(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd"));
IDataParameter[] dp =
{
DbHelp.Def.AddParam("@Status", 21),
DbHelp.Def.AddParam("@StatusCancelRemark", sStatusCancelRemark),
DbHelp.Def.AddParam("@AllowTime", lc),
};
if (DbHelp.Update(sql, dp) > 0)
{
msgAjax.Success("1");
return;
}
else
{
msgAjax.Error("提交失败");
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (User_InfoL.IsTeam(LoginInfo.UserIdentity))
{
Response.Redirect("userInfoEdit_team.aspx");
}
userID = LoginInfo.UserID;
string hid = Req.GetForm("hid");
if (hid == "1")
{
string cmd = Req.GetForm("cmd");
switch (cmd)
{
case "edit":
EditInfo();
break;
}
Response.Write(msgAjax.ReturnMessage);
Response.End();
}
if (!this.IsPostBack)
{
LL();
}
}
/// <summary>
/// 删除多条(包括删除文件) 复选框名为IsSel
/// </summary>
/// <param name="pTableName">表名</param>
/// <param name="pPKName">主键字段名(根据此字段删除记录)</param>
/// <param name="pDeleteFields">文件字段名 一条记录需要删除多个文件 用字段名并逗号隔开 如 PicS,PicB</param>
/// <param name="pPathFormat">文件相对路径 如 /upload_file/pic/ 必需以/开始 以/结束</param>
public static int DeleteMore(string pTableName, string pPKName, string pDeleteFields, string pPathFormat)
{
IMessage MessageG = new MessageGeneral();
string[] aSel = pDeleteFields.Split(',');
int aSelN = aSel.Length;
string sArrStr = Req.GetForm("IsSel");
if (!Fn.IsIntArrBool(sArrStr))
{
MessageG.Error("请选择要删除的记录.");
}
string sSQL = "select " + pDeleteFields + " from " + pTableName + " where " + pPKName + " in(" + sArrStr + ")";
DataTable dt = DbHelp.GetDataTable(sSQL);
foreach (DataRow drw in dt.Rows)
{
foreach (string s in aSel)
{
WZ.Common.OperationFile.FileCommon.Delete(string.Format(pPathFormat, drw[s]));
}
}
sSQL = "delete from " + pTableName + " where " + pPKName + " in(" + sArrStr + ")";
return(DbHelp.Update(sSQL));
//HttpContext.Current.Response.Redirect(HttpContext.Current.Request.Url.ToString());
}
public Dictionary <string, string> ValidatorData()
{
string sAccount = Req.GetForm("cAccount");
string sPartner = Req.GetForm("cPartner");
string sKey = Req.GetForm("cKey");
string sMsg = string.Empty;
if (sAccount.Length == 0)
{
sMsg = "请输入支付宝账号;";
}
if (sPartner.Length == 0)
{
sMsg += "请输入合作伙伴id;";
}
if (sKey.Length == 0)
{
sMsg += "请输入交易安全校验码;";
}
new MessageGeneral().Error(sMsg);
Dictionary <string, string> d = new Dictionary <string, string>();
d.Add("Account", sAccount);
d.Add("Partner", sPartner);
d.Add("Key", sKey);
return(d);
}
protected void Page_Load(object sender, EventArgs e)
{
string sql = "select top 1 QuSN,ShowType,QuName from Questionnaire where IsOpen=1 order by Taxis asc,QuSN desc";
DataTable dt = DbHelp.GetDataTable(sql);
if (dt.Rows.Count == 0)
{
return;
}
QuSN = dt.Rows[0]["QuSN"].ToString();
QuName = dt.Rows[0]["QuName"].ToString();
ShowType = dt.Rows[0]["ShowType"].ToString();
string hid = Req.GetForm("hid");
if (hid == "1")
{
string cmd = Req.GetForm("cmd");
switch (cmd)
{
case "ajax_page_msg":
MsgList_ajaxPage();
break;
}
Response.End();
}
if (!Page.IsPostBack)
{
LL();
}
}
private void editNum()
{
int id = Fn.IsInt(Req.GetForm("id"), 0);
double num = Fn.IsDouble(Req.GetForm("num"), 0);
if (num <= 0.01)
{
msgAjax.Error("不能小于0.01");
return;
}
if (id > 0)
{
string s = User_Cart.EditNum(LoginInfo.UserID, id, num);
switch (s)
{
case "0":
msgAjax.Error("修改失败");
break;
case "1":
refresh();
msgAjax.Success("1");
break;
}
}
}
private void MsgList()
{
int cur_pageIndex = Fn.IsInt(Req.GetForm("ajax_page"), 1);
string sqlSelect, sqlFrom, sqlWhere, sqlOrder, pkName;
sqlSelect = "select Detail,N.AddDate as AddDate,UserName";
sqlFrom = " from Questionnaire_Msg as N left join User_Info as U on N.FK_User=U.UserSN";
sqlWhere = " where Purview=1 and FK_Questionnaire=" + QuSN;
sqlOrder = " order by N.AddDate desc";
pkName = "MsgSN";
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
pv.SQLRead = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
pv.SQL = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;
Paging pg = new Paging(pv, new PagingUrlVar(30, cur_pageIndex));//页记录 30
pg.load();
Bind.BGRepeater(pg.GetDataTable(), this.rpList);
this.ucPS1.f = pg;
this.ucPS1.cs = "javascript:ajaxPage('ajax_page_msg',{0});";
lNum = pg.um.records_count.ToString();
}
public Dictionary <string, string> ValidatorData()
{
string sYhRealName = Req.GetForm("cYhRealName"); //银行卡姓名
string sYhNumber = Req.GetForm("cYhNumber"); //银行卡号
string sYhArea = Req.GetForm("cYhArea"); //银行开户地
string sMsg = string.Empty;
if (sYhRealName.Length == 0)
{
sMsg += "请输入银行卡姓名;";
}
if (sYhNumber.Length == 0)
{
sMsg += "请输入银行卡号;";
}
new MessageGeneral().Error(sMsg);
Dictionary <string, string> d = new Dictionary <string, string>();
d.Add("YhRealName", sYhRealName);
d.Add("YhNumber", sYhNumber);
d.Add("YhArea", sYhArea);
return(d);
}
protected void Page_Load(object sender, EventArgs e)
{
int hid = Fn.IsInt(Req.GetForm("hid"), 0);
if (hid > 0)
{
string cmd = Req.GetForm("cmd");
switch (cmd)
{
case "clearAll": //清空
deleteALL();
break;
case "del":
delete();
break;
case "editNum":
editNum();
break;
}
Response.Write(msgAjax.ReturnMessage);
Response.End();
}
if (!this.IsPostBack)
{
LL();
}
}
//private IMessage msgAjax = new MessageAjax();
protected void Page_Load(object sender, EventArgs e)
{
id = Req.GetID();
UserID = LoginInfo.UserID;
cp = new ClassPath(PubData.GetDataTable("pub_area"), acp);
string hid = Req.GetForm("hid");
if (hid == "1")
{
string cmd = Req.GetForm("cmd");
switch (cmd)
{
case "save":
cb_ok();
break;
case "del":
cb_delete();
break;
}
Response.Write(msgAjax.ReturnMessage);
Response.End();
}
if (!this.IsPostBack)
{
LL();
BGList();
}
}
protected void Page_Load(object sender, EventArgs e)
{
id = Req.GetID();
string hid = Req.GetForm("hid");
if (hid == "1")
{
string cmd = Req.GetForm("cmd");
switch (cmd)
{
case "ajax_page_eval":
EvaluateList_ajaxPage();
break;
case "ajax_page_msg":
MsgList_ajaxPage();
break;
}
Response.End();
}
if (!this.IsPostBack)
{
LL();
}
}
private void del()
{
int id = Fn.IsInt(Req.GetForm("id"), 0);
string sql = "delete from User_Letter where LetSN=" + id + " and FK_User_To=" + LoginInfo.UserID;
DbHelp.Update(sql);
msgAjax.Success("删除成功");
}
private void Add()
{
if (banH.IsBan())
{
msgAjax.Error("ban");
return;
}
int userID = 0;
if (LoginInfo.IsLogin())
{
}
else
{
userID = LoginInfo.UserID;
}
string sDetail = Server.HtmlEncode(Req.GetForm("content"));
if (sDetail.Length == 0)
{
msgAjax.Error("input");
return;
}
if (sDetail.Length == 0 || sDetail.Length > 600)
{
msgAjax.Error("nobuy");
return;
}
News_MsgM mod = new News_MsgM();
mod.FK_User = userID;
mod.FK_News = id;
mod.Detail = sDetail;
mod.Purview = 1;
mod.IP = Request.UserHostAddress;
NewsMsg_TransM tmod = new NewsMsg_TransM();
tmod.mod = mod;
DbHelp.ExecuteTrans(new DbHelpParam(), this.NewsEval_Trans, tmod);
if (tmod.returnValue == "1")
{
msgAjax.Success("1");
}
else
{
msgAjax.Error(tmod.returnValue);
}
}
protected void Page_Load(object sender, EventArgs e)
{
Response.Write("123");
Response.Write("<br>" + Request.QueryString["aa"]);
if (Req.GetForm("hid") == "1")
{
Response.Write("456");
Response.Write(Request.Form["aa"]);
}
}
private void Add()
{
if (banH.IsBan())
{
msgAjax.Error("ban");
return;
}
int fraction = Fn.IsInt(Req.GetQueryString("star"), 3);
if (fraction < 0 || fraction > 5)
{
fraction = 3;
}
int userID = 0;
if (!LoginInfo.IsLogin())
{
userID = LoginInfo.UserID;
}
string sDetail = Server.HtmlEncode(Req.GetForm("content"));
if (sDetail.Length > 600)
{
msgAjax.Error("above");
return;
}
string sSql = "insert into CaiPu_Evaluate(FK_User,FK_Pro,Fraction,Detail,Purview,IP) values(@FK_User,@FK_Pro,@Fraction,@Detail,@Purview,@IP)";
IDataParameter[] dp =
{
DbHelp.Def.AddParam("@FK_User", userID),
DbHelp.Def.AddParam("@FK_Pro", id),
DbHelp.Def.AddParam("@Fraction", fraction),
DbHelp.Def.AddParam("@Detail", sDetail),
DbHelp.Def.AddParam("@Purview", 0),
DbHelp.Def.AddParam("@IP", Request.UserHostAddress),
};
if (DbHelp.Update(sSql, dp) > 0)
{
banH.Add();
msgAjax.Success("1");
}
else
{
msgAjax.Error("nosubmit");
}
}
private void Add()
{
if (banH.IsBan())
{
msgAjax.Error("ban");
return;
}
if (LoginInfo.NoLogin1(msgAjax))
{
return;
}
string sDetail = Server.HtmlEncode(Req.GetForm("content"));
if (sDetail.Length == 0)
{
msgAjax.Error("input");
return;
}
if (sDetail.Length > 600)
{
msgAjax.Error("above");
return;
}
Pro_MsgM mod = new Pro_MsgM();
mod.FK_User = LoginInfo.UserID;
mod.FK_Pro = id;
mod.Detail = sDetail;
mod.Purview = 0;
mod.IP = Request.UserHostAddress;
ProMsg_TransM tmod = new ProMsg_TransM();
tmod.mod = mod;
DbHelp.ExecuteTrans(new DbHelpParam(), this.ProEval_Trans, tmod);
if (tmod.returnValue == "1")
{
msgAjax.Success("1");
}
else
{
msgAjax.Error(tmod.returnValue);
}
}
/// <summary>
/// true:未登录
/// ajax提交自身页时 需要 name=hid value=1 的 input(form提交方式)
/// </summary>
/// <param name="msg"></param>
public static bool NoLogin(IMessage msg)
{
if (LoginInfo.IsLogin())
{
if (Req.GetForm("hid") == "1")
{
string s = "您已退出登录";
msg.WriteMessage(string.Empty, ref s, string.Empty, "nologin");
return(true);
}
HttpContext.Current.Response.Redirect("/user/login.aspx?url=" + HttpContext.Current.Server.UrlEncode(HttpContext.Current.Request.Url.ToString()));
}
return(false);
}
/// <summary>
/// 获取数据及验证
/// </summary>
/// <returns></returns>
public static User_ContactM GetData(ref string pMsg)
{
User_ContactM mod = new User_ContactM();
string sName = Fn.EncodeHtml(Req.GetForm("cName").Trim());
//string sSex = Req.GetForm("cSex").Trim();
string sAddress = Fn.EncodeHtml(Req.GetForm("cAddress").Trim());
string sFixTel = Fn.EncodeHtml(Req.GetForm("cFixTel").Trim());
string sTel = Fn.EncodeHtml(Req.GetForm("cTel").Trim());
string sArea = Req.GetForm("cArea").Trim();
if (sName.Length < 1 || sName.Length > 30)
{
pMsg = "请输入收货人,不超30个字;";
return(mod);
}
if ((sTel.Length < 1 || sTel.Length > 25) && (sFixTel.Length < 1 || sFixTel.Length > 25))
{
pMsg = "手机,固定电话必填一个,不超25个位;";
return(mod);
}
if (sAddress.Length < 1 || sAddress.Length > 300)
{
pMsg = "请输入详细地址,不超300个字;";
return(mod);
}
if ((!Fn.IsIntBool(sArea)))
{
pMsg = "请选择地区;";
return(mod);
}
else if (Convert.ToInt32(sArea) < 1)
{
pMsg = "请选择地区;";
return(mod);
}
mod.Name = sName;
mod.Address = sAddress;
mod.FixTel = sFixTel;
mod.Tel = sTel;
mod.FK_Area = Convert.ToInt32(sArea);
return(mod);
}
protected void Page_Load(object sender, EventArgs e)
{
if (LoginInfo.banHandler.IsBan())
{
if (!Fn.IsVerifyCode("cCode", "uverify"))
{
jso.Add("err", "验证码输入错误");
jso.Add("v", "1");//前台是否刷新 显示 验证码
WriteEndJso();
}
}
string UserName = Req.GetForm("cName").Trim();
string UserPwd = Req.GetForm("cPwd").Trim();
if (UserName.Length > Constant.MaxCount_UserName)
{
UserName = UserName.Substring(0, Constant.MaxCount_UserName);
}
if (UserName.Length == 0)
{
jso.Add("err", "请输入用户名");
WriteEndJso();
}
if (UserPwd.Length == 0)
{
jso.Add("err", "请输入密码");
WriteEndJso();
}
if (User_Info.Login(UserName, UserPwd))
{
jso.Add("success", "登录成功");
WriteEndJso();
}
else
{
if (LoginInfo.banHandler.IsBan())
{
jso.Add("v", "1");
}
jso.Add("err", "用户名或密码错误");
WriteEndJso();
}
}
//评论列表
private void List()
{
//PagingList pl = new PagingList("News_Msg", "MsgSN", new PagingUrlVar(10, pageIndex));
//pl.SqlSelect = "select N.FK_User,Detail,N.AddDate as AddDate,UserName";
//pl.SqlFrom = "from News_Msg as N left join User_Info as U on N.FK_User=U.UserSN";
//pl.SqlWhere = "where Purview=1 and FK_News=" + id;
//pl.SqlOrder = "order by N.AddDate desc";
//Paging pg = pl.List(true);
//Bind.BGRepeater(pg.GetDataTable(), this.rpMsgList);
//this.ucPS1.f = pg;
//this.ucPS1.cs = GetURL.News.Msg(id) + "-{0}";
#region ajax提交
int cur_pageIndex = Fn.IsInt(Req.GetForm("ajax_page"), 1);
string sqlSelect, sqlFrom, sqlWhere = string.Empty, sqlOrder, pkName;
sqlSelect = "select N.FK_User,Detail,N.AddDate as AddDate,UserName";
sqlFrom = " from News_Msg as N left join User_Info as U on N.FK_User=U.UserSN";
sqlWhere = " where Purview=1 and FK_News=" + id;
sqlOrder = " order by N.AddDate desc";
pkName = "MsgSN";
PagingVar pv = new PagingVar();
pv.SQLCount = "select count(0)" + sqlFrom + sqlWhere;
pv.SQLRead = "select " + pkName + sqlFrom + sqlWhere + sqlOrder;
pv.SQL = sqlSelect + sqlFrom + " where " + pkName + " in({0})" + sqlOrder;
Paging pg = new Paging(pv, new PagingUrlVar(30, cur_pageIndex));//页记录
pg.load();
Bind.BGRepeater(pg.GetDataTable(), this.rpMsgList);
lNum = pg.um.records_count.ToString();
this.ucPS1.f = pg;
this.ucPS1.cs = "javascript:ajaxPage('ajax_page_msg',{0});";
#endregion
}
private void cb_ok()
{
string sOldPwd = Req.GetForm("cOldPwd").Trim();
string sNewPwd = Req.GetForm("cNewPwd").Trim();
string sNewPwdSure = Req.GetForm("cNewPwdSure").Trim();
//string sMsg = string.Empty;
if (sOldPwd.Length == 0)
{
msgAjax.Error("请输入旧密码;");
}
if (sNewPwd.Length == 0)
{
msgAjax.Error("请输入新密码;");
}
else if (sNewPwd.Length < 5 || sNewPwd.Length > 30)
{
msgAjax.Error("新密码5-30位之间;");
}
if (sNewPwdSure.Length == 0)
{
msgAjax.Error("请输入新确认密码;");
}
if (sNewPwd != sNewPwdSure)
{
msgAjax.Error("新密码与新确认密码不一致;");
}
if (msgAjax.IsError)
{
return;
}
if (WZ.Data.User_InfoL.EditPwd(LoginInfo.UserName, sOldPwd, sNewPwd, LoginInfo.UserID))
{
msgAjax.Success("修改密码成功");
}
else
{
msgAjax.Error("原密码错误");
}
}
public static int DeleteMore(string pTableName, string pPKName, string pHtmlID)
{
IMessage MessageG = new MessageGeneral();
string sArrStr = Req.GetForm(pHtmlID);
if (!Fn.IsIntArrBool(sArrStr))
{
MessageG.Error("请选择要删除的记录.");
}
string sSQL = "delete from " + pTableName + " where " + pPKName + " in(" + sArrStr + ")";
return(DbHelp.Update(sSQL));
//HttpContext.Current.Response.Redirect(HttpContext.Current.Request.Url.ToString());
}
protected void bOK_Click(object sender, EventArgs e)
{
string sPwd = Req.GetForm("cPwd").Trim();
string sPwdSure = Req.GetForm("cPwdSure").Trim();
if (sPwd.Length == 0)
{
Js.Alert("请输入密码");
}
if (sPwd.Length < 5 || sPwd.Length > 30)
{
Js.Alert("密码不能小于5到30位数");
}
if (sPwdSure.Length == 0)
{
Js.Alert("请输入确认密码");
}
if (sPwd != sPwdSure)
{
Js.Alert("两次密码输入不一致");
}
EditPwd_TransM tmod = new EditPwd_TransM();
tmod.sPwd = sPwd;
tmod.sPwdSure = sPwdSure;
tmod.sKey = Key;
tmod.sEmail = Email;
DbHelp.ExecuteTrans(new DbHelpParam(), EditPwd_Trans, tmod);
if (tmod.returnValue == "1")
{
Response.Redirect("/user/findPwd3.aspx");
}
else
{
Js.Alert(tmod.returnValue);
}
}
private void Add()
{
string sDetail = Server.HtmlEncode(Req.GetForm("content"));
if (sDetail.Length == 0)
{
msgAjax.Error("input");
return;
}
if (sDetail.Length > 600)
{
msgAjax.Error("不能超出600字");
return;
}
int userID = 0;
if (!LoginInfo.IsLogin())
{
userID = LoginInfo.UserID;
}
string sSql = "insert into Questionnaire_Msg(FK_User,FK_Questionnaire,Detail,Purview,IP) values(@FK_User,@FK_Questionnaire,@Detail,@Purview,@IP)";
IDataParameter[] dp =
{
DbHelp.Def.AddParam("@FK_User", userID),
DbHelp.Def.AddParam("@FK_Questionnaire", id),
DbHelp.Def.AddParam("@Detail", sDetail),
DbHelp.Def.AddParam("@Purview", 0),
DbHelp.Def.AddParam("@IP", Request.UserHostAddress),
};
if (DbHelp.Update(sSql, dp) > 0)
{
msgAjax.Success("1");
}
else
{
msgAjax.Error("nosubmit");
}
}
protected void Page_Load(object sender, EventArgs e)
{
int hid = Fn.IsInt(Req.GetForm("hid"), 0);
if (hid > 0)
{
string cmd = Req.GetForm("cmd");
switch (cmd)
{
case "reg":
Reg();
break;
}
Response.Write(msgAjax.ReturnMessage);
Response.End();
}
LL();
}
protected void Page_Load(object sender, EventArgs e)
{
int hid = Fn.IsInt(Req.GetForm("hid"), 0);
if (hid > 0)
{
switch (hid)
{
case 1: //删除
del();
break;
}
Response.Write(msgAjax.ReturnMessage);
Response.End();
}
else
{
LL();
}
}
private void delete()
{
int id = Fn.IsInt(Req.GetForm("id"), 0);
if (id > 0)
{
if (User_Cart.Delelte(LoginInfo.UserID, id))
{
refresh();
msgAjax.Success("1");
}
else
{
msgAjax.Error("删除失败");
}
}
else
{
msgAjax.Error("删除失败");
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region ajax
string hid = Req.GetForm("hid");
if (hid == "1")
{
string cmd = Req.GetForm("cmd");
switch (cmd)
{
case "save":
cb_ok();
break;
}
Response.Write(msgAjax.ReturnMessage);
Response.End();
}
#endregion
if (!this.IsPostBack)
{
LL();
}
}
