public int RecordToDatabase(DataTable dt, string userName)
{
int count = 0;
//写入数据库
for (int i = 0; i < dt.Rows.Count; i++)
{
SM.YuQing.BLL.MonitorInfos bll = new SM.YuQing.BLL.MonitorInfos();
SM.YuQing.Model.MonitorInfos monitorInfo = new SM.YuQing.Model.MonitorInfos();
monitorInfo.Title = dt.Rows[i]["Title"].ToString();
monitorInfo.PublishDate = dt.Rows[i]["PublishDate"].ToString() == "" ? DateTime.Now : Convert.ToDateTime(dt.Rows[i]["PublishDate"].ToString());
monitorInfo.ViewsCounts = dt.Rows[i]["ViewsCounts"].ToString() == "" ? 0 : Convert.ToInt32(dt.Rows[i]["ViewsCounts"].ToString());
int regionid = dt.Rows[i]["RegionID"].ToString() == "" ? 0 : Convert.ToInt32(dt.Rows[i]["RegionID"].ToString());
monitorInfo.RegionID = regionid;
monitorInfo.MonitorUrl = dt.Rows[i]["MonitorUrl"].ToString();
monitorInfo.Keyword = dt.Rows[i]["Keyword"].ToString();
monitorInfo.Url = dt.Rows[i]["Url"].ToString();
monitorInfo.Property = "";
monitorInfo.CreatePerson = userName;
monitorInfo.CreateTime = DateTime.Now;
monitorInfo.UpdatePerson = userName;
monitorInfo.UpdateTime = DateTime.Now;
if (!bll.Exists(dt.Rows[i]["Url"].ToString(), regionid)) //存在此Url+RegionID
{
bll.Add(monitorInfo);
count++;
}
}
return(count);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SM.YuQing.Model.MonitorInfos DataRowToModel(DataRow row)
{
SM.YuQing.Model.MonitorInfos model = new SM.YuQing.Model.MonitorInfos();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["Title"] != null)
{
model.Title = row["Title"].ToString();
}
if (row["Url"] != null)
{
model.Url = row["Url"].ToString();
}
if (row["PublishDate"] != null && row["PublishDate"].ToString() != "")
{
model.PublishDate = DateTime.Parse(row["PublishDate"].ToString());
}
if (row["ViewsCounts"] != null && row["ViewsCounts"].ToString() != "")
{
model.ViewsCounts = int.Parse(row["ViewsCounts"].ToString());
}
if (row["RegionID"] != null && row["RegionID"].ToString() != "")
{
model.RegionID = int.Parse(row["RegionID"].ToString());
}
if (row["MonitorUrl"] != null)
{
model.MonitorUrl = row["MonitorUrl"].ToString();
}
if (row["Keyword"] != null)
{
model.Keyword = row["Keyword"].ToString();
}
if (row["Property"] != null)
{
model.Property = row["Property"].ToString();
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["CreatePerson"] != null)
{
model.CreatePerson = row["CreatePerson"].ToString();
}
if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "")
{
model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString());
}
if (row["UpdatePerson"] != null)
{
model.UpdatePerson = row["UpdatePerson"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SM.YuQing.Model.MonitorInfos model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MonitorInfos set ");
strSql.Append("Title=@Title,");
strSql.Append("Url=@Url,");
strSql.Append("PublishDate=@PublishDate,");
strSql.Append("ViewsCounts=@ViewsCounts,");
strSql.Append("RegionID=@RegionID,");
strSql.Append("MonitorUrl=@MonitorUrl,");
strSql.Append("Keyword=@Keyword,");
strSql.Append("Property=@Property,");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("CreatePerson=@CreatePerson,");
strSql.Append("UpdateTime=@UpdateTime,");
strSql.Append("UpdatePerson=@UpdatePerson");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@Url", SqlDbType.NVarChar, 500),
new SqlParameter("@PublishDate", SqlDbType.DateTime),
new SqlParameter("@ViewsCounts", SqlDbType.Int, 4),
new SqlParameter("@RegionID", SqlDbType.Int, 4),
new SqlParameter("@MonitorUrl", SqlDbType.NVarChar, 500),
new SqlParameter("@Keyword", SqlDbType.NVarChar, 500),
new SqlParameter("@Property", SqlDbType.NVarChar, 50),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreatePerson", SqlDbType.NVarChar, 50),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@UpdatePerson", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.Title;
parameters[2].Value = model.Url;
parameters[3].Value = model.PublishDate;
parameters[4].Value = model.ViewsCounts;
parameters[5].Value = model.RegionID;
parameters[6].Value = model.MonitorUrl;
parameters[7].Value = model.Keyword;
parameters[8].Value = model.Property;
parameters[9].Value = model.CreateTime;
parameters[10].Value = model.CreatePerson;
parameters[11].Value = model.UpdateTime;
parameters[12].Value = model.UpdatePerson;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(SM.YuQing.Model.MonitorInfos model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MonitorInfos(");
strSql.Append("Title,Url,PublishDate,ViewsCounts,RegionID,MonitorUrl,Keyword,Property,CreateTime,CreatePerson,UpdateTime,UpdatePerson)");
strSql.Append(" values (");
strSql.Append("@Title,@Url,@PublishDate,@ViewsCounts,@RegionID,@MonitorUrl,@Keyword,@Property,@CreateTime,@CreatePerson,@UpdateTime,@UpdatePerson)");
SqlParameter[] parameters =
{
new SqlParameter("@Title", SqlDbType.NVarChar, 100),
new SqlParameter("@Url", SqlDbType.NVarChar, 500),
new SqlParameter("@PublishDate", SqlDbType.DateTime),
new SqlParameter("@ViewsCounts", SqlDbType.Int, 4),
new SqlParameter("@RegionID", SqlDbType.Int, 4),
new SqlParameter("@MonitorUrl", SqlDbType.NVarChar, 500),
new SqlParameter("@Keyword", SqlDbType.NVarChar, 500),
new SqlParameter("@Property", SqlDbType.NVarChar, 50),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreatePerson", SqlDbType.NVarChar, 50),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@UpdatePerson", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Title;
parameters[1].Value = model.Url;
parameters[2].Value = model.PublishDate;
parameters[3].Value = model.ViewsCounts;
parameters[4].Value = model.RegionID;
parameters[5].Value = model.MonitorUrl;
parameters[6].Value = model.Keyword;
parameters[7].Value = model.Property;
parameters[8].Value = model.CreateTime;
parameters[9].Value = model.CreatePerson;
parameters[10].Value = model.UpdateTime;
parameters[11].Value = model.UpdatePerson;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.Cache.SetNoStore();
string id = context.Request.QueryString["id"];
string property = context.Request.Form["property"];
bool success;
SM.YuQing.BLL.MonitorInfos bll = new SM.YuQing.BLL.MonitorInfos();
SM.YuQing.Model.MonitorInfos monitorInfo = bll.GetModel(Convert.ToInt32(id));
string oldProperty = monitorInfo.Property;
monitorInfo.Property = property;
monitorInfo.UpdatePerson = context.User.Identity.Name;
monitorInfo.UpdateTime = DateTime.Now;
success = bll.Update(monitorInfo);
Hashtable ht = new Hashtable();
if (success)
{
SM.YuQing.Accounts.SiteIdentity identity = (SM.YuQing.Accounts.SiteIdentity)(new SM.YuQing.Accounts.AccountsPrincipal(context.User.Identity.Name)).Identity;
int personid = identity.FID;
SM.YuQing.Model.Log log = new SM.YuQing.Model.Log();
log.LogType = "操作";
log.Message = context.User.Identity.Name + " 保存了ID=" + id + "的监测记录的性质为 " + property + " （原性质为 " + (oldProperty == "" ? "空" : oldProperty) + " ）";
log.IP = context.Request.UserHostAddress;
log.MenuID = 0;
log.PersonID = personid;
log.CreateTime = DateTime.Now;
SM.YuQing.BLL.Log logBll = new SM.YuQing.BLL.Log();
logBll.Add(log);
ht.Add("success", true);
}
else
{
ht.Add("errorMsg", "Some errors occured.");
}
context.Response.Write(JsonConvert.SerializeObject(ht));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SM.YuQing.Model.MonitorInfos GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,Title,Url,PublishDate,ViewsCounts,RegionID,MonitorUrl,Keyword,Property,CreateTime,CreatePerson,UpdateTime,UpdatePerson from MonitorInfos ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
SM.YuQing.Model.MonitorInfos model = new SM.YuQing.Model.MonitorInfos();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
