public bool Add_Paragraph(String Text, int id)
{
try
{
Text_Model Paragraph = new Text_Model
{
Text = Text,
Ownership_Id = "VesterGade_543v92_sjdhs_Para_7jdh45d_Graph"
};
if (id == 2)
{
Paragraph.Ownership_Id = "Follow_7fdkf67-6467-gade_076470-45h4a-e14dh5kjd5445even";
}
_Data.Text_Model.Add(Paragraph);
_Data.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Text_Model model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.TEXT_TITLE != null)
{
strSql1.Append("TEXT_TITLE,");
strSql2.Append("'" + model.TEXT_TITLE + "',");
}
if (model.TEXT_DESCRIPT != null)
{
strSql1.Append("TEXT_DESCRIPT,");
strSql2.Append("'" + model.TEXT_DESCRIPT + "',");
}
if (model.TEXT_CONTENT != null)
{
strSql1.Append("TEXT_CONTENT,");
strSql2.Append("'" + model.TEXT_CONTENT + "',");
}
if (model.IMGPATH != null)
{
strSql1.Append("IMGPATH,");
strSql2.Append("'" + model.IMGPATH + "',");
}
if (model.TEXT_AUTHOR != null)
{
strSql1.Append("TEXT_AUTHOR,");
strSql2.Append("'" + model.TEXT_AUTHOR + "',");
}
if (model.CREATE_TIME != null)
{
strSql1.Append("CREATE_TIME,");
strSql2.Append("'" + model.CREATE_TIME + "',");
}
if (model.CATEGORY_ID != null)
{
strSql1.Append("CATEGORY_ID,");
strSql2.Append("" + model.CATEGORY_ID + ",");
}
strSql.Append("insert into COM_TEXT(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
object obj = DbHelperSQL.GetSingle(strSql.ToString());
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
//添加
protected void Button1_Click(object sender, EventArgs e)
{
//string uppath = "";//用于保存图片上传路径
//获取上传图片的文件名
string fileFullname = this.FileUpload1.FileName;
//获取图片上传的时间，以时间作为图片的名字可以防止图片重名
//string dataName = DateTime.Now.ToString("yyMMddhhmmss");
//获取图片的文件名（不含扩展名）
string fileName = fileFullname.Substring(fileFullname.LastIndexOf("\\") + 1);
//获取图片扩展名
string type = fileFullname.Substring(fileFullname.LastIndexOf(".") + 1);
string picName = DateTime.Now.ToString("yyyyMMddhhssmmfff");
//判断是否为要求的格式
if (type == "bmp" || type == "jpg" || type == "jpeg" || type == "gif" || type == "JPG" || type == "JPEG" ||
type == "BMP" || type == "GIF" || type == "png" || type == "PNG")
{
//将图片上传到指定路径的文件夹
FileUpload1.SaveAs(Server.MapPath("../NewsImage") + "\\" + picName + "." + type);
//将路径保存到变量，将该变量的值保存到数据库相应字段即可
txtpath.Text = "../NewsImage/" + picName + "." + type;
//txtpath.Text = uppath;
}
string TEXT_TITLE = this.textitle.Text;
string TEXT_DESCRIPT = this.textdesc.Text;
string TEXT_AUTHOR = this.textauthor.Text;
string TEXT_CONTENT = this.txtEditorContents.Value.ToString();
string CATEGORY_ID = this.ddlTypeList.SelectedValue;
Text_Model model = new Text_Model();
model.TEXT_TITLE = TEXT_TITLE;
model.TEXT_DESCRIPT = TEXT_DESCRIPT;
model.TEXT_AUTHOR = TEXT_AUTHOR;
model.IMGPATH = txtpath.Text.ToString();//图片路径
model.TEXT_CONTENT = TEXT_CONTENT;
model.CREATE_TIME = DateTime.Now;
model.CATEGORY_ID = Convert.ToInt32(CATEGORY_ID);
Text_Bll bll = new Text_Bll();
int i = bll.Add(model);
if (i > 0)
{
Response.Write("<script>alert('新增成功！');window.location.href='com_text_list.aspx';</script>");
}
else
{
Response.Write("<script>alert('新增失败！');window.location.href='com_text_list.aspx';</script>");
}
}
public bool Add_Paragraph(String Text)
{
try
{
Text_Model Paragraph = new Text_Model();
Paragraph.Text = Text;
Paragraph.Ownership_Id = "Text_23792_sjdhs_Para_745nfd_Graph";
_Data.Text_Model.Add(Paragraph);
_Data.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int TEXT_ID = Convert.ToInt32(Request.Params["text_id"]);
string TEXT_TITLE = this.textitle.Text;
string TEXT_DESCRIPT = this.textdesc.Text;
string TEXT_AUTHOR = this.textauthor.Text;
string TEXT_CONTENT = this.txtEditorContents.Value.ToString();
string CATEGORY_ID = this.ddlTypeList.SelectedValue;
Text_Model model = new Text_Model();
model.TEXT_ID = TEXT_ID;
model.TEXT_TITLE = TEXT_TITLE;
model.TEXT_DESCRIPT = TEXT_DESCRIPT;
model.TEXT_AUTHOR = TEXT_AUTHOR;
model.TEXT_CONTENT = TEXT_CONTENT;
model.CATEGORY_ID = Convert.ToInt32(CATEGORY_ID);
model.CREATE_TIME = DateTime.Now;
string fileFullname = this.FileUpload1.FileName;
string fileName = fileFullname.Substring(fileFullname.LastIndexOf("\\") + 1);
string type = fileFullname.Substring(fileFullname.LastIndexOf(".") + 1);
string picName = DateTime.Now.ToString("yyyyMMddhhssmmfff");
if (type == "bmp" || type == "jpg" || type == "jpeg" || type == "gif" || type == "JPG" || type == "JPEG" || type == "BMP" || type == "GIF" || type == "png" || type == "PNG")
{
FileUpload1.SaveAs(Server.MapPath("../NewsImage") + "\\" + picName + "." + type);
Text = "../NewsImage/" + picName + "." + type;
}
if (lj.Value == Text)//值相等
{
model.IMGPATH = lj.Value.ToString();
}
else if (fileFullname == null || fileFullname == "")//值等于空
{
model.IMGPATH = lj.Value.ToString();
}
else if (lj.Value == "")
{
model.IMGPATH = Text.ToString();
}
else if (Text != "")
{
model.IMGPATH = Text.ToString();
}
else
{
model.IMGPATH = lj.Value;
}
//更改选择状态，如果添加，则此设备状态改为，已经使用
bool i = bll.Update(model);
if (i)
{
Response.Write("<script>alert('保存成功！');window.location.href='com_text_list.aspx';</script>");
}
else
{
Response.Write("<script>alert(保存失败！');window.location.href='com_text_list.aspx';</script>");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Text_Model model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update COM_TEXT set ");
if (model.TEXT_TITLE != null)
{
strSql.Append("TEXT_TITLE='" + model.TEXT_TITLE + "',");
}
else
{
strSql.Append("TEXT_TITLE= null ,");
}
if (model.TEXT_DESCRIPT != null)
{
strSql.Append("TEXT_DESCRIPT='" + model.TEXT_DESCRIPT + "',");
}
else
{
strSql.Append("TEXT_DESCRIPT= null ,");
}
if (model.TEXT_CONTENT != null)
{
strSql.Append("TEXT_CONTENT='" + model.TEXT_CONTENT + "',");
}
else
{
strSql.Append("TEXT_CONTENT= null ,");
}
if (model.IMGPATH != null)
{
strSql.Append("IMGPATH='" + model.IMGPATH + "',");
}
else
{
strSql.Append("IMGPATH= null ,");
}
if (model.TEXT_AUTHOR != null)
{
strSql.Append("TEXT_AUTHOR='" + model.TEXT_AUTHOR + "',");
}
else
{
strSql.Append("TEXT_AUTHOR= null ,");
}
if (model.CREATE_TIME != null)
{
strSql.Append("CREATE_TIME='" + model.CREATE_TIME + "',");
}
else
{
strSql.Append("CREATE_TIME= null ,");
}
if (model.CATEGORY_ID != null)
{
strSql.Append("CATEGORY_ID=" + model.CATEGORY_ID + ",");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where TEXT_ID=" + model.TEXT_ID + "");
int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Text_Model model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Text_Model model)
{
return(dal.Add(model));
}