/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(SchSystem.Model.WebSchNewsEnc model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update WebSchNewsEnc set ");
strSql.Append("NewsId=@NewsId,");
strSql.Append("OldName=@OldName,");
strSql.Append("NewName=@NewName,");
strSql.Append("SaveUrl=@SaveUrl,");
strSql.Append("Clicked=@Clicked,");
strSql.Append("RecTime=@RecTime,");
strSql.Append("RecIP=@RecIP,");
strSql.Append("FileSize=@FileSize,");
strSql.Append("ImgUrl=@ImgUrl");
strSql.Append(" where EncId=@EncId");
SqlParameter[] parameters =
{
new SqlParameter("@NewsId", SqlDbType.Int, 4),
new SqlParameter("@OldName", SqlDbType.VarChar, 50),
new SqlParameter("@NewName", SqlDbType.VarChar, 50),
new SqlParameter("@SaveUrl", SqlDbType.VarChar, 200),
new SqlParameter("@Clicked", SqlDbType.Int, 4),
new SqlParameter("@RecTime", SqlDbType.DateTime),
new SqlParameter("@RecIP", SqlDbType.VarChar, 20),
new SqlParameter("@FileSize", SqlDbType.Int, 4),
new SqlParameter("@ImgUrl", SqlDbType.VarChar, 200),
new SqlParameter("@EncId", SqlDbType.Int, 4)
};
parameters[0].Value = model.NewsId;
parameters[1].Value = model.OldName;
parameters[2].Value = model.NewName;
parameters[3].Value = model.SaveUrl;
parameters[4].Value = model.Clicked;
parameters[5].Value = model.RecTime;
parameters[6].Value = model.RecIP;
parameters[7].Value = model.FileSize;
parameters[8].Value = model.ImgUrl;
parameters[9].Value = model.EncId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SchSystem.Model.WebSchNewsEnc DataRowToModel(DataRow row)
{
SchSystem.Model.WebSchNewsEnc model = new SchSystem.Model.WebSchNewsEnc();
if (row != null)
{
if (row["EncId"] != null && row["EncId"].ToString() != "")
{
model.EncId = int.Parse(row["EncId"].ToString());
}
if (row["NewsId"] != null && row["NewsId"].ToString() != "")
{
model.NewsId = int.Parse(row["NewsId"].ToString());
}
if (row["OldName"] != null)
{
model.OldName = row["OldName"].ToString();
}
if (row["NewName"] != null)
{
model.NewName = row["NewName"].ToString();
}
if (row["SaveUrl"] != null)
{
model.SaveUrl = row["SaveUrl"].ToString();
}
if (row["Clicked"] != null && row["Clicked"].ToString() != "")
{
model.Clicked = int.Parse(row["Clicked"].ToString());
}
if (row["RecTime"] != null && row["RecTime"].ToString() != "")
{
model.RecTime = DateTime.Parse(row["RecTime"].ToString());
}
if (row["RecIP"] != null)
{
model.RecIP = row["RecIP"].ToString();
}
if (row["FileSize"] != null && row["FileSize"].ToString() != "")
{
model.FileSize = int.Parse(row["FileSize"].ToString());
}
if (row["ImgUrl"] != null)
{
model.ImgUrl = row["ImgUrl"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(SchSystem.Model.WebSchNewsEnc model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into WebSchNewsEnc(");
strSql.Append("NewsId,OldName,NewName,SaveUrl,Clicked,RecTime,RecIP,FileSize,ImgUrl)");
strSql.Append(" values (");
strSql.Append("@NewsId,@OldName,@NewName,@SaveUrl,@Clicked,@RecTime,@RecIP,@FileSize,@ImgUrl)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@NewsId", SqlDbType.Int, 4),
new SqlParameter("@OldName", SqlDbType.VarChar, 50),
new SqlParameter("@NewName", SqlDbType.VarChar, 50),
new SqlParameter("@SaveUrl", SqlDbType.VarChar, 200),
new SqlParameter("@Clicked", SqlDbType.Int, 4),
new SqlParameter("@RecTime", SqlDbType.DateTime),
new SqlParameter("@RecIP", SqlDbType.VarChar, 20),
new SqlParameter("@FileSize", SqlDbType.Int, 4),
new SqlParameter("@ImgUrl", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.NewsId;
parameters[1].Value = model.OldName;
parameters[2].Value = model.NewName;
parameters[3].Value = model.SaveUrl;
parameters[4].Value = model.Clicked;
parameters[5].Value = model.RecTime;
parameters[6].Value = model.RecIP;
parameters[7].Value = model.FileSize;
parameters[8].Value = model.ImgUrl;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SchSystem.Model.WebSchNewsEnc GetModel(int EncId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 EncId,NewsId,OldName,NewName,SaveUrl,Clicked,RecTime,RecIP,FileSize,ImgUrl from WebSchNewsEnc ");
strSql.Append(" where EncId=@EncId");
SqlParameter[] parameters =
{
new SqlParameter("@EncId", SqlDbType.Int, 4)
};
parameters[0].Value = EncId;
SchSystem.Model.WebSchNewsEnc model = new SchSystem.Model.WebSchNewsEnc();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public static Com.DataPack.DataRsp <string> newsaddsave(string arr)
{
SchSystem.Model.WebSchNews schnewsmodel = new SchSystem.Model.WebSchNews();
SchSystem.BLL.WebSchNews schnewsbll = new SchSystem.BLL.WebSchNews();
Com.DataPack.DataRsp <string> rsp = new Com.DataPack.DataRsp <string>();
if (Com.Session.userid == null)
{
rsp.code = "expire";
rsp.msg = "页面已经过期，请重新登录";
}
else
{
try
{
schnews newsresult = JsonConvert.DeserializeObject <schnews>(arr);
if (newsresult.range == "0" && newsresult.gradeid == "")
{
rsp.code = "ExcepError";
rsp.msg = "年级不允许为空";
return(rsp);
}
if (newsresult.range == "0" && newsresult.grdclassid == "")
{
rsp.code = "ExcepError";
rsp.msg = "班级不允许为空";
return(rsp);
}
if (newsresult.range == "1" && newsresult.gradeid == "")
{
rsp.code = "ExcepError";
rsp.msg = "年级不允许为空";
return(rsp);
}
string sss = newsresult.title;
schnewsmodel.Topic = newsresult.title; //標題
schnewsmodel.ChnId = int.Parse(newsresult.column); //欄目
schnewsmodel.Lv = int.Parse(newsresult.range); //範圍
if ((newsresult.range == "1" || newsresult.range == "0") && !string.IsNullOrEmpty(newsresult.gradeid)) //年級ID
{
schnewsmodel.GradeId = int.Parse(newsresult.gradeid);
}
if (newsresult.range == "0" && !string.IsNullOrEmpty(newsresult.grdclassid))//班級ID
{
schnewsmodel.ClassId = int.Parse(newsresult.grdclassid);
}
StringBuilder sbContent = new StringBuilder();
string contents = newsresult.content;
if (!string.IsNullOrEmpty(contents))
{
string[] contentarr = contents.Split('|');
int contentslen = contentarr.Length;
for (int i = 0; i < contentslen; i++)
{
string[] contarr = contentarr[i].Split(',');
sbContent.Append("<section><p class=\"paragraph\">" + contarr[0] + "</p><p class=\"picture\"><img src=\"" + contarr[1] + "\" alt=\"\" /></p></section>");
}
schnewsmodel.Content = sbContent.ToString();//內容
}
if (newsresult.encs.Count > 0)//附件
{
schnewsmodel.IsEnc = 1;
schnewsmodel.Imgurl = newsresult.encs[0].imgurl;
}
if (newsresult.isreference == "True")//是否引用
{
schnewsmodel.IsQuo = 1;
schnewsmodel.QuoUrl = newsresult.textreference;//引用地址
}
else
{
schnewsmodel.IsQuo = 0;
}
if (newsresult.isreply == "True")//是否回復
{
schnewsmodel.IsReply = 1;
}
else
{
schnewsmodel.IsReply = 0;
}
schnewsmodel.SchId = int.Parse(SchId);
schnewsmodel.RecTime = DateTime.Now;
schnewsmodel.RecIP = Public.GetLocalIP().RspData;
schnewsmodel.Stat = 1;
schnewsmodel.Clicked = 0;
schnewsmodel.ChkTime = DateTime.Now;
int resid = schnewsbll.Add(schnewsmodel);//添加新闻
if (resid > 0)
{
SchSystem.Model.WebSchNewsEnc schnewencModel = new SchSystem.Model.WebSchNewsEnc();
SchSystem.BLL.WebSchNewsEnc schnewencBll = new SchSystem.BLL.WebSchNewsEnc();
DataTable dt = new DataTable();
dt.Columns.Add("NewsId");
dt.Columns.Add("OldName");
dt.Columns.Add("NewName");
dt.Columns.Add("SaveUrl");
dt.Columns.Add("Clicked");
dt.Columns.Add("RecTime");
dt.Columns.Add("RecIP");
dt.Columns.Add("FileSize");
dt.Columns.Add("ImgUrl");
int encCount = newsresult.encs.Count;
for (int i = 0; i < encCount; i++)
{
DataRow dr = dt.NewRow();
dr["NewsId"] = resid;
dr["OldName"] = newsresult.encs[i].oldname;
dr["NewName"] = newsresult.encs[i].newname;
dr["SaveUrl"] = newsresult.encs[i].saveurl;
dr["Clicked"] = 1;
dr["RecTime"] = DateTime.Now;
dr["RecIP"] = Public.GetLocalIP().RspData;
dr["FileSize"] = int.Parse(newsresult.encs[i].filesize);
dr["ImgUrl"] = newsresult.encs[i].imgurl;
dt.Rows.Add(dr);
}
rsp.code = "success";
rsp.msg = schnewencBll.ExecuteSqlBulkCopy(dt, "WebSchNewsEnc");//添加附件
}
}
catch (Exception ex)
{
rsp.code = "ExcepError";
rsp.msg = ex.Message;
}
}
return(rsp);
}
