public int RepairDeal(string userName, string type, int id, string refercode)
{
int flag = 0;
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(-10);//身份验证失败
}
MLogin.GetExeUname();
//事务处理开始,劫持链接通道的sql语句
TransactionSql.Start(MyGlobal.DataBase); //===>开始
L_AfterRepair repair = new L_AfterRepair();
repair.BILLMAN = userName;
repair.OPERATE_TIME = SysTime.GetTime.ToString();
repair.REFERCODE = refercode; //关联维修单号
repair.OPERATE_TYPE = type;
repair.ZF1 = id.ToString(); //关联维修单号的id
repair.Insert();
if (type == "接受")
{
BLL.SetToSql(MyGlobal.DataBase, " update clientservice_AfterServiceBill set zf2 = '" + userName + "' where id = " + id);
}
else if (type == "拒绝")
{
BLL.SetToSql(MyGlobal.DataBase, " update clientservice_AfterServiceBill set BillMan = '', auditing = '' where id = " + id);
}
else
{
}
//提交事务到sql服务器处理
if (!TransactionSql.EndSql()) //===>结束
{
flag = -1;
}
return(flag);
}
public int WxReport(string userName, double lng1, double lat1, string userId, string client, string billcode, int id, string note)
{
int flag = 0;
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(-10);//身份验证失败
}
MLogin.GetExeUname();
string position = KFLocation.Get(client);
double lng, lat;
if (MyGlobal.AERA_CHECK) //是否范围校验
{
if (position == "") //该客户没有定位，将现在这个位置赋值给当前客户
{
flag = -2;
return(flag);
}
else if (position == "none")//不存在该用户
{
flag = -3;
return(flag);
}
else
{
}
string[] strs = position.Split(',');
lng = Convert.ToDouble(strs[0]);
lat = Convert.ToDouble(strs[1]);
if (ScueFun.LngLatDis.GetDistance(lng, lat, lng1, lat1) > MyGlobal.VISITAERA)
{
flag = 5;
return(flag);//超出范围不能提交
}
}
else
{
lng = lng1;
lat = lat1;
}
//事务处理开始,劫持链接通道的sql语句
TransactionSql.Start(MyGlobal.DataBase); //===>开始
DateTime now = SysTime.GetTime;
clientservice_AfterServiceBill C = new clientservice_AfterServiceBill();
C.ZF5 = note;
string[] strs_p = Function.StayTime(userId, lng1, lat1, client);
if (strs_p != null)
{
C.ZF11 = strs_p[0] == null ? "" : strs_p[0]; //开始时间
C.ZF12 = strs_p[1] == null ? "" : strs_p[1]; //结束时间
C.ZF13 = strs_p[2] == null ? "" : strs_p[2]; //时间间隔
}
C.Updata(" AND ID=" + id);
L_AfterRepair repair = new L_AfterRepair();
repair.BILLMAN = userName;
repair.OPERATE_TIME = now.ToString();
repair.REFERCODE = billcode; //关联维修单号
repair.OPERATE_TYPE = "完结";
repair.ZF1 = id.ToString(); //关联维修单号的id
repair.Insert();
//更新关联单据号，最新的，可作为最后打卡的目标公司,名称、地址 20180904 skl
puku_user u = new puku_user();
u.REFERCODE = billcode;
u.ZF1 = client;
u.ZF2 = lng.ToString();
u.ZF3 = lat.ToString();
u.ZF4 = now.ToString("yyyy-MM-dd HH:mm:ss");
u.Updata(" and USERPU='" + userId + "' ");
//提交事务到sql服务器处理//===>结束
if (!TransactionSql.EndSql())//判断是否成功
{
flag = -1;
}
return(flag);
}
