public void sousuo()
{
string strXM = txtXM.Text;
string strDH = txtDH.Text;
linqKeHuDataContext kh = new linqKeHuDataContext();
System.Linq.IQueryable <KeHu> query;
//判断组合条件
switch (drl1.SelectedValue)
{
case "和":
query =
from kehu in kh.KeHu
where kehu.Kh_XingMing == txtXM.Text.Trim() && kehu.Kh_DianHua == txtDH.Text.Trim()
select kehu;
//把grvKH的数据源设置为查询结果query
grvKH.DataSource = query;
//把grvKH的索引设置为客户ID
grvKH.DataKeyNames = new string[] { "Kh_id" };
//grvKH重新绑定数据
grvKH.DataBind();
break;
case "或":
query =
from kehu in kh.KeHu
where kehu.Kh_XingMing == txtXM.Text.Trim() || kehu.Kh_DianHua == txtDH.Text.Trim()
select kehu;
grvKH.DataSource = query;
grvKH.DataKeyNames = new string[] { "Kh_id" };
grvKH.DataBind();
break;
}
}
protected void grvKH_SelectedIndexChanged(object sender, EventArgs e)
{
linqKeHuDataContext kh = new linqKeHuDataContext();
Table <KeHu> kehulist = kh.GetTable <KeHu>();
var query =
from kehu in kehulist
where kehu.Kh_Id == Convert.ToInt32(grvKH.DataKeys[grvKH.SelectedIndex].Value.ToString())
select kehu;
FormView1.DataSource = query;
FormView1.DataBind();
//dlvKeHu.DataSource = query;
//dlvKeHu.DataBind();
}
public void tianjia()
{
//各项信息填写完成后,把客户信息利用LINQ技术输入到KeHu表
linqKeHuDataContext kh = new linqKeHuDataContext();
KeHu newkh = new KeHu();
newkh.Kh_XingMing = txtXM.Text;
newkh.Kh_XingBie = RadioButtonList1.SelectedValue;
newkh.Kh_DianHua = txtDH.Text;
newkh.Kh_JingJiRenId = Convert.ToInt32(Session["Yg_Id"].ToString());
newkh.Kh_ShenFenZheng = txtSF.Text;
newkh.Kh_BeiZhu = txtBZ.Text;
newkh.Kh_TianJiaShiJian = DateTime.Now;
//提交插入新客户请求
kh.KeHu.InsertOnSubmit(newkh);
//执行插入新客户
kh.SubmitChanges();
//提示插入新客户成功
Response.Write("<Script language=javascript>");
Response.Write("window.alert('添加客户成功!');");
Response.Write("window.location='KeHuTJ.aspx");
Response.Write("'</script>");
}