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