private void LoadData(string strType)
{
if (strType == "1")
{
string strID = Request.QueryString["value"];//操作ID
zlzw.BLL.PartnersJobListBLL partnersJobListBLL = new zlzw.BLL.PartnersJobListBLL();
zlzw.Model.PartnersJobListModel partnersJobListModel = partnersJobListBLL.GetModel(int.Parse(strID));
drpPartnerGUID.SelectedValue = partnersJobListModel.PartnerGUID.ToString();
txbWorkAdd.Text = partnersJobListModel.WorkAdd; //工作地点
txbPostInfo.Text = partnersJobListModel.PostInfo; //招聘职位
txbRecruitmentNumber.Text = partnersJobListModel.RecruitmentNumber; //招聘人数
txbPostDemand.Text = partnersJobListModel.PostDemand; //岗位要求
txbTreatmentInfo.Text = partnersJobListModel.TreatmentInfo; //待遇相关
txbOtherInfo.Text = partnersJobListModel.OtherInfo; //备注信息
//if (partnersJobListModel.IsHot == 1)
//{
// ckbIsHot.Checked = true;
//}
//else
//{
// ckbIsHot.Checked = false;
//}
ViewState["PublishDate"] = partnersJobListModel.PublishDate.ToString();
ViewState["PartnerGUID"] = partnersJobListModel.PartnerGUID.ToString();
ToolbarText2.Text = "编辑一个合作伙伴职位信息";
}
btnClose.OnClientClick = ActiveWindow.GetConfirmHideReference();
}
protected void btnDel_Click(object sender, EventArgs e)
{
if (grid1.SelectedRowIndexArray != null && grid1.SelectedRowIndexArray.Length > 0)
{
string strSelectID = "0";
for (int i = 0, count = grid1.SelectedRowIndexArray.Length; i < count; i++)
{
int rowIndex = grid1.SelectedRowIndexArray[i];
foreach (object key in grid1.DataKeys[rowIndex])
{
strSelectID = key.ToString();
}
}
#region 除逻辑
zlzw.BLL.PartnersJobListBLL partnersJobListBLL = new zlzw.BLL.PartnersJobListBLL();
zlzw.Model.PartnersJobListModel partnersJobListModel = partnersJobListBLL.GetModel(int.Parse(strSelectID));
partnersJobListModel.IsEnable = 0;
partnersJobListBLL.Update(partnersJobListModel);
PostList_BindGrid();
#endregion
}
else
{
return;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public zlzw.Model.PartnersJobListModel DataRowToModel(DataRow row)
{
zlzw.Model.PartnersJobListModel model = new zlzw.Model.PartnersJobListModel();
if (row != null)
{
if (row["PartnersJobID"] != null && row["PartnersJobID"].ToString() != "")
{
model.PartnersJobID = int.Parse(row["PartnersJobID"].ToString());
}
if (row["PartnerGUID"] != null && row["PartnerGUID"].ToString() != "")
{
model.PartnerGUID = new Guid(row["PartnerGUID"].ToString());
}
if (row["WorkAdd"] != null)
{
model.WorkAdd = row["WorkAdd"].ToString();
}
if (row["RecruitmentNumber"] != null)
{
model.RecruitmentNumber = row["RecruitmentNumber"].ToString();
}
if (row["PostInfo"] != null)
{
model.PostInfo = row["PostInfo"].ToString();
}
if (row["PostDemand"] != null)
{
model.PostDemand = row["PostDemand"].ToString();
}
if (row["TreatmentInfo"] != null)
{
model.TreatmentInfo = row["TreatmentInfo"].ToString();
}
if (row["OtherInfo"] != null)
{
model.OtherInfo = row["OtherInfo"].ToString();
}
if (row["IsEnable"] != null && row["IsEnable"].ToString() != "")
{
model.IsEnable = int.Parse(row["IsEnable"].ToString());
}
if (row["IsHot"] != null && row["IsHot"].ToString() != "")
{
model.IsHot = int.Parse(row["IsHot"].ToString());
}
if (row["PublishDate"] != null && row["PublishDate"].ToString() != "")
{
model.PublishDate = DateTime.Parse(row["PublishDate"].ToString());
}
if (row["Other01"] != null)
{
model.Other01 = row["Other01"].ToString();
}
if (row["Other02"] != null)
{
model.Other02 = row["Other02"].ToString();
}
}
return(model);
}
protected void btnSaveRefresh_Click(object sender, EventArgs e)
{
if (Request.QueryString["Type"] == "1")
{
//编辑保存
zlzw.Model.PartnersJobListModel partnersJobListModel = new zlzw.Model.PartnersJobListModel();
partnersJobListModel.PartnerGUID = new Guid(drpPartnerGUID.SelectedValue);
partnersJobListModel.WorkAdd = txbWorkAdd.Text; //工作地点
partnersJobListModel.PostInfo = txbPostInfo.Text; //招聘职位
partnersJobListModel.RecruitmentNumber = txbRecruitmentNumber.Text; //招聘人数
partnersJobListModel.PostDemand = txbPostDemand.Text; //岗位要求
partnersJobListModel.TreatmentInfo = txbTreatmentInfo.Text; //待遇相关
partnersJobListModel.OtherInfo = txbOtherInfo.Text; //备注信息
partnersJobListModel.IsEnable = 1;
//if (ckbIsHot.Checked)
//{
// partnersJobListModel.IsHot = 1;
//}
//else
//{
// partnersJobListModel.IsHot = 0;
//}
partnersJobListModel.PublishDate = DateTime.Parse(ViewState["PublishDate"].ToString());
partnersJobListModel.PartnerGUID = new Guid(ViewState["PartnerGUID"].ToString());
partnersJobListModel.PartnersJobID = int.Parse(Request.QueryString["value"]);
zlzw.BLL.PartnersJobListBLL partnersJobListBLL = new zlzw.BLL.PartnersJobListBLL();
partnersJobListBLL.Update(partnersJobListModel);
}
else
{
//添加保存
zlzw.Model.PartnersJobListModel partnersJobListModel = new zlzw.Model.PartnersJobListModel();
partnersJobListModel.PartnerGUID = new Guid(drpPartnerGUID.SelectedValue);
partnersJobListModel.WorkAdd = txbWorkAdd.Text; //工作地点
partnersJobListModel.PostInfo = txbPostInfo.Text; //招聘职位
partnersJobListModel.RecruitmentNumber = txbRecruitmentNumber.Text; //招聘人数
partnersJobListModel.PostDemand = txbPostDemand.Text; //岗位要求
partnersJobListModel.TreatmentInfo = txbTreatmentInfo.Text; //待遇相关
partnersJobListModel.OtherInfo = txbOtherInfo.Text; //备注信息
partnersJobListModel.IsEnable = 1;
//if (ckbIsHot.Checked)
//{
// partnersJobListModel.IsHot = 1;
//}
//else
//{
// partnersJobListModel.IsHot = 0;
//}
partnersJobListModel.PublishDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
zlzw.BLL.PartnersJobListBLL partnersJobListBLL = new zlzw.BLL.PartnersJobListBLL();
partnersJobListBLL.Add(partnersJobListModel);
}
// 2. Close this window and Refresh parent window
PageContext.RegisterStartupScript(ActiveWindow.GetHideRefreshReference());
}
public string Get_GetPartnersJob(string strID)
{
zlzw.BLL.PartnersJobListBLL partnersJobListBLL = new zlzw.BLL.PartnersJobListBLL();
zlzw.Model.PartnersJobListModel partnersJobListModel = partnersJobListBLL.GetModel(int.Parse(strID));
System.Text.StringBuilder strBuilder = new System.Text.StringBuilder();
strBuilder.Append("<table style='font-size:14px;'>");
strBuilder.Append("<tr>");
strBuilder.Append("<td>");
strBuilder.Append("<p>企业名称：" + Get_EnterpriseName(partnersJobListModel.PartnerGUID.ToString()));
strBuilder.Append("</p></td>");
strBuilder.Append("</tr>");
strBuilder.Append("<tr>");
strBuilder.Append("<td>");
strBuilder.Append("<p>发布日期：" + DateTime.Parse(partnersJobListModel.PublishDate.ToString()).ToString("yyyy年MM月dd"));
strBuilder.Append("</p></td>");
strBuilder.Append("</tr>");
strBuilder.Append("<tr>");
strBuilder.Append("<td>");
strBuilder.Append("<p>职位信息：" + partnersJobListModel.PostInfo);
strBuilder.Append("</p></td>");
strBuilder.Append("</tr>");
strBuilder.Append("<tr>");
strBuilder.Append("<td>");
strBuilder.Append("<p>工作地点：" + partnersJobListModel.WorkAdd);
strBuilder.Append("</p></td>");
strBuilder.Append("</tr>");
strBuilder.Append("<tr>");
strBuilder.Append("<td>");
strBuilder.Append("<p>岗位要求：<br/><br/>" + partnersJobListModel.PostDemand);
strBuilder.Append("</p></td>");
strBuilder.Append("</tr>");
strBuilder.Append("<tr>");
strBuilder.Append("<td>");
strBuilder.Append("<p>待遇相关：<br/><br/>" + partnersJobListModel.TreatmentInfo);
strBuilder.Append("</p></td>");
strBuilder.Append("</tr>");
strBuilder.Append("<tr>");
strBuilder.Append("<td>");
strBuilder.Append("<p>其他信息：<br/><br/>" + partnersJobListModel.OtherInfo);
strBuilder.Append("</p></td>");
strBuilder.Append("</tr>");
strBuilder.Append("</table>");
return(strBuilder.ToString());
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(zlzw.Model.PartnersJobListModel model)
{
int rowsAffected = 0;
SqlParameter[] parameters =
{
new SqlParameter("@PartnersJobID", SqlDbType.Int, 4),
new SqlParameter("@PartnerGUID", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@WorkAdd", SqlDbType.NVarChar, 200),
new SqlParameter("@RecruitmentNumber", SqlDbType.NVarChar, 50),
new SqlParameter("@PostInfo", SqlDbType.NVarChar, 200),
new SqlParameter("@PostDemand", SqlDbType.NVarChar, -1),
new SqlParameter("@TreatmentInfo", SqlDbType.NVarChar, -1),
new SqlParameter("@OtherInfo", SqlDbType.NVarChar, -1),
new SqlParameter("@IsEnable", SqlDbType.Int, 4),
new SqlParameter("@IsHot", SqlDbType.Int, 4),
new SqlParameter("@PublishDate", SqlDbType.DateTime),
new SqlParameter("@Other01", SqlDbType.NVarChar, 50),
new SqlParameter("@Other02", SqlDbType.NVarChar, 200)
};
parameters[0].Value = model.PartnersJobID;
parameters[1].Value = model.PartnerGUID;
parameters[2].Value = model.WorkAdd;
parameters[3].Value = model.RecruitmentNumber;
parameters[4].Value = model.PostInfo;
parameters[5].Value = model.PostDemand;
parameters[6].Value = model.TreatmentInfo;
parameters[7].Value = model.OtherInfo;
parameters[8].Value = model.IsEnable;
parameters[9].Value = model.IsHot;
parameters[10].Value = model.PublishDate;
parameters[11].Value = model.Other01;
parameters[12].Value = model.Other02;
DbHelperSQL.RunProcedure("PartnersJobList_Update", parameters, out rowsAffected);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public zlzw.Model.PartnersJobListModel GetModel(int PartnersJobID)
{
SqlParameter[] parameters =
{
new SqlParameter("@PartnersJobID", SqlDbType.Int, 4)
};
parameters[0].Value = PartnersJobID;
zlzw.Model.PartnersJobListModel model = new zlzw.Model.PartnersJobListModel();
DataSet ds = DbHelperSQL.RunProcedure("PartnersJobList_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
