/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ZhongLi.Model.JobTraining model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@JobTraID", SqlDbType.Int, 4),
new SqlParameter("@JobTraType", SqlDbType.NVarChar, 50),
new SqlParameter("@JobTraName", SqlDbType.NVarChar, 50),
new SqlParameter("@Phone", SqlDbType.NVarChar, 50),
new SqlParameter("@JobTraDes", SqlDbType.NVarChar, -1),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@Imgurl", SqlDbType.NVarChar, 200),
new SqlParameter("@AbsDes", SqlDbType.NVarChar, 200),
new SqlParameter("@JobTraTitle", SqlDbType.NVarChar, 50)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.JobTraType;
parameters[2].Value = model.JobTraName;
parameters[3].Value = model.Phone;
parameters[4].Value = model.JobTraDes;
parameters[5].Value = model.Sort;
parameters[6].Value = model.Imgurl;
parameters[7].Value = model.AbsDes;
parameters[8].Value = model.JobTraTitle;
DbHelperSQL.RunProcedure("JobTraining_ADD", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Utils.CheckRole("6"))
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('权限信息','没有权限！','/Systestcomjun/index.aspx',2)</script>");
return;
}
if (!IsPostBack)
{
ZhongLi.Model.siteconfig site = new ZhongLi.Bll.siteconfig().loadConfig(Server.MapPath("/xmlconfig/site.config"));
imgformat = site.ImgFormat;
txtSort.Text = "20";
ltlTitle.Text = "新增职位信息";
if (Request.QueryString["JobTraID"] != null)
{
ltlTitle.Text = "修改职位信息";
int JobTraID = Convert.ToInt32(Request.QueryString["JobTraID"]);
ZhongLi.Model.JobTraining jt = bll.GetModel(JobTraID);
rbtType.SelectedValue = jt.JobTraType;
txtJobTraTitle.Text = jt.JobTraTitle;
txtJobTraName.Text = jt.JobTraName;
txtPhone.Text = jt.Phone;
txtSort.Text = jt.Sort + "";
txtAbsDes.Text = jt.AbsDes;
txtJobTraDes.Text = jt.JobTraDes;
if (jt.Imgurl != "")
{
img_Photo.ImageUrl = jt.Imgurl;
}
}
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
ZhongLi.Model.JobTraining jt = null;
if (Request.QueryString["JobTraID"] != null)
{
jt = bll.GetModel(Convert.ToInt32(Request.QueryString["JobTraID"]));
}
else
{
jt = new ZhongLi.Model.JobTraining();
}
jt.JobTraTitle = txtJobTraTitle.Text;
jt.JobTraName = txtJobTraName.Text;
jt.Phone = txtPhone.Text;
jt.JobTraType = rbtType.SelectedValue;
jt.Sort = Convert.ToInt32(txtSort.Text);
jt.AbsDes = txtAbsDes.Text;
jt.JobTraDes = txtJobTraDes.Text;
ZhongLi.Model.siteconfig site = new ZhongLi.Bll.siteconfig().loadConfig(Server.MapPath("/xmlconfig/site.config"));
if (fileImg.HasFile)
{
if (fileImg.PostedFile.ContentLength <= site.FileSize * 1024)
{
string fileExt = Utils.GetFileExt(fileImg.FileName);
string newname = DateTime.Now.ToString("yyyyMMddHHmmssffff") + "." + fileExt;
string filePath = Utils.GetMapPath("/upload/news/") + newname;
fileImg.SaveAs(filePath);
jt.Imgurl = "/upload/news/" + newname;
}
}
if (jt.JobTraID == 0)
{
if (bll.Add(jt) > 0)
{
webHelper.addLog("新添加了职位信息“" + jt.JobTraTitle + "”");
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('新增职位信息','保存成功！','',1)</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('新增职位信息','保存失败','',2)</script>");
}
}
else
{
if (bll.Update(jt))
{
webHelper.addLog("修改了职位信息“" + jt.JobTraTitle + "”");
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('编辑职位信息','保存成功！','',1)</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(Page.GetType(), "set", "<script>window.onload=showmsgclose('编辑职位信息','保存失败','',2);</script>");
}
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZhongLi.Model.JobTraining DataRowToModel(DataRow row)
{
ZhongLi.Model.JobTraining model = new ZhongLi.Model.JobTraining();
if (row != null)
{
if (row["JobTraID"] != null && row["JobTraID"].ToString() != "")
{
model.JobTraID = int.Parse(row["JobTraID"].ToString());
}
if (row["JobTraType"] != null)
{
model.JobTraType = row["JobTraType"].ToString();
}
if (row["JobTraName"] != null)
{
model.JobTraName = row["JobTraName"].ToString();
}
if (row["Phone"] != null)
{
model.Phone = row["Phone"].ToString();
}
if (row["JobTraDes"] != null)
{
model.JobTraDes = row["JobTraDes"].ToString();
}
if (row["Sort"] != null && row["Sort"].ToString() != "")
{
model.Sort = int.Parse(row["Sort"].ToString());
}
if (row["Imgurl"] != null)
{
model.Imgurl = row["Imgurl"].ToString();
}
if (row["AbsDes"] != null)
{
model.AbsDes = row["AbsDes"].ToString();
}
if (row["JobTraTitle"] != null)
{
model.JobTraTitle = row["JobTraTitle"].ToString();
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ZhongLi.Model.JobTraining GetModel(int JobTraID)
{
SqlParameter[] parameters =
{
new SqlParameter("@JobTraID", SqlDbType.Int, 4)
};
parameters[0].Value = JobTraID;
ZhongLi.Model.JobTraining model = new ZhongLi.Model.JobTraining();
DataSet ds = DbHelperSQL.RunProcedure("JobTraining_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
BindNews();
string type = Request["type"];
string id = Request["id"];
switch (type)
{
case "news":
NEWM = NEW.GetModel(Convert.ToInt32(id));
title = NEWM.Title;
count = NEWM.NewsCon;
time = "发表时间：" + NEWM.CreateTime.ToString();
break;
case "jo":
jom = jo.GetModel(Convert.ToInt32(id));
title = jom.JobTraTitle;
count = jom.JobTraDes;
time = "";
break;
case "cp":
cpm = cp.GetModel(Convert.ToInt32(id));
title = cpm.CPTitle;
count = cpm.CPDes;
time = "发表时间：" + cpm.CreateTime.ToString();
break;
}
ZhongLi.Model.siteconfig config = new ZhongLi.Bll.siteconfig().loadConfig(Server.MapPath("/xmlconfig/site.config"));
log = config.log;
phone = config.phone;
mail = config.mail;
bjtu = config.bgtu;
QRCode = config.QRCode;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ZhongLi.Model.JobTraining model)
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@JobTraID", SqlDbType.Int, 4),
new SqlParameter("@JobTraType", SqlDbType.NVarChar, 50),
new SqlParameter("@JobTraName", SqlDbType.NVarChar, 50),
new SqlParameter("@Phone", SqlDbType.NVarChar, 50),
new SqlParameter("@JobTraDes", SqlDbType.NVarChar, -1),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@Imgurl", SqlDbType.NVarChar, 200),
new SqlParameter("@AbsDes", SqlDbType.NVarChar, 200),
new SqlParameter("@JobTraTitle", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.JobTraID;
parameters[1].Value = model.JobTraType;
parameters[2].Value = model.JobTraName;
parameters[3].Value = model.Phone;
parameters[4].Value = model.JobTraDes;
parameters[5].Value = model.Sort;
parameters[6].Value = model.Imgurl;
parameters[7].Value = model.AbsDes;
parameters[8].Value = model.JobTraTitle;
DbHelperSQL.RunProcedure("JobTraining_Update", parameters, out rowsAffected);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
