public DataTable GetMobliePh(string tjbh)
{
string sql = "SELECT tjbh,ph,MOBILE FROM v_tj_dh_ph where tjbh='" + tjbh + "'";
string strConn = System.Configuration.ConfigurationManager.AppSettings["Constr"].ToString();
strConn = strConn + ";App=XXTJXT";
DataAgent da1 = new DataAgent(strConn);
return(da1.GetDataTable(sql));
}
public DataTable GetZybRyxx(string tjbh, string tjcs)
{
StringBuilder sql = new StringBuilder("select gz,hyzk,tjbh,tjcs,xm,sfzh,csnyr,dw,dwdh,gh,bh,convert(varchar(10),tbrq,120) tbrq,lx,jws,bm,zdrq,zddw,sfqy,ccnl,jq,zq,tjnl,xyzn,lccs,zccs,sccs,yctc,sfxy,xyns,sfyj,yjsl,yjsj,qt,jtbs,dwdz,gz,ygzdwjgz,zybwhjcs,mingcheng,mzmc,hy,zyjcs,lcbx,xysjcjg,zdbz,zdjl,clyj,wjh,zgl,jsgl,xysl,dhqk,picture,zgqj,sgq,lgs,whcd,xb from v_tj_zyb_ryxx ");
sql.Append(" where tjbh='" + tjbh + "' and tjcs='" + tjcs + "'");
string strConn = System.Configuration.ConfigurationManager.AppSettings["Constr"].ToString();
strConn = strConn + ";App=XXTJXT";
DataAgent da = new DataAgent(strConn);
return(da.GetDataTable(sql.ToString()));
}