/// <summary>
/// 增加一条数据,及其子表数据
/// </summary>
public int Add(Model.image model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_image(");
strSql.Append("title,sort,img_url,link_url,Typeid,Vipids)");
strSql.Append(" values (");
strSql.Append("@title,@sort,@img_url,@link_url,@Typeid,@Vipids)");
strSql.Append(";set @ReturnValue= @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@title", SqlDbType.NVarChar, 100),
new SqlParameter("@sort", SqlDbType.Int, 4),
new SqlParameter("@img_url", SqlDbType.NVarChar, 200),
new SqlParameter("@link_url", SqlDbType.NVarChar, 100),
new SqlParameter("@Typeid", SqlDbType.Int),
new SqlParameter("@Vipids", SqlDbType.NVarChar),
new SqlParameter("@ReturnValue", SqlDbType.Int)
};
parameters[0].Value = model.title;
parameters[1].Value = model.sort;
parameters[2].Value = model.img_url;
parameters[3].Value = model.link_url;
parameters[4].Value = model.Typeid;
parameters[5].Value = model.Vipids;
parameters[6].Direction = ParameterDirection.Output;
List <CommandInfo> sqllist = new List <CommandInfo>();
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
DbHelperSQL.ExecuteSqlTranWithIndentity(sqllist);
return((int)parameters[6].Value);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.image GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from dt_image ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Model.image model = new Model.image();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
#region 父表信息
if (ds.Tables[0].Rows[0]["id"] != null && ds.Tables[0].Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString());
}
if (ds.Tables[0].Rows[0]["title"] != null && ds.Tables[0].Rows[0]["title"].ToString() != "")
{
model.title = ds.Tables[0].Rows[0]["title"].ToString();
}
if (ds.Tables[0].Rows[0]["sort"] != null && ds.Tables[0].Rows[0]["sort"].ToString() != "")
{
model.sort = int.Parse(ds.Tables[0].Rows[0]["sort"].ToString());
}
if (ds.Tables[0].Rows[0]["img_url"] != null && ds.Tables[0].Rows[0]["img_url"].ToString() != "")
{
model.img_url = ds.Tables[0].Rows[0]["img_url"].ToString();
}
if (ds.Tables[0].Rows[0]["link_url"] != null && ds.Tables[0].Rows[0]["link_url"].ToString() != "")
{
model.link_url = ds.Tables[0].Rows[0]["link_url"].ToString();
}
if (ds.Tables[0].Rows[0]["Typeid"] != null && ds.Tables[0].Rows[0]["Typeid"].ToString() != "")
{
model.Typeid = int.Parse(ds.Tables[0].Rows[0]["Typeid"].ToString());
}
if (ds.Tables[0].Rows[0]["Vipids"] != null && ds.Tables[0].Rows[0]["Vipids"].ToString() != "")
{
model.Vipids = ds.Tables[0].Rows[0]["Vipids"].ToString();
}
#endregion 父表信息end
return(model);
}
else
{
return(null);
}
}
private bool DoEdit(int _id)
{
bool result = true;
DAL.imagedal bll = new DAL.imagedal();
Model.image model = bll.GetModel(_id);
model.title = txtTitle.Text.Trim();
model.sort = Convert.ToInt32(txtSortId.Text);
if (fileUpImage.HasFile)
{
string extendName = fileUpImage.FileName.Substring(fileUpImage.FileName.LastIndexOf('.'));
string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + extendName;
if (!System.IO.Directory.Exists(Server.MapPath("../upload/file/")))
{
System.IO.Directory.CreateDirectory(Server.MapPath("../upload/file/"));
}
fileUpImage.SaveAs(Server.MapPath("../upload/file/" + filename));
model.img_url = "../upload/file/" + filename;
}
else
{
model.img_url = ViewState["file"] == null ? "" : ViewState["file"].ToString();
}
model.Vipids = "";
bool isSelect = false;
for (int i = 0; i < checkSysUser.Items.Count; i++)
{
if (checkSysUser.Items[i].Selected == true)
{
if (i != 0)
{
model.Vipids += checkSysUser.Items[i].Value + ",";
isSelect = true;
}
}
}
if (isSelect == false)
{
model.Vipids = "-1";
}
else
{
model.Vipids = model.Vipids.Trim(',');
}
if (!bll.Update(model))
{
result = false;
}
return(result);
}
private void ShowInfo(int _id)
{
DAL.imagedal bll = new DAL.imagedal();
Model.image model = bll.GetModel(_id);
txtTitle.Text = model.title;
txtSortId.Text = model.sort.ToString();
txtlink_url.Text = model.link_url;
ViewState["file"] = model.img_url;
ddlType.SelectedValue = model.Typeid.ToString();
// LitAlbumList.Text = GetAlbumHtml(model.albums, model.img_url);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.image model)
{
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_image set ");
strSql.Append("title=@title,");
strSql.Append("sort=@sort,");
strSql.Append("img_url=@img_url,");
strSql.Append("link_url=@link_url,");
strSql.Append("Typeid=@Typeid,");
strSql.Append("Vipids=@Vipids");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@title", SqlDbType.NVarChar, 100),
new SqlParameter("@sort", SqlDbType.Int, 4),
new SqlParameter("@img_url", SqlDbType.NVarChar, 200),
new SqlParameter("@link_url", SqlDbType.NVarChar, 100),
new SqlParameter("@Typeid", SqlDbType.Int),
new SqlParameter("@Vipids", SqlDbType.NVarChar),
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = model.title;
parameters[1].Value = model.sort;
parameters[2].Value = model.img_url;
parameters[3].Value = model.link_url;
parameters[4].Value = model.Typeid;
parameters[5].Value = model.Vipids;
parameters[6].Value = model.id;
DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
private bool DoAdd()
{
bool result = true;
Model.image model = new Model.image();
DAL.imagedal bll = new DAL.imagedal();
model.title = txtTitle.Text.Trim();
model.sort = Convert.ToInt32(txtSortId.Text);
model.link_url = txtlink_url.Text;
model.Typeid = Convert.ToInt32(ddlType.SelectedValue);
//儲存相冊
string[] albumArr = Request.Form.GetValues("hide_photo_name");
string[] remarkArr = Request.Form.GetValues("hide_photo_remark");
if (albumArr != null && albumArr.Length >= 0)
{
string[] imgArr = albumArr[0].Split('|');
if (imgArr != null && imgArr.Length >= 1)
{
model.img_url = imgArr[1]; //focus_photo.Value;
}
}
if (fileUpImage.HasFile)
{
string extendName = fileUpImage.FileName.Substring(fileUpImage.FileName.LastIndexOf('.'));
string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + extendName;
if (!System.IO.Directory.Exists(Server.MapPath("../upload/logo/")))
{
System.IO.Directory.CreateDirectory(Server.MapPath("../upload/logo/"));
}
fileUpImage.SaveAs(Server.MapPath("../upload/logo/" + filename));
string url = HttpContext.Current.Request.Url.Host;
model.img_url = "http://" + url + "/upload/logo/" + filename;
}
if (bll.Add(model) < 1)
{
result = false;
}
return(result);
}
private void ShowInfo(int _id)
{
DAL.imagedal bll = new DAL.imagedal();
Model.image model = bll.GetModel(_id);
txtTitle.Text = model.title;
txtSortId.Text = model.sort.ToString();
ViewState["file"] = model.img_url;
// LitAlbumList.Text = GetAlbumHtml(model.albums, model.img_url);
if (!string.IsNullOrEmpty(model.Vipids))
{
for (int i = 0; i < checkSysUser.Items.Count; i++)
{
if (model.Vipids.Contains(checkSysUser.Items[i].Value))
{
checkSysUser.Items[i].Selected = true;
}
}
}
}
private bool DoEdit(int _id)
{
bool result = true;
DAL.imagedal bll = new DAL.imagedal();
Model.image model = bll.GetModel(_id);
model.title = txtTitle.Text.Trim();
model.sort = Convert.ToInt32(txtSortId.Text);
model.link_url = txtlink_url.Text;
model.Typeid = Convert.ToInt32(ddlType.SelectedValue);
if (fileUpImage.HasFile)
{
string extendName = fileUpImage.FileName.Substring(fileUpImage.FileName.LastIndexOf('.'));
string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + extendName;
if (!System.IO.Directory.Exists(Server.MapPath("../upload/logo/")))
{
System.IO.Directory.CreateDirectory(Server.MapPath("../upload/logo/"));
}
fileUpImage.SaveAs(Server.MapPath("../upload/logo/" + filename));
string url = HttpContext.Current.Request.Url.Host;
model.img_url = "http://" + url + "/upload/logo/" + filename;
}
else
{
model.img_url = ViewState["file"] == null ? "" : ViewState["file"].ToString();
}
if (!bll.Update(model))
{
result = false;
}
return(result);
}
private bool DoAdd()
{
bool result = true;
Model.image model = new Model.image();
DAL.imagedal bll = new DAL.imagedal();
model.title = txtTitle.Text.Trim();
model.sort = Convert.ToInt32(txtSortId.Text);
model.Typeid = 3;
//儲存相冊
string[] albumArr = Request.Form.GetValues("hide_photo_name");
string[] remarkArr = Request.Form.GetValues("hide_photo_remark");
if (albumArr != null && albumArr.Length >= 0)
{
string[] imgArr = albumArr[0].Split('|');
if (imgArr != null && imgArr.Length >= 1)
{
model.img_url = imgArr[1]; //focus_photo.Value;
}
}
if (fileUpImage.HasFile)
{
string extendName = fileUpImage.FileName.Substring(fileUpImage.FileName.LastIndexOf('.'));
string filename = DateTime.Now.ToString("yyyyMMddhhmmss") + extendName;
if (!System.IO.Directory.Exists(Server.MapPath("../upload/file/")))
{
System.IO.Directory.CreateDirectory(Server.MapPath("../upload/file/"));
}
fileUpImage.SaveAs(Server.MapPath("../upload/file/" + filename));
model.img_url = "../upload/file/" + filename;
}
model.Vipids = "";
bool isSelect = false;
for (int i = 0; i < checkSysUser.Items.Count; i++)
{
if (checkSysUser.Items[i].Selected == true)
{
model.Vipids += checkSysUser.Items[i].Value + ",";
isSelect = true;
}
}
if (isSelect == false)
{
model.Vipids = "-1";
}
else
{
model.Vipids = model.Vipids.Trim(',');
}
if (bll.Add(model) < 1)
{
result = false;
}
return(result);
}