public NModel.WebPager <NModel.DB_Area> LoadData(string ipAddress, string pagename)
{
BLL.DB_WebConfig bllwebcfg = new BLL.DB_WebConfig();
BLL.DB_Area bllArea = new BLL.DB_Area();
NModel.DB_WebConfig modelwebcfg = bllwebcfg.GetCodeModel(pagename);
NModel.WebPager <NModel.DB_Area> model_pager = new NModel.WebPager <NModel.DB_Area>();
// model_pager.OutStr = Tool.NWeb.GetAddresByIp(ipAddress);
string gocityName = Tool.NTool.GetCookieValue("gocityName");
if (!string.IsNullOrEmpty(gocityName))
{
model_pager.OutStr = this.Server.UrlDecode(gocityName);
}
if (string.IsNullOrEmpty(model_pager.OutStr))
{
model_pager.OutStr = "广州";
}
// model_pager.OutObj = bllArea.GetListByName(model_pager.OutStr + "%");
model_pager.OutWebConfig = modelwebcfg != null ? modelwebcfg : new NModel.DB_WebConfig();
BLL.DB_Link bll_link = new BLL.DB_Link();
IList <NModel.DB_Link> List_link = bll_link.GetListByNumAndTop("1", 20);
model_pager.IDictLink.Add("招聘友情链接", List_link);
bll_link.Close();
bllArea.Close();
bllwebcfg.Close();
return(model_pager);
}
public ActionResult Edit_DB_WebConfig()
{
this.Response.ContentType = "text/plain";
NModel.DB_WebConfig model = new NModel.DB_WebConfig();
BLL.DB_WebConfig dal = new BLL.DB_WebConfig();
String JsonStr = "";
bool isGet = Tool.NStr.PostForSetVal <NModel.DB_WebConfig>(ref model, ref JsonStr, "");
// 下面代码编写
if (isGet &&
//&& !string.IsNullOrEmpty(model.WebConfig_Code) &&
// !string.IsNullOrEmpty(model.WebConfig_Title) && !
// string.IsNullOrEmpty(model.WebConfig_Keywords) &&
// !string.IsNullOrEmpty(model.WebConfig_Description) &&
//// !string.IsNullOrEmpty(model.File_Category_Size)&&
(model.WebConfig_ID > 0)
)
{
//取默认值
model.WebConfig_EditTime = DateTime.Parse(DateTime.Now.ToString("s"));
bool isEdit = dal.EditFree(model, (long)model.WebConfig_ID) > 0 ? true : false;
string msg = dal.ErrorMsg;
if (!string.IsNullOrEmpty(msg))
{
msg = "原因：" + msg;
}
if (isEdit)
{
this.Response.Write(Tool.NMsg.SetMsg("修改成功", "1"));
this.Response.End();
}
else
{
this.Response.Write(Tool.NMsg.SetMsg("修改失败" + msg, "0"));
this.Response.End();
}
dal.Close();
}
else
{
this.Response.Write(Tool.NMsg.SetMsg("提交失败", "0"));
this.Response.End();
}
return(View());
}
public ActionResult SendToEMailCode()
{
NCaptcha.Generate(NModel.EnObject.UserCodeSessionName);
DateTime?dt = (DateTime?)NModel.EnObject.GetTimeValue;
try
{
DateTime?dt1 = DateTime.Now;
TimeSpan?ts = dt1 - dt;
double s = 0;
if (ts != null)
{
s = ts.Value.TotalSeconds;
}
if (s >= 62 || ts == null)
{
string toEmail = this.Server.UrlDecode(this.Request["to"]);
string code = NModel.EnObject.GetCodeValue;
BLL.DB_WebConfig bll_WebConfig = new BLL.DB_WebConfig();
NModel.DB_WebConfig model_WebConfig = bll_WebConfig.GetModel((long?)4);
model_WebConfig = model_WebConfig != null ? model_WebConfig : new NModel.DB_WebConfig();
bll_WebConfig.Close();
bool isOk = Tool.NEmail.SendTo(model_WebConfig.WebConfig_ServerAdrress, model_WebConfig.WebConfig_SendEmail,
model_WebConfig.WebConfig_SendPw, model_WebConfig.WebConfig_SendName + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-fff"), toEmail, model_WebConfig.WebConfig_ToName,
model_WebConfig.WebConfig_SubContent + "验证码:" + code, model_WebConfig.WebConfig_SubTitle + "" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss-fff"));
if (isOk)
{
NModel.EnObject.SetEmailValue = toEmail;
NModel.EnObject.SetTimeValue = DateTime.Now;
this.Response.Write("{ \"info\":\"已发送到邮箱,请查看验证码 邮箱->" + toEmail + "\" , \"status\":\"y\" }");
}
else
{
this.Response.Write("{ \"info\":\"发送失败\", \"status\":\"n\" }");
}
}
else
{
this.Response.Write("{ \"info\":\"发送时间没到" + s + "秒\", \"status\":\"n\" }");
}
}
catch (Exception ex)
{
}
return(View());
}
//end
public ActionResult Add_DB_WebConfig()
{
this.Response.ContentType = "text/plain";
NModel.DB_WebConfig model = new NModel.DB_WebConfig();
BLL.DB_WebConfig dal = new BLL.DB_WebConfig();
String JsonStr = "";
bool isGet = Tool.NStr.PostForSetVal <NModel.DB_WebConfig>(ref model, ref JsonStr, "");
// 下面代码编写
if (isGet
//&& !string.IsNullOrEmpty(model.WebConfig_Code) &&
// !string.IsNullOrEmpty(model.WebConfig_Description)
// &&!string.IsNullOrEmpty(model.WebConfig_Title)
//&&!string.IsNullOrEmpty(model.WebConfig_Keywords
)
{
{
model.WebConfig_EditTime = DateTime.Parse(DateTime.Now.ToString("s"));
model.WebConfig_AddTime = DateTime.Parse(DateTime.Now.ToString("s"));
//
bool isAdd = dal.AddFree(model) > 0 ? true : false;
if (isAdd)
{
this.Response.Write(Tool.NMsg.SetMsg("增加成功", "1"));
this.Response.End();
}
else
{
this.Response.Write(Tool.NMsg.SetMsg("增加失败" + dal.ErrorMsg, "1"));
this.Response.End();
}
}
}
else
{
this.Response.Write(Tool.NMsg.SetMsg("提交失败", "0"));
}
dal.Close();
return(View());
}
public ActionResult Del_All_DB_WebConfig()
{
BLL.DB_WebConfig bll = new BLL.DB_WebConfig();
long delNumber = bll.DelAll();
if (delNumber > 0)
{
this.Response.Write(Tool.NMsg.SetMsg("删除成功", "1"));
this.Response.End();
}
else
{
this.Response.Write(Tool.NMsg.SetMsg("删除失败", "0"));
this.Response.End();
}
bll.Close();
return(View());
}
public ActionResult Del_DB_WebConfig()
{
this.Response.ContentType = "text/plain";
string delList = this.Request.Form["delList[]"];
if (!string.IsNullOrEmpty(delList))
{
string[] arrStr = delList.Split(',');
int[] delIntArr = Tool.NTool.ArrayToAll <int, string>(arrStr);
if (Tool.NTool.IsArrNULL <int>(delIntArr))
{
BLL.DB_WebConfig dal = new BLL.DB_WebConfig();
long long_Result = dal.DelList(delIntArr);
if (long_Result > 0)
{
this.Response.Write(Tool.NMsg.SetMsg(string.Format("删除成功！总共删除{0}条", long_Result), "1"));
this.Response.End();
}
else
{
this.Response.Write(Tool.NMsg.SetMsg("删除失败！", "0"));
this.Response.End();
}
dal.Close();
}
else
{
this.Response.Write(Tool.NMsg.SetMsg("提交失败/填写数据不完整！", "0"));
this.Response.End();
}
}
else
{
this.Response.Write(Tool.NMsg.SetMsg("提交失败/填写数据不完整！", "0"));
this.Response.End();
}
return(View());
}
public ActionResult Item_db_webconfig()
{
BLL.DB_WebConfig dal = new BLL.DB_WebConfig();
string pagenum = this.Request.Form["pagenum"];
string numPerPage = this.Request.Form["numPerPage"];
string dbwebconfigdate = this.Request.Form["dbwebconfigdate"];
string dbwebconfigurl = this.Request.Form["dbwebconfigurl"];
string where = "", order = "webconfig_addtime desc";
if (string.IsNullOrEmpty(numPerPage))
{
numPerPage = "20";
}
if (string.IsNullOrEmpty(pagenum))
{
pagenum = "1";
}
where += " 1=1 ";
if (!string.IsNullOrEmpty(dbwebconfigdate))
{
where += string.Format(" and ( CONVERT(varchar(100), webconfig_addtime, 23)=''{0}'' )", dbwebconfigdate);
}
if (!string.IsNullOrEmpty(dbwebconfigurl))
{
where += string.Format(" and WebConfig_Code like ''%{0}%''", dbwebconfigurl);
}
NModel.PageData <NModel.DB_WebConfig> PD = new NModel.PageData <NModel.DB_WebConfig>()
{
NumPerPage = numPerPage,
PageNum = pagenum,
TotalPage = dal.GetWhereListTotal(where),
Where = where,
OrderField = order
};
dal.Close();
return(View(PD));
}
public NModel.NewsPager LoadConfig(string pagename, string linknum = "1", string linkdictName = "友情链接")
{
BLL.DB_WebConfig bllwebcfg = new BLL.DB_WebConfig();
NModel.DB_WebConfig modelwebcfg = bllwebcfg.GetCodeModel(pagename);
NModel.NewsPager model_pager = new NModel.NewsPager();
bllwebcfg.Close();
model_pager.OutWebConfig = modelwebcfg != null ? modelwebcfg : new NModel.DB_WebConfig();
BLL.DB_Link bll_link = new BLL.DB_Link();
IList <NModel.DB_Link> List_link = bll_link.GetListByNumAndTop(linknum, 20);
model_pager.IDictLink.Add(linkdictName, List_link);
bll_link.Close();
return(model_pager);
}
public ActionResult Data_DB_WebConfig()
{
string[] keys = this.Request.Form.AllKeys;
string page = this.Request.Form["page"];
string rows = this.Request.Form["rows"];
string where = this.Request.Form["where"];
string order = this.Request.Form["order"];
// where = Server.UrlDecode(where);
//1=1 and file_name like '%va%'
int _page = 0, _rows = 0;
int.TryParse(page, out _page);
int.TryParse(rows, out _rows);
if (_page == 0)
{
_page = 1;
}
if (_rows == 0)
{
_rows = 20;
}
BLL.DB_WebConfig dal = new BLL.DB_WebConfig();
List <NModel.DB_WebConfig> inModel = new List <NModel.DB_WebConfig>();
inModel = dal.GetSortAndWherePagerList(_page, _rows, order, where);
NModel.PageData <NModel.DB_WebConfig> outModel = BLL.Fun.SetJsonData <NModel.DB_WebConfig>(inModel);
dal.Close();
return(View(outModel));
}
