/// <summary>
/// 根据ID返回 app_NewsEntity实体类 单笔资料 ()
/// </summary>
/// <param name="ID">ID </param>
/// <returns>返回 app_NewsEntity实体类 ID为0则无记录</returns>
public static app_NewsEntity app_NewsDisp(Int32 ID)
{
app_NewsEntity fam = new app_NewsEntity();
QueryParam qp = new QueryParam();
qp.PageIndex = 1;
qp.PageSize = 1;
qp.Where = string.Format(" Where {0}.{1} = {2}","app_News","ID",ID);
int RecordCount = 0;
List<app_NewsEntity> lst = app_NewsList(qp, out RecordCount);
if (RecordCount > 0)
{
fam = lst[0];
}
return fam;
}
/// <summary>
/// 新增/删除/修改 app_NewsEntity ()
/// </summary>
/// <param name="fam">app_NewsEntity实体类</param>
/// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns>
public static Int32 app_NewsInsertUpdateDelete(app_NewsEntity fam)
{
return DataProvider.Instance().app_NewsInsertUpdateDelete(fam);
}
/// <summary> /// 新增/删除/修改 app_NewsEntity () /// </summary> /// <param name="fam">app_News实体类</param> /// <returns>-1:存储过程执行失败,-2:存在相同的主键,Insert:返回插入自动ID,Update:返回更新记录数,Delete:返回删除记录数</returns> public abstract Int32 app_NewsInsertUpdateDelete(app_NewsEntity fam);
/// <summary>
/// 将记录集转为app_NewsEntity实体类 ()
/// </summary>
/// <param name="dr">记录集</param>
/// <param name="Fileds">字段名列表</param>
/// <returns>app_NewsEntity</returns>
protected app_NewsEntity Populateapp_NewsEntity(IDataReader dr,Dictionary<string,string> Fileds)
{
app_NewsEntity nc = new app_NewsEntity();
if (Fileds.ContainsKey("ID") && !Convert.IsDBNull(dr["ID"])) nc.ID = Convert.ToInt32(dr["ID"]); //
if (Fileds.ContainsKey("Title") && !Convert.IsDBNull(dr["Title"])) nc.Title = Convert.ToString(dr["Title"]); // 标题
if (Fileds.ContainsKey("Author") && !Convert.IsDBNull(dr["Author"])) nc.Author = Convert.ToString(dr["Author"]); // 作者
if (Fileds.ContainsKey("AddTime") && !Convert.IsDBNull(dr["AddTime"])) nc.AddTime = Convert.ToDateTime(dr["AddTime"]); // 加入时间
if (Fileds.ContainsKey("Content") && !Convert.IsDBNull(dr["Content"])) nc.Content = Convert.ToString(dr["Content"]); // 内容
if (Fileds.ContainsKey("ImagePath") && !Convert.IsDBNull(dr["ImagePath"])) nc.ImagePath = Convert.ToString(dr["ImagePath"]); // 图片路径
if (Fileds.ContainsKey("ImageComment") && !Convert.IsDBNull(dr["ImageComment"])) nc.ImageComment = Convert.ToString(dr["ImageComment"]); // 图片注释
if (Fileds.ContainsKey("ReCommand") && !Convert.IsDBNull(dr["ReCommand"])) nc.ReCommand = Convert.ToBoolean(dr["ReCommand"]); // 是否为推荐新闻
return nc;
}
/************************************************************************/
/* 上传新闻图片 */
/************************************************************************/
private string UploadPic(app_NewsEntity ut)
{
FileUpLoadCommon fc = new FileUpLoadCommon(Common.UpLoadDir + "NewsImages/", false);
// 如果图片上传成功
if(fc.SaveFile(ImageUpload, true))
{
//删除原有图片
removeImge(ut);
}
return fc.newFileName;
}
/// <summary>
/// 初始化数据
/// </summary>
/// <param name="ut"></param>
private void OnStartData(app_NewsEntity ut)
{
Title_Input.Text = Title_Disp.Text = ut.Title.ToString();
Author_Input.Text = Author_Disp.Text = ut.Author.ToString();
if (ut.AddTime == null || ut.AddTime.ToString().Length == 0)
{
ut.AddTime = DateTime.Now;
}
AddTime_Input.Text = AddTime_Disp.Text = Common.ConvertDate(ut.AddTime);
Content_Input.Text = Content_Disp.Text = ut.Content.ToString();
if ((ut.ImagePath + "").Trim() != "")
{
News_Image.ImageUrl = Common.BuildDownFileUrl("NewsImages/s_" + ut.ImagePath);
//MaxImgUrl = Common.BuildDownFileUrl("NewsImages/" + ut.U_PhotoUrl);
}
ImagePath_Input.Text = ImagePath_Disp.Text = ut.ImagePath.ToString();
ImageComment_Input.Text = ImageComment_Disp.Text = ut.ImageComment.ToString();
ReCommand_Input.SelectedValue = Convert.ToInt32(ut.ReCommand).ToString();
ReCommand_Disp.Text = ut.ReCommand.ToString();
}
/// <summary>
/// 删除图片
/// </summary>
private static void removeImge(app_NewsEntity ut)
{
if (ut.ImagePath.Length > 0)
{
FileUpLoadCommon.DeleteFile(string.Format("{0}{1}{2}", Common.UpLoadDir, "NewsImages/", ut.ImagePath));
FileUpLoadCommon.DeleteFile(string.Format("{0}{1}s_{2}", Common.UpLoadDir, "NewsImages/", ut.ImagePath));
}
}
protected void Button2_Click(object sender, EventArgs e)
{
string Checkbox_Value = (string)Common.sink("Checkbox", MethodType.Post, 2000, 1, DataType.Str);
string[] Checkbox_Value_Array = Checkbox_Value.Split(',');
Int32 IDX = 0;
for (int i = 0; i < Checkbox_Value_Array.Length; i++)
{
if (Int32.TryParse(Checkbox_Value_Array[i], out IDX))
{
app_NewsEntity et = new app_NewsEntity();
et.DataTable_Action_ = DataTable_Action.Delete;
et.ID = IDX;
BusinessFacadeFrameWork.app_NewsInsertUpdateDelete(et);
}
}
EventMessage.MessageBox(1, "批量删除成功", string.Format("批量删除({0})成功!", Checkbox_Value), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx"));
}
