public void tianjia()
{
linqFangYuanDataContext fy = new linqFangYuanDataContext();
//定义新对象newfy
FangYuan newfy = new FangYuan();
newfy.Fy_KeHuId = Convert.ToInt32(Request.QueryString["Id"]);
newfy.Fy_YuanGongId = Convert.ToInt32(Session["Yg_Id"].ToString());
newfy.Fy_ChengQu = Convert.ToInt32(drlCQ.SelectedValue);
newfy.Fy_ShangQuan = Convert.ToInt32(drlSQ.SelectedValue);
newfy.Fy_JiaGe = Convert.ToInt32(txtJG.Text.Trim());
newfy.Fy_MianJi = Convert.ToInt32(txtMJ.Text.Trim());
newfy.Fy_JiaoTong = txtJiaotong.Text.Trim();
newfy.Fy_ShangChao = txtShangchao.Text.Trim();
newfy.Fy_XiangXi = txtXiangX.Text.Trim();
/*newfy.Fy_Img1 = hifdImg1.Value.ToString();
* newfy.Fy_Img2 = hifdImg2.Value.ToString();
* newfy.Fy_Img3 = hifdImg3.Value.ToString();
* newfy.Fy_Img4 = hifdImg4.Value.ToString(); */
newfy.Fy_Gmaps = Request.Form["zuobiao"].ToString();
//利用DateTime.Now函数取得当前系统时间
newfy.Fy_TianJiaRiQi = DateTime.Now;
//提交添加新房源申请
fy.FangYuan.InsertOnSubmit(newfy);
//执行添加新房源
fy.SubmitChanges();
//提示添加成功
Response.Write("<Script language=javascript>");
Response.Write("window.alert('添加房源成功!');");
//转到新页面,查看刚才添加房源信息
Response.Write("window.location='FangYuanBJ.aspx?id=");
Response.Write(newfy.FY_Id);
Response.Write("'</script>");
}
public void zuobiao()
{
int linqid = Convert.ToInt32(Request.QueryString["id"].ToString());
linqFangYuanDataContext fy = new linqFangYuanDataContext();
Table <FangYuan> fangyuanlist = fy.GetTable <FangYuan>();
var query =
from fangyuan in fangyuanlist
where fangyuan.FY_Id == linqid
select fangyuan;
var a = query.ToArray()[0];
Response.Write(a.Fy_Gmaps);
}
protected void btnCZ_Click(object sender, EventArgs e)
{
int BH = Convert.ToInt32(txtBH.Text.Trim());
linqFangYuanDataContext fy = new linqFangYuanDataContext();
Table <FangYuan> fangyuanlist = fy.GetTable <FangYuan>();
var query =
from fangyuan in fy.FangYuan
where fangyuan.FY_Id == BH
select fangyuan;
grvFY.DataSource = query;
grvFY.DataKeyNames = new string[] { "Fy_id" };
grvFY.DataBind();
}
public void shaixuan()
{
int CQ = Convert.ToInt32(drlCQ.SelectedValue);
int SQ = Convert.ToInt32(drlSQ.SelectedValue);
linqFangYuanDataContext fy = new linqFangYuanDataContext();
Table <FangYuan> fangyuanlist = fy.GetTable <FangYuan>();
var query =
from fangyuan in fy.FangYuan
where fangyuan.Fy_ChengQu == CQ && fangyuan.Fy_ShangQuan == SQ
select fangyuan;
grvFY.DataSource = query;
grvFY.DataKeyNames = new string[] { "Fy_id" };
grvFY.DataBind();
}
public void FYdata()
{
linqFangYuanDataContext fy = new linqFangYuanDataContext();
Table <FangYuan> fangyuanlist = fy.GetTable <FangYuan>();
var query =
from fangyuan in fangyuanlist
where fangyuan.FY_Id == Convert.ToInt32(Session["fyid"].ToString())
select fangyuan;
var a = query.ToArray()[0];
drlLX.SelectedValue = a.Fy_LeiXing.ToString();
Label1.Text = a.Fy_KeHu;
Label2.Text = a.Fy_MenDian;
Label3.Text = a.Fy_YuanGong;
drlCQ.SelectedValue = a.Fy_ChengQu.ToString();
drlSQ.SelectedValue = a.Fy_ShangQuan.ToString();
drlZX.SelectedValue = a.Fy_ZhuangXiu.ToString();
drlZT.SelectedValue = a.Fy_ZhuangTai.ToString();
drlFX.SelectedValue = a.Fy_FangXing.ToString();
txtJG.Text = a.Fy_JiaGe.ToString();
txtMJ.Text = a.Fy_MianJi.ToString();
txtLC.Text = a.Fy_LouCeng.ToString();
CheckBox1.Checked = a.Fy_JiaJu;
CheckBox2.Checked = a.Fy_KuanDai;
CheckBox3.Checked = a.Fy_Chuang;
CheckBox4.Checked = a.Fy_ChuFang;
CheckBox5.Checked = a.Fy_ReShuiQi;
CheckBox6.Checked = a.Fy_DianShi;
CheckBox7.Checked = a.Fy_YouXian;
CheckBox8.Checked = a.Fy_DianHua;
txtXX.Text = a.Fy_XueXiao;
txtYY.Text = a.Fy_YiYuan;
txtSC.Text = a.Fy_ShangChao;
txtDZ.Text = a.Fy_DiZhi;
txtXiangX.Text = a.Fy_XiangXi;
}
public void gengxin()
{
linqFangYuanDataContext fy = new linqFangYuanDataContext();
var query =
from fangyuan in fy.FangYuan
where fangyuan.FY_Id == Convert.ToInt32(Session["fyid"].ToString())
select fangyuan;
foreach (var newfy in query)
{
newfy.Fy_LeiXing = Convert.ToInt32(drlLX.SelectedValue);
newfy.Fy_ChengQu = Convert.ToInt32(drlCQ.SelectedValue);
newfy.Fy_ShangQuan = Convert.ToInt32(drlSQ.SelectedValue);
newfy.Fy_ZhuangXiu = Convert.ToInt32(drlZX.SelectedValue);
newfy.Fy_ZhuangTai = Convert.ToInt32(drlZT.SelectedValue);
newfy.Fy_FangXing = Convert.ToInt32(drlFX.SelectedValue);
newfy.Fy_JiaGe = Convert.ToInt32(txtJG.Text.Trim());
newfy.Fy_MianJi = Convert.ToInt32(txtMJ.Text.Trim());
newfy.Fy_LouCeng = Convert.ToInt32(txtLC.Text.Trim());
newfy.Fy_JiaJu = CheckBox1.Checked;
newfy.Fy_KuanDai = CheckBox2.Checked;
newfy.Fy_Chuang = CheckBox3.Checked;
newfy.Fy_ChuFang = CheckBox4.Checked;
newfy.Fy_ReShuiQi = CheckBox5.Checked;
newfy.Fy_DianShi = CheckBox6.Checked;
newfy.Fy_YouXian = CheckBox7.Checked;
newfy.Fy_DianHua = CheckBox8.Checked;
newfy.Fy_XueXiao = txtXX.Text.Trim();
newfy.Fy_YiYuan = txtYY.Text.Trim();
newfy.Fy_ShangChao = txtSC.Text.Trim();
newfy.Fy_DiZhi = txtDZ.Text.Trim();
newfy.Fy_XiangXi = txtXiangX.Text.Trim();
newfy.Fy_Gmaps = Request.Form["zuobiao"].ToString();
}
fy.SubmitChanges();
}
