public static Shiti GetShitiById(int stid = -1)
{
String sql = "select shiti.id as Id,question,ktid,ktindex,weight,sttime from shiti,kaoti where shiti.ktid=kaoti.id and kaoti.ktstate=1 ";
if (stid != -1)
{
sql += " and shiti.id=" + stid + "";
}
else
{
return(null);
}
DataTable dt = MySqlDBHelper.GetDataSet(sql);
Shiti st = new Shiti();
foreach (DataRow dr in dt.Rows)
{
// Shiti st = new Shiti();
st.Id = Convert.ToInt32(dr["Id"].ToString());
st.Question = dr["question"].ToString();
st.KaotiID = Convert.ToInt32(dr["ktid"].ToString());
st.KaotiIndex = Convert.ToInt32(dr["ktindex"].ToString());
st.Weight = Convert.ToInt32(dr["weight"]);
st.StTime = Convert.ToInt32(dr["sttime"]);
return(st);
}
return(null);
}
public static List <Shiti> GetAllShitiByKaotiId(int ktid = -1)
{
String sql = "select shiti.id as Id,question,ktid,ktindex,weight,sttime " +
" from shiti,kaoti,zpgw,department " +
" where kaoti.ktstate=1 and shiti.ktid=kaoti.id " +
" and kaoti.zpgwid=zpgw.id and zpgw.zpbm=department.id and department.bmstate=1 ";
//if(ktid !=-1)
{
sql += " and shiti.ktid=" + ktid + " ";
}
sql += " order by Id asc";
DataTable dt = MySqlDBHelper.GetDataSet(sql);
List <Shiti> list = new List <Shiti>();
foreach (DataRow dr in dt.Rows)
{
Shiti st = new Shiti();
st.Id = Convert.ToInt32(dr["Id"].ToString());
st.Question = dr["question"].ToString();
st.KaotiID = Convert.ToInt32(dr["ktid"].ToString());
st.KaotiIndex = Convert.ToInt32(dr["ktindex"].ToString());
st.Weight = Convert.ToInt32(dr["weight"]);
st.StTime = Convert.ToInt32(dr["sttime"]);
list.Add(st);
}
return(list);
}
protected void DataBind(int tid = -1)
{
if (tid != -1)//chuan zhi
{
Shiti st = FTInterviewBLL.ShitiManage.GetShitiById(tid);
AnsTime.Value = st.StTime + "";
StWeight.Value = st.Weight + "";
myEditor.Value = st.Question;
}
}
public static int Add(Shiti shiti)
{
String sql = "insert into shiti(question,ktid,ktindex,weight,sttime) values(@question,@ktid,@ktindex,@weight,@sttime)";
List <MySqlParameter> para_list = new List <MySqlParameter>();
para_list.Add(new MySqlParameter("@question", shiti.Question));
para_list.Add(new MySqlParameter("@ktid", shiti.KaotiID));
para_list.Add(new MySqlParameter("@ktindex", shiti.KaotiIndex));
para_list.Add(new MySqlParameter("@weight", shiti.Weight));
para_list.Add(new MySqlParameter("@sttime", shiti.StTime));
return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray()));
}
public static int Update(Shiti st)
{
String sql = "update shiti set question=@question,weight=@weight,sttime=@sttime where id=@id";
List <MySqlParameter> para_list = new List <MySqlParameter>();
para_list.Add(new MySqlParameter("@id", st.Id));
para_list.Add(new MySqlParameter("@question", st.Question));
//para_list.Add(new MySqlParameter("@ktid", st.KaotiID));
para_list.Add(new MySqlParameter("@weight", st.Weight));
para_list.Add(new MySqlParameter("@sttime", st.StTime));
return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray()));
}
public static List <Shiti> GetAllShiti()
{
String sql = "select shiti.id as Id,question,ktid,ktindex,weight,sttime from shiti,kaoti where shiti.ktid=kaoti.id order by Id asc ";
DataTable dt = MySqlDBHelper.GetDataSet(sql);
List <Shiti> list = new List <Shiti>();
foreach (DataRow dr in dt.Rows)
{
Shiti st = new Shiti();
st.Id = Convert.ToInt32(dr["Id"].ToString());
st.Question = dr["question"].ToString();
st.KaotiID = Convert.ToInt32(dr["ktid"].ToString());
st.KaotiIndex = Convert.ToInt32(dr["ktindex"].ToString());
st.Weight = Convert.ToInt32(dr["weight"]);
st.StTime = Convert.ToInt32(dr["sttime"]);
list.Add(st);
}
return(list);
}
public static double GetScoreSums(int ypzzpid, int kgzpid = -1)
{
double sum = 0;
if (kgzpid != -1)
{
string sql = "select pingfen.shitiid,pingfen.chengji from pingfen,yingpingzhezhaopin,yingpinzhe,kaoguanzhaopin,kaoguan,zhaopin,shiti " +
" where pfstate=1 and ypzzpid=" + ypzzpid + " and kgzpid=" + kgzpid +
" and pingfen.ypzzpid=yingpingzhezhaopin.id and pingfen.kgzpid=kaoguanzhaopin.id " +
" and zhaopin.id=yingpingzhezhaopin.zpid and pingfen.shitiid=shiti.id and shiti.ktid=zhaopin.ktid " +
" and yingpingzhezhaopin.ypzid=yingpinzhe.id and yingpinzhe.ypzstate=1 " +
" and kaoguanzhaopin.kgid=kaoguan.id and kaoguan.kgstate=1 ";
DataTable dt = MySqlDBHelper.GetDataSet(sql);
Dictionary <int, int> temp = new Dictionary <int, int>();
foreach (DataRow dr in dt.Rows)
{
int stid = Convert.ToInt32(dr["shitiid"]);
int chengji = Convert.ToInt32(dr["chengji"]);
if (!temp.ContainsKey(stid))
{
temp.Add(stid, chengji);
}
else
{
temp[stid] += chengji;
}
}
foreach (int k in temp.Keys)
{
Shiti st = ShitiService.GetShitiById(k);
if (st != null)
{
int w = st.Weight;
sum += temp[k] * w * 0.01;
}
}
}
else//获取全部
{
string sql = "select pingfen.kgzpid as Kgzpid," +
" pingfen.shitiid as ShitiId," +
"pingfen.xdbzid as XdId," +
"shiti.weight as Weight," +
"kaoguanzhaopin.weight as KgWeight," +
"pingfen.chengji as CJ " +
"from pingfen,shiti,kaoguanzhaopin,kaoguan,yingpingzhezhaopin,yingpinzhe,zhaopin " +
" where pingfen.pfstate=1 and pingfen.ypzzpid=" + ypzzpid +
" and pingfen.shitiid=shiti.id and kaoguanzhaopin.id= pingfen.kgzpid" +
" and zhaopin.id=yingpingzhezhaopin.zpid and pingfen.shitiid=shiti.id and shiti.ktid=zhaopin.ktid " +
" and pingfen.ypzzpid=yingpingzhezhaopin.id " +
" and yingpingzhezhaopin.ypzid=yingpinzhe.id and yingpinzhe.ypzstate=1 " +
" and kaoguanzhaopin.kgid=kaoguan.id and kaoguan.kgstate=1 ";
DataTable dt = MySqlDBHelper.GetDataSet(sql);
Dictionary <int, double> wei = new Dictionary <int, double>();
Dictionary <int, double> kgwei = new Dictionary <int, double>();
Dictionary <int, Dictionary <int, int> > _myres = new Dictionary <int, Dictionary <int, int> >();
foreach (DataRow dr in dt.Rows)
{
int kgzpid_t = Convert.ToInt32(dr["Kgzpid"]);
int stid = Convert.ToInt32(dr["ShitiId"]);
int xdid = Convert.ToInt32(dr["XdId"]);
int chengji = Convert.ToInt32(dr["CJ"]);
double weight_kg = Convert.ToDouble(dr["KgWeight"]);
double weight_st = Convert.ToDouble(dr["Weight"]);
if (!wei.ContainsKey(stid))
{
wei.Add(stid, weight_st);
}
if (!kgwei.ContainsKey(kgzpid_t))
{
kgwei.Add(kgzpid_t, weight_kg);
}
if (!_myres.ContainsKey(kgzpid_t))
{
Dictionary <int, int> mt = new Dictionary <int, int>();
mt.Add(stid, chengji);
_myres.Add(kgzpid_t, mt);
}
else
{
Dictionary <int, int> mt = _myres[kgzpid_t];
if (mt.ContainsKey(stid))
{
mt[stid] += chengji;
}
else
{
mt.Add(stid, chengji);
}
}
}
foreach (int kgkeys in _myres.Keys)
{
double kgw = kgwei[kgkeys];
double sum_temp = 0;
Dictionary <int, int> temp_sc = _myres[kgkeys];
foreach (int stkeys in temp_sc.Keys)
{
double stw = wei[stkeys];
sum_temp += stw * 0.01 * temp_sc[stkeys];
}
sum += (0.01 * kgw * sum_temp);
}
}
return(sum);
}
//save
protected void Save_Click(object sender, EventArgs e)
{
List <string> msg = new List <string>();
int ans_t = 0, wei_t = 0;
//if(AnsTime.Value.Trim()=="" || )
{
try
{
ans_t = Convert.ToInt32(AnsTime.Value);
}
catch (System.Exception ex)
{
msg.Add("请输入合法时间值！");
}
}
//if (StWeight.Value.Trim() == "")
{
try
{
wei_t = Convert.ToInt32(StWeight.Value);
}
catch (System.Exception ex)
{
msg.Add("请输入合法权重比例！");
}
}
if (msg.Count > 0)
{
Response.Write("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>");
Response.Write("<script language=javascript>alert('" + msg[0] + "')</script>");
}
else
{
if (t_id != -1)
{
Shiti st = new Shiti();
st.StTime = ans_t;
st.Weight = wei_t;
st.Question = myEditor.Value;//myEditor.InnerHtml;
st.Id = t_id;
FTInterviewBLL.ShitiManage.Update(st);
Response.Write("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>");
Response.Write("<script language=javascript>alert('更新成功！')</script>");
}
else
{
if (kt_id != -1)
{
Shiti st = new Shiti();
st.StTime = ans_t;
st.Weight = wei_t;
st.Question = myEditor.Value;//myEditor.InnerHtml;
st.KaotiID = kt_id;
FTInterviewBLL.ShitiManage.Add(st);
Response.Write("<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.0 Transitional//EN' 'http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd'>");
Response.Write("<script language=javascript>alert('添加成功！')</script>");
}
}
}
}
public static int Update(Shiti st)
{
return(FTInterviewDAL.ShitiService.Update(st));
}
public static int Add(Shiti shiti)
{
return(FTInterviewDAL.ShitiService.Add(shiti));
}
