public static KaoguanZhaopin GetKgZPbyId(int id)
{
String sql = "select kaoguanzhaopin.id as Id, " +
"kgid," +
"zpid," +
"weight " +
" from kaoguanzhaopin,kaoguan,zhaopin,department " +
" where kaoguanzhaopin.kgid=kaoguan.id and kaoguan.kgstate=1 " +
" and kaoguanzhaopin.zpid= zhaopin.id " +
" and zhaopin.id in (select zhaopin.id from zhaopin,zpfb,zpgw,department " +
" where zhaopin.zpfbid=zpfb.id and zpfb.fbstate=1 and zhaopin.zpstate=1 " +
" and zpfb.zpgwid=zpgw.id and zpgw.zpbm=department.id and department.bmstate=1 ) " +
" and department.id=kaoguan.depart and department.bmstate=1 " +
" and kaoguanzhaopin.id=" + id;
DataTable dt = MySqlDBHelper.GetDataSet(sql);
KaoguanZhaopin kgzp = new KaoguanZhaopin();
foreach (DataRow dr in dt.Rows)
{
kgzp.Id = (int)dr["Id"];
kgzp.KaoguanID = Convert.ToInt32(dr["kgid"].ToString());
kgzp.ZhaopinID = Convert.ToInt32(dr["zpid"].ToString());
kgzp.Weight = Convert.ToInt32(dr["weight"].ToString());
return(kgzp);
}
return(null);
}
public static int Add(KaoguanZhaopin kz)
{
String sql = "insert into kaoguanzhaopin(kgid,zpid,weight) values(@kgid,@zpid,@weight)";
List <MySqlParameter> para_list = new List <MySqlParameter>();
para_list.Add(new MySqlParameter("@kgid", kz.KaoguanID));
para_list.Add(new MySqlParameter("@zpid", kz.ZhaopinID));
para_list.Add(new MySqlParameter("@weight", kz.Weight));
return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray()));
}
protected void AddYpz_Click(object sender, EventArgs e)
{
string[] res = hdfWPBH.Value.Split(',');
for (int i = 0; i < res.Length - 1; i++)
{
int id = Convert.ToInt32(res[i]);
//
KaoguanZhaopin kgzp = new KaoguanZhaopin();
kgzp.KaoguanID = id;
kgzp.ZhaopinID = zpid;
kgzp.Weight = 0;
FTInterviewBLL.KaoguanZhaopinManage.Add(kgzp);
}
BindData();
}
public static List <KaoguanZhaopin> GetKgZPbyzpId(int zpid)
{
String sql = "select kaoguanzhaopin.id as Id, " +
"kgid," +
"zpid," +
"weight, " +
" kaoguan.name as KgName," +
" department.departname as KgDepName," +
" kaoguan.position as KgDuty " +
" from kaoguanzhaopin,kaoguan,department,zhaopin " +
" where kaoguanzhaopin.kgid=kaoguan.id and kaoguan.kgstate=1 " +
" and kaoguan.depart=department.id and department.bmstate=1 " +
" and zhaopin.id=kaoguanzhaopin.zpid " +
" and zhaopin.id in (select zhaopin.id from zhaopin,zpfb,zpgw,department " +
" where zhaopin.zpfbid=zpfb.id and zpfb.fbstate=1 and zhaopin.zpstate=1 " +
" and zpfb.zpgwid=zpgw.id and zpgw.zpbm=department.id and department.bmstate=1 ) " +
"and kaoguanzhaopin.zpid=" + zpid + " order by department.id ";
DataTable dt = MySqlDBHelper.GetDataSet(sql);
List <KaoguanZhaopin> lsres = new List <KaoguanZhaopin>();
if (dt.Rows.Count < 1)
{
return(lsres);
}
foreach (DataRow dr in dt.Rows)
{
KaoguanZhaopin kgzp = new KaoguanZhaopin();
kgzp.Id = (int)dr["Id"];
kgzp.KaoguanID = Convert.ToInt32(dr["kgid"].ToString());
kgzp.ZhaopinID = Convert.ToInt32(dr["zpid"].ToString());
kgzp.Weight = Convert.ToInt32(dr["weight"].ToString());
//
kgzp.KgName = dr["KgName"].ToString();
kgzp.KgDepName = dr["KgDepName"].ToString();
kgzp.KgPosName = dr["KgDuty"].ToString();
lsres.Add(kgzp);
}
return(lsres);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
HttpCookie c*k = Request.Cookies["ftcook"];
if (c*k["ypzzpid"] != null)
{
ypzzpid = Convert.ToInt32(c*k["ypzzpid"].ToString());
}
if (c*k != null)
{
int _zpid = Convert.ToInt32(c*k["zpid"]);
int _kgid = Convert.ToInt32(c*k["kgid"]);
KaoguanZhaopin kgzp = FTInterviewBLL.KaoguanZhaopinManage.GetKgZPbyKgIdZpid(_kgid, _zpid);
if (kgzp != null)
{
kgzpid = kgzp.Id;
}
}
if (ypzzpid != -1)
{
YingpinzheZhaopin t = FTInterviewBLL.YingpinzheZhaopinManage.GetYPZZPbyId(ypzzpid);
Zhaopin zp = FTInterviewBLL.ZhaopinManage.GetZhaopinById(t.ZhaopinId);
kaotiid = zp.KaotiID;
if (c*k != null)
{
c*k.Values.Remove("kaotiid");
c*k.Values.Add("kaotiid", kaotiid + "");
c*k.Expires = DateTime.Now.AddDays(1);
Response.AppendCookie(c*k);
}
}
flag = false;
shitils.Clear();
xdls.Clear();
}
BindData();
}
public static int Add(KaoguanZhaopin kz)
{
return(FTInterviewDAL.KaoguanZhaopinService.Add(kz));
}
