protected void Button1_Click(object sender, EventArgs e)
{
List <Pingjiaxiangdian> xdls = FTInterviewBLL.PingjiaxiangdianManage.GetAll();
List <Pingjiabiaozhun> bzls = FTInterviewBLL.PingjiabiaozhunManage.GetAll();
List <Xiangdianbiaozhun> xdbzls = FTInterviewBLL.XiangdianBiaozhunManage.GetAll();
for (int i = 0; i < xdls.Count; i++)
{
for (int j = 0; j < bzls.Count; j++)
{
bool flag = false;
for (int k = 0; k < xdbzls.Count; k++)
{
Xiangdianbiaozhun te = xdbzls[k];
if (te.PjxdID == xdls[i].Id && te.PjbzID == bzls[j].Id)
{
flag = true;
break;
}
}
if (!flag)
{
Xiangdianbiaozhun new_temp = new Xiangdianbiaozhun();
new_temp.PjxdID = xdls[i].Id;
new_temp.PjbzID = bzls[j].Id;
new_temp.MyContent = "";
FTInterviewBLL.XiangdianBiaozhunManage.Add(new_temp);
}
}
}
Response.Redirect("PingfenDetail.aspx");
}
public static int Update(Xiangdianbiaozhun xb)
{
String sql = "update xdbz set mycontent=@mycontent where id=@id";
List <MySqlParameter> para_list = new List <MySqlParameter>();
para_list.Add(new MySqlParameter("@id", xb.Id));
para_list.Add(new MySqlParameter("@mycontent", xb.MyContent));
return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray()));
}
public static int Add(Xiangdianbiaozhun xb)
{
String sql = "insert into xdbz(xdid,bzid,mycontent) values(@xdid,@bzid,@mycontent)";
List <MySqlParameter> para_list = new List <MySqlParameter>();
para_list.Add(new MySqlParameter("@xdid", xb.PjxdID));
para_list.Add(new MySqlParameter("@bzid", xb.PjbzID));
para_list.Add(new MySqlParameter("@mycontent", xb.MyContent));
return(MySqlDBHelper.ExecuteCommand(sql, para_list.ToArray()));
}
public static Xiangdianbiaozhun GetXDBZby2id(int xd_id, int bz_id)
{
String sql = "select * from xdbz where xdid=" + xd_id + " and bzid=" + bz_id + " ";
DataTable dt = MySqlDBHelper.GetDataSet(sql);
Xiangdianbiaozhun list = new Xiangdianbiaozhun();
foreach (DataRow dr in dt.Rows)
{
Xiangdianbiaozhun st = new Xiangdianbiaozhun();
st.Id = Convert.ToInt32(dr["id"].ToString());
st.PjxdID = Convert.ToInt32(dr["xdid"].ToString());
st.PjbzID = Convert.ToInt32(dr["bzid"].ToString());
st.MyContent = dr["mycontent"].ToString();
return(st);
}
return(list);
}
public static List <Xiangdianbiaozhun> GetAll()
{
String sql = "select * from xdbz order by xdid,bzid ";
DataTable dt = MySqlDBHelper.GetDataSet(sql);
List <Xiangdianbiaozhun> list = new List <Xiangdianbiaozhun>();
foreach (DataRow dr in dt.Rows)
{
Xiangdianbiaozhun st = new Xiangdianbiaozhun();
st.Id = Convert.ToInt32(dr["id"].ToString());
st.PjxdID = Convert.ToInt32(dr["xdid"].ToString());
st.PjbzID = Convert.ToInt32(dr["bzid"].ToString());
st.MyContent = dr["mycontent"].ToString();
list.Add(st);
}
return(list);
}
public static int Update(Xiangdianbiaozhun xb)
{
return(FTInterviewDAL.XiangdianBiaozhunService.Update(xb));
}
public static int Add(Xiangdianbiaozhun xb)
{
return(FTInterviewDAL.XiangdianBiaozhunService.Add(xb));
}
