/// <summary> /// 获取网站实体 /// </summary> /// <param name="dt"></param> /// <returns></returns> private static Model.WebSiteInfo GetWebSite(DataTable dt) { Model.WebSiteInfo model = new Model.WebSiteInfo(); if (dt.Rows.Count > 0) { model.WebSiteKey = (Guid)(dt.Rows[0]["WebSiteKey"]); model.WebSiteName = dt.Rows[0]["WebSiteName"].ToString(); model.WebSiteID = dt.Rows[0]["WebSiteID"].ToString(); model.DomainName = dt.Rows[0]["DomainName"].ToString(); model.LogoImgUrl = dt.Rows[0]["LogoImgUrl"].ToString(); model.CompanyName = dt.Rows[0]["CompanyName"].ToString(); model.Address = dt.Rows[0]["Address"].ToString(); model.PhoneNumber = dt.Rows[0]["PhoneNumber"].ToString(); model.QQ = dt.Rows[0]["QQ"].ToString(); model.WeChat = dt.Rows[0]["WeChat"].ToString(); model.Email = dt.Rows[0]["Email"].ToString(); model.QRCodeUrl = dt.Rows[0]["QRCodeUrl"].ToString(); model.RecordNumber = dt.Rows[0]["RecordNumber"].ToString(); model.Keywords = dt.Rows[0]["Keywords"].ToString(); model.Description = dt.Rows[0]["Description"].ToString(); model.Category = dt.Rows[0]["Category"].ToString(); model.BackgroundImg = dt.Rows[0]["BackgroundImg"].ToString(); } return(model); }
public JsonResult SaveWebSite(ViewModels.vm_WebSite inModel) { JsonResult json = new JsonResult(); if (inModel.WebSiteKey == Guid.Empty && inModel.IsEdit) { json.Data = new { result = false, message = "保存失败" }; return(json); } if (string.IsNullOrEmpty(inModel.DomainName)) { json.Data = new { result = false, message = "域名不能为空" }; return(json); } Model.WebSiteInfo model = new Model.WebSiteInfo() { WebSiteKey = inModel.IsEdit ? inModel.WebSiteKey : Guid.NewGuid(), DomainName = inModel.DomainName, WebSiteName = inModel.WebSiteName ?? "", CompanyName = inModel.CompanyName ?? "", Address = inModel.Address ?? "", PhoneNumber = inModel.PhoneNumber ?? "", QQ = inModel.QQ ?? "", WeChat = inModel.WeChat ?? "", Email = inModel.Email ?? "", RecordNumber = inModel.RecordNumber ?? "", Keywords = inModel.Keywords ?? "", Description = inModel.Description ?? "", Category = inModel.Category ?? "", }; if (!inModel.IsEdit) { model.LogoImgUrl = inModel.LogoImgUrl ?? ""; model.QRCodeUrl = inModel.QRCodeUrl ?? ""; model.BackgroundImg = inModel.BackgroundImg ?? ""; } int n = inModel.IsEdit ? Logic.WebSite.UpdateWebSite(model) : Logic.WebSite.AddWebSite(model); json.Data = n < 0 ? new { result = false, message = "保存失败", key = "" } : new { result = true, message = "", key = model.WebSiteKey.ToString() }; return(json); }
/// <summary> /// 更新站点 /// </summary> /// <param name="inModel"></param> /// <returns></returns> public static int UpdateWebSite(Model.WebSiteInfo inModel) { StringBuilder sql = new StringBuilder(); sql.Append(" UPDATE WebSiteInfo SET WebSiteName = @inWebSiteName, "); sql.Append(" DomainName = @inDomainName, CompanyName = @inCompanyName, "); sql.Append(" PhoneNumber = @inPhoneNumber, Address = @inAddress, "); sql.Append(" QQ = @inQQ, WeChat = @inWeChat, Email = @inEmail, RecordNumber = @inRecordNumber, "); sql.Append(" Keywords = @inKeywords, Description = @inDescription, Category = @inCategory "); sql.Append(" WHERE WebSiteKey = @inWebSiteKey "); SqlParameter[] paras = GetParas(inModel); int result = SqlHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), paras); return(result); }
/// <summary> /// 添加站点 /// </summary> /// <param name="inModel"></param> /// <returns></returns> public static int AddWebSite(Model.WebSiteInfo inModel) { StringBuilder sql = new StringBuilder(); sql.Append(" INSERT INTO WebSiteInfo ( "); sql.Append(" WebSiteKey, WebSiteName, DomainName, LogoImgUrl, CompanyName, Address, "); sql.Append(" PhoneNumber, QQ, WeChat, Email, QRCodeUrl, RecordNumber, Keywords, Description, Category, BackgroundImg "); sql.Append(" ) VALUES ( "); sql.Append(" @inWebSiteKey, @inWebSiteName, @inDomainName, @inLogoImgUrl, @inCompanyName, @inAddress, "); sql.Append(" @inPhoneNumber, @inQQ, @inWeChat, @inEmail, @inQRCodeUrl, @inRecordNumber, @inKeywords, @inDescription, @inCategory, @inBackgroundImg ) "); SqlParameter[] paras = GetParas(inModel); int result = SqlHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), paras); return(result); }
public ActionResult WebSiteInfo(string inKey) { ViewModels.vm_LoginUser vLogin = HttpContext.Session["LoginUser"] as ViewModels.vm_LoginUser; if (vLogin == null) { return(RedirectToAction("Index")); } ViewModels.vm_WebSite vModel = new ViewModels.vm_WebSite(); vModel.IsEdit = false; if (!string.IsNullOrEmpty(inKey)) { Model.WebSiteInfo model = Logic.WebSite.GetWebSiteByKey(new Guid(inKey)); vModel.IsEdit = true; vModel.WebSiteKey = model.WebSiteKey; vModel.WebSiteName = model.WebSiteName; vModel.WebSiteID = model.WebSiteID; vModel.DomainName = model.DomainName; vModel.LogoImgUrl = model.LogoImgUrl; vModel.CompanyName = model.CompanyName; vModel.Address = model.Address; vModel.PhoneNumber = model.PhoneNumber; vModel.QQ = model.QQ; vModel.WeChat = model.WeChat; vModel.Email = model.Email; vModel.QRCodeUrl = model.QRCodeUrl; vModel.RecordNumber = model.RecordNumber; vModel.Keywords = model.Keywords; vModel.Description = model.Description; vModel.Category = model.Category; vModel.BackgroundImg = model.BackgroundImg; } ViewBag.UserName = vLogin.Name; return(View(vModel)); }
/// <summary> /// 获取站点列表 /// </summary> /// <returns></returns> public static List <Model.WebSiteInfo> GetWebSiteList() { string sql = @" SELECT * FROM WebSiteInfo "; DataTable dt = SqlHelper.ExecuteDataTable(CommandType.Text, sql); List <Model.WebSiteInfo> list = new List <Model.WebSiteInfo>(); if (dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { Model.WebSiteInfo model = new Model.WebSiteInfo() { WebSiteKey = (Guid)(item["WebSiteKey"]), WebSiteName = item["WebSiteName"].ToString(), WebSiteID = item["WebSiteID"].ToString(), DomainName = item["DomainName"].ToString(), LogoImgUrl = item["LogoImgUrl"].ToString(), CompanyName = item["CompanyName"].ToString(), Address = item["Address"].ToString(), PhoneNumber = item["PhoneNumber"].ToString(), QQ = item["QQ"].ToString(), WeChat = item["WeChat"].ToString(), Email = item["Email"].ToString(), QRCodeUrl = item["QRCodeUrl"].ToString(), RecordNumber = item["RecordNumber"].ToString(), Keywords = item["Keywords"].ToString(), Description = item["Description"].ToString(), Category = item["Category"].ToString(), BackgroundImg = item["BackgroundImg"].ToString() }; list.Add(model); } } return(list); }
/// <summary> /// 获取参数 /// </summary> /// <param name="inModel"></param> /// <returns></returns> private static SqlParameter[] GetParas(Model.WebSiteInfo inModel) { List <SqlParameter> list = new List <SqlParameter>(); SqlParameter webSiteKey = new SqlParameter("@inWebSiteKey", SqlDbType.UniqueIdentifier, 16); webSiteKey.Value = inModel.WebSiteKey; list.Add(webSiteKey); SqlParameter webSiteName = new SqlParameter("@inWebSiteName", SqlDbType.NVarChar, 50); webSiteName.Value = inModel.WebSiteName; list.Add(webSiteName); SqlParameter domainName = new SqlParameter("@inDomainName", SqlDbType.NVarChar, 50); domainName.Value = inModel.DomainName; list.Add(domainName); SqlParameter logoImgUrl = new SqlParameter("@inLogoImgUrl", SqlDbType.NVarChar, 250); logoImgUrl.Value = inModel.LogoImgUrl; list.Add(logoImgUrl); SqlParameter companyName = new SqlParameter("@inCompanyName", SqlDbType.NVarChar, 50); companyName.Value = inModel.CompanyName; list.Add(companyName); SqlParameter address = new SqlParameter("@inAddress", SqlDbType.NVarChar, 300); address.Value = inModel.Address; list.Add(address); SqlParameter phoneNumber = new SqlParameter("@inPhoneNumber", SqlDbType.NVarChar, 50); phoneNumber.Value = inModel.PhoneNumber; list.Add(phoneNumber); SqlParameter qQ = new SqlParameter("@inQQ", SqlDbType.NVarChar, 50); qQ.Value = inModel.QQ; list.Add(qQ); SqlParameter weChat = new SqlParameter("@inWeChat", SqlDbType.NVarChar, 50); weChat.Value = inModel.WeChat; list.Add(weChat); SqlParameter email = new SqlParameter("@inEmail", SqlDbType.NVarChar, 50); email.Value = inModel.Email; list.Add(email); SqlParameter qRCodeUrl = new SqlParameter("@inQRCodeUrl", SqlDbType.NVarChar, 250); qRCodeUrl.Value = inModel.QRCodeUrl; list.Add(qRCodeUrl); SqlParameter recordNumber = new SqlParameter("@inRecordNumber", SqlDbType.NVarChar, 100); recordNumber.Value = inModel.RecordNumber; list.Add(recordNumber); SqlParameter keywords = new SqlParameter("@inKeywords", SqlDbType.NVarChar, 500); keywords.Value = inModel.Keywords; list.Add(keywords); SqlParameter description = new SqlParameter("@inDescription", SqlDbType.NVarChar, 200); description.Value = inModel.Description; list.Add(description); SqlParameter category = new SqlParameter("@inCategory", SqlDbType.NVarChar, 50); category.Value = inModel.Category; list.Add(category); SqlParameter backgroundImg = new SqlParameter("@inBackgroundImg", SqlDbType.NVarChar, 250); backgroundImg.Value = inModel.BackgroundImg; list.Add(backgroundImg); return(list.ToArray()); }
/// <summary> /// 更新站点 /// </summary> /// <param name="inModel">网站实体</param> /// <returns></returns> public static int UpdateWebSite(Model.WebSiteInfo inModel) { return(Data.WebSite.UpdateWebSite(inModel)); }
/// <summary> /// 添加站点 /// </summary> /// <param name="inModel">网站实体</param> /// <returns></returns> public static int AddWebSite(Model.WebSiteInfo inModel) { return(Data.WebSite.AddWebSite(inModel)); }
protected override string GetArguments(Model.WebSiteInfo webSiteInfo) { return(string.Format(" {0} {1} {2}", SCRIPT_PATH, webSiteInfo.Url, Path.Combine(TEMP_HTML_FOLDER, webSiteInfo.GetHashCode().ToString().Replace('-', '_')))); }
protected override void DownLoad(string html, Model.WebSiteInfo webSiteInfo) { }