public ZB_ZJ_CS GET_ZJ_ZB_CS(int mbid)
{
string sql = "select rwid,nf,zc,mbid from xtgl_bbrw where (zt = 3 or zt =4) and mbid =@mbid order by nf desc,zc desc limit 1";
MySqlParameter[] p = { new MySqlParameter("mbid", mbid) };
return(Modelhelper.类对象赋值 <ZB_ZJ_CS>(new ZB_ZJ_CS(), MySqlDbhelper.GetDataSet(sql, p).Tables[0]));
}
public Rw_Item_Model GET_RWXQ(int mbid, int nf, int zc)
{
string sql = "select * from calculation.xtgl_bbrw where mbid= @mbid and nf=@nf and zc=@zc";
MySqlParameter[] p = { new MySqlParameter("mbid", mbid), new MySqlParameter("nf", nf), new MySqlParameter("zc", zc) };
return(Modelhelper.类对象赋值 <Rw_Item_Model>(new Rw_Item_Model(), MySqlDbhelper.GetDataSet(sql, p).Tables[0]));
}
public Rw_Item_Model GET_RWXQ(int rwid)
{
string sql = "select * from calculation.xtgl_bbrw where rwid=@rwid";
MySqlParameter[] p = { new MySqlParameter("rwid", rwid) };
return(Modelhelper.类对象赋值 <Rw_Item_Model>(new Rw_Item_Model(), MySqlDbhelper.GetDataSet(sql, p).Tables[0]));
}
public Rw_Cofirm_data GET_RWZT(int rwid, int nf, int zc)
{
string sql = @"select t1.rwid,t1.rwmc,t1.nf,t1.zc,t2.cjjl_zt,t2.xzys_zt,t2.tdcj_zt,t2.rgsj_zt from calculation.xtgl_bbrw t1 left join calculation.xtgl_ConfirmData t2
on t1.rwid = t2.rwid where t1.rwid=@rwid and t1.nf = @nf and t1.zc=@zc";
MySqlParameter[] p = { new MySqlParameter("rwid", rwid), new MySqlParameter("nf", nf), new MySqlParameter("zc", zc) };
return(Modelhelper.类对象赋值(new Rw_Cofirm_data(), MySqlDbhelper.GetDataSet(sql, p).Tables[0]));
}
public QXXX GET_YHQX(string qxkzq, string qxst)
{
string sql = @"select qxbh,fqxbh,qxmc,qxkzq,qxst from xtgl_fw_qxxx where qxbh =
(select substr(qxbh, 1, 4) from xtgl_fw_qxxx where qxkzq = @qxkzq and qxst = @qxst)";
MySqlParameter[] p = { new MySqlParameter("qxkzq", qxkzq), new MySqlParameter("qxst", qxst) };
return(Modelhelper.类对象赋值 <QXXX>(new QXXX(), MySqlDbhelper.GetDataSet(sql, p).Tables[0]));
}
//登录
public YHXX CHECK_LOGIN(string yhmc, string yhmm)
{
string sql = "select * from xtgl_fw_yh where yhmc=@yhmc and yhmm=@yhmm";
MySqlParameter[] p = { new MySqlParameter("yhmc", yhmc), new MySqlParameter("yhmm", yhmm) };
DataTable dt = MySqlDbhelper.GetDataSet(sql, p).Tables[0];
if (dt != null && dt.Rows.Count > 0)
{
return(Modelhelper.类对象赋值 <YHXX>(new YHXX(), MySqlDbhelper.GetDataSet(sql, p).Tables[0]));
}
else
{
return(null);
}
}