/// <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)
{
}
