public string Reply(int id, string reply, string userName, double lng, double lat, double kflng, double kflat)
{
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();
if (MyGlobal.AERA_CHECK)//是否检核范围
{
if (kflng == -1 || kflat == -1)
{
return("None");
}
if (ScueFun.LngLatDis.GetDistance(lng, lat, kflng, kflat) > MyGlobal.VISITAERA)//超出范围
{
return("Toofar");
}
}
//事务处理开始,劫持链接通道的sql语句
TransactionSql.Start(MyGlobal.DataBase); //===>开始
DateTime now = SysTime.GetTime;
List <RpBill> result = new List <RpBill>();
L_ContactSheetMsg msg = new L_ContactSheetMsg();
msg.MTITLE = reply;
msg.INSERTER = userName;
msg.FID = id;
msg.INSERTDATE = now;
msg.STATE = "已提交";
int get_id = msg.Insert();
List <L_ContactSheetMsg> msg_list = msg.Select(" and INSERTDATE='" + now.ToString() + "' ");
L_ContactSheet l_Contact = new L_ContactSheet();
List <L_ContactSheet> list = l_Contact.Select(" and id = " + id.ToString());
if (list.Count > 0)
{
//更新关联单据号，最新的，可作为最后打卡的目标公司,名称、地址 20180904 skl
puku_user u = new puku_user();
u.REFERCODE = msg_list.Count > 0 ? msg_list[0].ID.ToString():"";
u.ZF1 = list[0].CLIENT;
u.ZF2 = kflng.ToString();
u.ZF3 = kflat.ToString();
u.ZF4 = now.ToString("yyyy-MM-dd HH:mm:ss");
u.Updata(" and TURENAME='" + userName + "' ");
}
else
{
return("没有该联络单！");
}
//提交事务到sql服务器处理//===>结束
if (!TransactionSql.EndSql())//判断是否成功
{
return("回复失败！");
}
return(msg.INSERTDATE.ToString());
}
public List <RpBill> GetReply(string fid)
{
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();
List <RpBill> result = new List <RpBill>();
L_ContactSheetMsg msg = new L_ContactSheetMsg();
List <L_ContactSheetMsg> list = msg.Select(" and fid='" + fid + "' order by id desc ", " top 30 * ");
foreach (L_ContactSheetMsg r in list)
{
RpBill n = new RpBill();
n.createtime = r.INSERTDATE.ToString("yyyy-MM-dd HH:mm:ss");
n.state = r.STATE;
n.inserter = r.INSERTER;
n.content = r.MTITLE;
result.Add(n);
}
return(result);
}
