public VSBill YW_Detail_Bill(string code)
{
string cookies = HttpContext.Current.Request.Cookies["guid"] == null ? "" : HttpContext.Current.Request.Cookies["guid"].Value as string;
string session = Session.SessionID.ToString();
if (!cookies.Equals(session))
{
return(null);//身份验证失败
}
MLogin.GetExeUname();
L_VisitSend s = new L_VisitSend();
VSBill vs = new VSBill();
//未接收消息
List <L_VisitSend> list = s.Select(" and CODE='" + code + "' ");
if (list.Count <= 0)
{
return(null);//没有未接收消息
}
else
{
L_VisitSend l = list[0];
vs.id = l.ID;
vs.client = l.VISITCLIENT;
vs.hisname = l.VISITNAME;
vs.hisphone = l.VISITTEL;
vs.content = l.VISITCONTENT;
vs.notice = l.DOTHING;
vs.visittype = l.VISITTYPE;
vs.date = l.VISITDATE.ToShortDateString();
vs.state = l.STATE;
vs.code = l.CODE;
}
return(vs);
}
public List <VSBill> YWBillGet(string userName, string where)
{
string cookies = HttpContext.Current.Request.Cookies["guid"] == null ? "" : HttpContext.Current.Request.Cookies["guid"].Value as string;
string session = Session.SessionID.ToString();
if (!cookies.Equals(session))
{
return(null);//身份验证失败
}
MLogin.GetExeUname();
L_VisitSend s = new L_VisitSend();
List <VSBill> returnlist = new List <VSBill>();
string today_1 = System.DateTime.Now.ToString("yyyy-MM-dd 00:00:00");
string today = System.DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
//未接收消息
List <L_VisitSend> list = s.Select(" and SENDUSER='******' and LEFT(CODE,1)<>'*' and VISITDATE < '" + today + "' " + where, " top 20 * ");
if (list.Count <= 0)
{
return(null);//没有消息
}
else
{
foreach (L_VisitSend l in list)
{
VSBill vs = new VSBill();
vs.id = l.ID;
vs.client = l.VISITCLIENT;
vs.hisname = l.VISITNAME;
vs.hisphone = l.VISITTEL;
vs.content = l.VISITCONTENT;
vs.notice = l.DOTHING;
vs.visittype = l.VISITTYPE;
vs.date = l.VISITDATE.ToShortDateString();
vs.code = l.CODE;
vs.state = l.STATE;
vs.rq1 = l.RQ1.ToString();
vs.rq2 = l.RQ2.ToString();
vs.zf5 = l.ZF5;
returnlist.Add(vs);
}
}
return(returnlist);
}
public List <VSBill> YWBillGet_P(string userName, int index, int curPage, int pageSize)
{
string cookies = HttpContext.Current.Request.Cookies["guid"] == null ? "" : HttpContext.Current.Request.Cookies["guid"].Value as string;
string session = Session.SessionID.ToString();
if (!cookies.Equals(session))
{
return(null);//身份验证失败
}
MLogin.GetExeUname();
int num = curPage * pageSize;
List <VSBill> returnlist = new List <VSBill>();
//未接收消息
string ORDER = " order by id ";
string WHERE = string.Empty;
if (index == 0)//未接收
{
WHERE = " and state=0 and visittype='上门拜访' ";
}
else if (index == 1)//处理中
{
WHERE = " and state=7 and visittype='上门拜访' ";
}
else//完成
{
WHERE = " and state=10 and visittype='上门拜访' ";
ORDER = " order by id desc ";
}
string today = System.DateTime.Now.ToString("yyyy-MM-dd 23:59:59");
string sql = " select top " + pageSize.ToString() + " o.* from ( " +
" select row_number() over(" + ORDER + ") as rownumber, N_A.* from( " +
" select * from L_VisitSend " +
" where 1 = 1 and SENDUSER='******' and LEFT(CODE,1)<>'*' and VISITDATE < '" + today + "' " + WHERE +
" ) as N_A) as o where rownumber> " + num.ToString();
DataTable dt = DBLL.ExecuteDataTable(MyGlobal.DataBase, sql);
// List<L_VisitSend> list = s.Select(" and SENDUSER='******' and LEFT(CODE,1)<>'*' and VISITDATE < '" + today + "' " + where, " top 20 * ");
if (dt == null || dt.Rows.Count <= 0)
{
return(null);//没有消息
}
else
{
foreach (DataRow row in dt.Rows)
{
VSBill vs = new VSBill();
vs.id = Convert.ToInt32(row["ID"].ToString());
vs.client = row["VISITCLIENT"].ToString();
vs.hisname = row["VISITNAME"].ToString();
vs.hisphone = row["VISITTEL"].ToString();
vs.content = row["VISITCONTENT"].ToString();
vs.notice = row["DOTHING"].ToString();
vs.visittype = row["VISITTYPE"].ToString();
vs.date = row["VISITDATE"].ToString();
vs.code = row["CODE"].ToString();
vs.state = Convert.ToInt32(row["STATE"].ToString());
vs.rq1 = row["RQ1"].ToString();
vs.rq2 = row["RQ2"].ToString();
vs.zf5 = row["ZF5"].ToString();
returnlist.Add(vs);
}
}
return(returnlist);
}
