/// <summary>
/// 检测电话是否存在
/// </summary>
/// <param name="myuservo"></param>
/// <param name="phone"></param>
/// <returns></returns>
public static (bool, string, object) CheckDriverIsHaveFromPhone(UserLoginVO myuservo, string phone)
{
sql = makesql.MakeSelectSql(typeof(Model.Model.LC_User), "phone=@phone", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@phone", phone)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg, null);
}
if (!ids.ReadIsOk())
{
return(true, "检测电话不存在!", false);
}
Model.Model.LC_User lcu_vo = ids.GetVOList <Model.Model.LC_User>()[0];
if (lcu_vo.ZType.ConvertData <GlobalBLL.AccountTypeEnum>() != AccountTypeEnum.物流公司员工账号)
{
return(false, "绑定账号类型不是司机的电话!", null);
}
if (lcu_vo.PositionID.ConvertData <PositionEnum>() != PositionEnum.驾驶员)
{
return(false, "绑定账号类型不是司机的电话!", null);
}
if (lcu_vo.State.ConvertData <UserStateEnum>() != GlobalBLL.UserStateEnum.正常)
{
return(false, "您要绑定的司机还没有通过授权!", null);
}
return(true, string.Empty, true);
}
/// <summary>
/// 根据电话绑定物流
/// </summary>
/// <param name="myuservo"></param>
/// <param name="phone"></param>
/// <returns></returns>
public static Tuple <bool, string> UserAddFromPhone(UserLoginVO myuservo, string phone)
{
string LogisticsUid = string.Empty;
//获取当前物流是否存在并获取数据
sql = makesql.MakeSelectSql(typeof(Model.Model.LC_User), "Phone=@Phone", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Phone", phone)
}, string.Empty, 1);
ids = db.Read(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (!ids.ReadIsOk())
{
return(new Tuple <bool, string>(false, "当前电话号码的物流信息不存在!"));
}
Model.Model.LC_User lcu = ids.GetVOList <Model.Model.LC_User>()[0];
//判断是否为物流
if (lcu.ZType.ConvertData <GlobalBLL.AccountTypeEnum>() != AccountTypeEnum.物流账号)
{
return(new Tuple <bool, string>(false, "此电话并非物流公司电话,请检查电话是否正确!"));
}
LogisticsUid = lcu.UID;
//检查此物流是否已经绑定过了
sql = makesql.MakeCount(nameof(Model.Model.LC_UserBindLogisticsList), "uid=@uid and LogisticsUid=@LogisticsUid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", myuservo.uid),
new System.Data.SqlClient.SqlParameter("@LogisticsUid", LogisticsUid)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (ids.Count() > 0)
{
return(new Tuple <bool, string>(false, "当前物流已经绑定过了,无需重新绑定!"));
}
//开始绑定
Model.Model.LC_UserBindLogisticsList ubll = new Model.Model.LC_UserBindLogisticsList()
{
CreateTime = DateTime.Now,
LogisticsUid = LogisticsUid,
Uid = myuservo.uid
};
sql = makesql.MakeInsertSQL(ubll);
ids = db.Exec(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (!ids.ExecOk())
{
return(new Tuple <bool, string>(false, "绑定失败请重试!"));
}
return(new Tuple <bool, string>(true, string.Empty));
}
public static Tuple <bool, string> UpdateYesOrNo(Model.Model.LC_User LC_User, string UID)
{
sql = makesql.MakeUpdateSQL(LC_User, "UID='" + UID + "'");
ids = db.Exec(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (!ids.ExecOk())
{
return(new Tuple <bool, string>(false, "修改失败请重试!"));
}
return(new Tuple <bool, string>(true, string.Empty));
}
/// <summary>
///
/// </summary>
/// <param name="lC_User"></param>
/// <returns></returns>
public static Tuple <bool, string> Add(Model.Model.LC_User lC_User, GlobalBLL.UserLoginVO loginvo, string LogisticsUid)
{
var box = db.CreateTranSandbox((db) =>
{
//判断
if (lC_User.ZType.ConvertData <GlobalBLL.AccountTypeEnum>() == GlobalBLL.AccountTypeEnum.普通用户账号 && LogisticsUid.StrIsNotNull())
{
//获取物流公司账号数据
sql = makesql.MakeSelectSql(typeof(Model.Model.LC_User), "uid=@uid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", LogisticsUid)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (!ids.ReadIsOk())
{
return(new Tuple <bool, string>(false, "没有找到任何物流公司数据!"));
}
Model.Model.LC_User wl_uservo = ids.GetVOList <Model.Model.LC_User>()[0];
lC_User.ProvincesID = wl_uservo.ProvincesID;
lC_User.CityID = wl_uservo.CityID;
lC_User.AreaID = wl_uservo.AreaID;
//添加查询是否已经绑定过
sql = makesql.MakeCount(nameof(Model.Model.LC_UserBindLogisticsList), "uid=@uid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", lC_User.ZNumber)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (ids.Count() == 0)
{
//添加一个物流绑定
sql = makesql.MakeInsertSQL(new Model.Model.LC_UserBindLogisticsList()
{
CreateTime = DateTime.Now,
LogisticsUid = LogisticsUid,
Uid = loginvo.uid.StrIsNull() ? lC_User.UID : loginvo.uid
});
ids = db.Exec(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
}
}
//if(loginvo.uid.StrIsNull()) //如果没有登陆则创建一个账号
{
//判断账号是否存在
sql = makesql.MakeCount(nameof(Model.Model.LC_User), "ZNumber=@ZNumber", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@ZNumber", lC_User.ZNumber)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (ids.Count() > 0)
{
return(new Tuple <bool, string>(false, "此帐号已注册！"));
}
if (ids.Count() == 0)
{
sql = makesql.MakeInsertSQL(lC_User);
ids = db.Exec(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (!ids.ExecOk())
{
return(new Tuple <bool, string>(false, "注册账号时失败,请重试!"));
}
}
}
db.Commit();
return(new Tuple <bool, string>(true, string.Empty));
});
return(box);
}
/// <summary>
/// 添加或者更新用户数据
/// </summary>
/// <param name="suser"></param>
/// <returns></returns>
public static (bool, string, Model.Model.LC_User suser) AddOrUpdateUserVO(Model.Model.LC_User suser)
{
var box = db.CreateTranSandbox <(bool, string, Model.Model.LC_User suser)>((db) =>
{
//获取用户是否存在
sql = makesql.MakeSelectSql(typeof(Model.Model.LC_User), "WX_OpenID=@WX_OpenID", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@WX_OpenID", suser.WX_OpenID)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg, null);
}
if (ids.ReadIsOk()) //更新数据
{
var ls_usrvo = ids.GetVOList <Model.Model.LC_User>()[0];
if (ls_usrvo.ZNumber.StrIsNotNull()) //如果彻底注册成功则不更新用户类型
{
//更新用户数据
//判断是否已经彻底注册完毕
suser.ZType = null;
suser.PositionID = null;
}
//不更新昵称
sql = makesql.MakeUpdateSQL(suser, "WX_OpenID=@WX_OpenID");
}
else
{
suser.CreateTime = DateTime.Now;
suser.UID = Tools.NewGuid.GuidTo16String();
if (suser.ZType <= 0)
{
return(false, "账号类型不正确!", null);
}
sql = makesql.MakeInsertSQL(suser);
}
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg, null);
}
if (!ids.ExecOk())
{
return(false, "更新或添加用户失败!", null);
}
//获取最后的数据
sql = makesql.MakeSelectSql(typeof(Model.Model.LC_User), "WX_OpenID=@WX_OpenID", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@WX_OpenID", suser.WX_OpenID)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg, null);
}
if (!ids.ReadIsOk())
{
return(false, "刚注册完的数据消失了???", null);
}
Model.Model.LC_User new_suser = ids.GetVOList <Model.Model.LC_User>()[0];
db.Commit();
return(true, string.Empty, new_suser);
});
return(box);
}
/// <summary>
/// 普通账号绑定
/// </summary>
/// <param name="nickName"></param>
/// <param name="phone"></param>
/// <param name="logistics"></param>
/// <param name="sheng"></param>
/// <param name="shi"></param>
/// <param name="qu"></param>
/// <returns></returns>
public static (bool, string) OrdinaryAccountBind(UserLoginVO myuservo, string nickName, long phone, string logistics, int sheng, int shi, int qu)
{
var box = db.CreateTranSandbox((db) =>
{
//检测此物流是否存在
sql = makesql.MakeCount(nameof(Model.Model.LC_User), "uid=@logistics and ztype=@ztype", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@logistics", logistics),
new System.Data.SqlClient.SqlParameter("@ztype", GlobalBLL.AccountTypeEnum.物流账号.EnumToInt())
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (ids.Count() == 0)
{
return(false, "您要绑定的物流不存在!");
}
//查看电话号是否存在
sql = makesql.MakeCount(nameof(Model.Model.LC_User), "Phone=@Phone", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Phone", phone)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (ids.Count() > 0)
{
return(false, "当前手机号已被使用!");
}
//开始绑定
Model.Model.LC_User user = new Model.Model.LC_User()
{
UserName = nickName,
ZNumber = phone.ToString(),
State = 1, //默认开通
Phone = phone.ToString(),
ProvincesID = sheng,
CityID = shi,
AreaID = qu,
};
sql = makesql.MakeUpdateSQL(user, "uid=@uid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", myuservo.uid)
});
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "绑定失败请重试!");
}
//添加一个绑定记录
//查看是否已经绑定过当前物流UID
sql = makesql.MakeCount(nameof(Model.Model.LC_UserBindLogisticsList), "uid=@uid and LogisticsUid=@LogisticsUid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@LogisticsUid", logistics),
new System.Data.SqlClient.SqlParameter("@uid", myuservo.uid)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (ids.Count() == 0)
{
//添加一个物流绑定
sql = makesql.MakeInsertSQL(new Model.Model.LC_UserBindLogisticsList()
{
CreateTime = DateTime.Now,
LogisticsUid = logistics,
Uid = myuservo.uid
});
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "添加绑定失败请重试!");
}
}
db.Commit();
return(true, string.Empty);
});
return(box);
}
/// <summary>
/// 员工账号绑定
/// </summary>
/// <param name="myuservo"></param>
/// <param name="nickName"></param>
/// <param name="phone"></param>
/// <param name="logistics">要绑定到的物流公司</param>
/// <param name="bindvehicleid">绑定的车辆ID</param>
/// <returns></returns>
public static (bool, string) EmployeeAccountBind(UserLoginVO myuservo, string nickName, long phone, string logistics, long bindvehicleid)
{
var box = db.CreateTranSandbox((db) =>
{
//检测此物流是否存在
sql = makesql.MakeSelectSql(typeof(Model.Model.LC_User), "uid=@logistics and ztype=@ztype", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@logistics", logistics),
new System.Data.SqlClient.SqlParameter("@ztype", GlobalBLL.AccountTypeEnum.物流账号.EnumToInt())
}, string.Empty, 1);
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ReadIsOk())
{
return(false, "您要绑定的物流不存在!");
}
Model.Model.LC_User wl_user = ids.GetVOList <Model.Model.LC_User>()[0];
//查看电话号是否存在
sql = makesql.MakeCount(nameof(Model.Model.LC_User), "Phone=@Phone", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Phone", phone)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (ids.Count() > 0)
{
return(false, "当前手机号已被使用!");
}
//开始绑定
Model.Model.LC_User user = new Model.Model.LC_User()
{
UserName = nickName,
ZNumber = phone.ToString(),
Phone = phone.ToString(),
ProvincesID = wl_user.ProvincesID,
CityID = wl_user.CityID,
AreaID = wl_user.AreaID,
LCID = logistics
};
sql = makesql.MakeUpdateSQL(user, "uid=@uid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", myuservo.uid)
});
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "绑定失败请重试!");
}
//绑定车辆
if (bindvehicleid > 0)
{
//检测车辆是否存在
sql = makesql.MakeCount(nameof(Model.Model.LC_Vehicle), "id=@id", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@id", bindvehicleid)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (ids.Count() > 0)
{
//检测我是否绑定过此车辆
sql = makesql.MakeCount(nameof(Model.Model.LC_VehicleBinding), "VehicleID=@VehicleID and DriverUID=@DriverUID", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@VehicleID", bindvehicleid),
new System.Data.SqlClient.SqlParameter("@DriverUID", myuservo.uid)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (ids.Count() == 0)
{
//创建一个绑定
sql = makesql.MakeInsertSQL(new Model.Model.LC_VehicleBinding()
{
BindingTime = DateTime.Now,
DriverUID = myuservo.uid,
VehicleID = bindvehicleid
});
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "添加绑定失败，请重试!");
}
//更新车辆为可用
sql = makesql.MakeUpdateSQL(new Model.Model.LC_Vehicle()
{
State = 1
}, "id=@id", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@id", bindvehicleid)
});
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "更新车辆状态失败!");
}
}
}
}
db.Commit();
return(true, string.Empty);
});
return(box);
}
/// <summary>
/// 物流公司账号绑定
/// </summary>
/// <param name="myuservo"></param>
/// <param name="nickName"></param>
/// <param name="phone"></param>
/// <param name="logistics">要绑定的物流总公司UID</param>
/// <param name="sheng"></param>
/// <param name="shi"></param>
/// <param name="qu"></param>
/// <param name="lineletter">货号字母</param>
/// <returns></returns>
public static (bool, string) LogisticsAccountBind(UserLoginVO myuservo, string nickName, long phone, string logistics, int sheng, int shi, int qu, string lineletter)
{
var box = db.CreateTranSandbox((db) =>
{
//查看电话号是否存在
sql = makesql.MakeCount(nameof(Model.Model.LC_User), "Phone=@Phone", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Phone", phone)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (ids.Count() > 0)
{
return(false, "当前手机号已被使用!");
}
//开始绑定
Model.Model.LC_User user = new Model.Model.LC_User()
{
UserName = nickName,
ZNumber = phone.ToString(),
LogisticsName = nickName,
Phone = phone.ToString(),
LCID = logistics,
ProvincesID = sheng,
CityID = shi,
AreaID = qu,
State = 1
//State = logistics.StrIsNotNull() ? 0 : 1
};
sql = makesql.MakeUpdateSQL(user, "uid=@uid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", myuservo.uid)
});
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "绑定失败请重试!");
}
//判断是否需要绑定线路
if (logistics.StrIsNotNull())
{
//获取物流账号是否存在
sql = makesql.MakeSelectSql(typeof(Model.Model.LC_User), "uid=@uid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", logistics)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ReadIsOk())
{
return(false, "获取总公司账号错误无法进行操作!");
}
Model.Model.LC_User df_user = ids.GetVOList <Model.Model.LC_User>()[0];
if (df_user.ZType.ConvertData <GlobalBLL.AccountTypeEnum>() != AccountTypeEnum.物流账号)
{
return(false, "权限错误,无法绑定到总公司!");
}
//开始双方绑定
//查看我是否绑定过此物流
sql = makesql.MakeCount(nameof(Model.Model.LC_Line), "uid=@uid and BindLogisticsUid=@BindLogisticsUid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", myuservo.uid),
new System.Data.SqlClient.SqlParameter("@BindLogisticsUid", logistics)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (ids.Count() == 0)
{
//绑定自己的
Model.Model.LC_Line myline = new Model.Model.LC_Line()
{
CreateTime = DateTime.Now,
Start = qu,
End = df_user.AreaID,
LineID = Tools.NewGuid.GuidTo16String(),
Lineletter = lineletter,
MyPhone = phone.ConvertData(),
MyResponsibleName = nickName,
DFPhone = df_user.Phone,
DFResponsibleName = df_user.UserName,
UID = myuservo.uid,
BindLogisticsUid = logistics,
State = 0,
ApplicantUID = myuservo.uid
};
sql = makesql.MakeInsertSQL(myline);
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "绑定对方物流数据失败!");
}
}
//查看对方是否绑定过我的物流
sql = makesql.MakeCount(nameof(Model.Model.LC_Line), "uid=@uid and BindLogisticsUid=@BindLogisticsUid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", logistics),
new System.Data.SqlClient.SqlParameter("@BindLogisticsUid", myuservo.uid)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (ids.Count() == 0)
{
//绑定对方物流
Model.Model.LC_Line dfline = new Model.Model.LC_Line()
{
Start = df_user.AreaID,
End = qu,
Lineletter = string.Empty,
DFPhone = phone.ConvertData(),
DFResponsibleName = nickName,
MyPhone = df_user.Phone,
MyResponsibleName = df_user.UserName,
UID = logistics,
BindLogisticsUid = myuservo.uid,
State = 0,
CreateTime = DateTime.Now,
LineID = Tools.NewGuid.GuidTo16String(),
ApplicantUID = myuservo.uid
};
sql = makesql.MakeInsertSQL(dfline);
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "绑定您的物流数据失败!");
}
}
}
db.Commit();
return(true, string.Empty);
});
return(box);
}
/// <summary>
/// 添加或者更新账号
/// </summary>
/// <param name="web"></param>
/// <param name="suser"></param>
/// <param name="rtype">类型</param>
/// <returns></returns>
public static (bool, string, Model.Model.LC_User suser) AddOrUpdateUserVO(HttpContextBase web, Model.Model.LC_User suser)
{
//验证数据是否正确
if (suser.WX_OpenID.StrIsNull())
{
return(false, "OPENID不能为空!", null);
}
return(DAL.DAL.LC_User.AddOrUpdateUserVO(suser));
}
/// <summary>
/// 注册用户
/// </summary>
/// <param name="lC_User"></param>
/// <returns></returns>
public static Tuple <bool, string> Add(Model.Model.LC_User lC_User, GlobalBLL.UserLoginVO loginvo, string LogisticsUid = "")
{
return(DAL.DAL.LC_User.Add(lC_User, loginvo, LogisticsUid));
}
/// <summary>
/// 添加车辆
/// </summary>
/// <param name="myuservo"></param>
/// <param name="lcv"></param>
/// <returns></returns>
public static (bool, string) AddVehicle(UserLoginVO myuservo, Model.Model.LC_Vehicle lcv)
{
var box = db.CreateTranSandbox((db) =>
{
Model.Model.LC_User wl_yg_uservo = null;
string logistics_uid = myuservo.uid;
switch (myuservo.accountType)
{
case AccountTypeEnum.物流公司员工账号:
//获取当前员工账号数据
var myuser = GetUserVoFromUID(myuservo.uid);
if (!myuser.Item1)
{
return(false, myuser.Item2);
}
if (myuser.Item3.PositionID != 1)
{
return(false, "当前账号不是驾驶员,无法访问此接口!");
}
logistics_uid = myuser.Item3.LCID;
wl_yg_uservo = myuser.Item3;
break;
}
lcv.UID = logistics_uid;
//查看车号是否存在
sql = makesql.MakeCount(nameof(Model.Model.LC_Vehicle), "VehicleNo=@VehicleNo and UID=@UID", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@VehicleNo", lcv.VehicleNo),
new System.Data.SqlClient.SqlParameter("@UID", logistics_uid)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (ids.Count() > 0)
{
return(false, "已经存在相同车号车辆,无法进行添加!");
}
//插入数据库
sql = makesql.MakeInsertSQL(lcv);
ids = db.Exec(sql, true);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "添加车辆失败!");
}
long index = ids.index_id;
if (myuservo.accountType == AccountTypeEnum.物流账号)
{
sql = makesql.MakeSelectSql(typeof(Model.Model.LC_User), "phone=@phone", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@phone", lcv.Phone)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ReadIsOk())
{
return(false, "您要绑定的司机不存在!");
}
Model.Model.LC_User siji = ids.GetVOList <Model.Model.LC_User>()[0];
if (siji.State != 1)
{
return(false, "当司机账号不可用!");
}
logistics_uid = siji.UID;
}
sql = makesql.MakeInsertSQL(new Model.Model.LC_VehicleBinding()
{
BindingTime = DateTime.Now,
DriverUID = logistics_uid,
VehicleID = index
});
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "绑定司机失败!");
}
db.Commit();
return(true, string.Empty);
});
return(box);
}
/// <summary>
/// 合作物流
/// </summary>
/// <param name="zNumber"></param>
/// <param name="pwd"></param>
/// <param name="bindUid"></param>
/// <param name="Lineletter">我的物流运号首字母</param>
/// <param name="bindLineletter">对方物流运号首字母</param>
/// <returns></returns>
public static Tuple <bool, string> BindHZ(string zNumber, string pwd, string bindUid, string myLineletter, string bindLineletter)
{
var box = db.CreateTranSandbox((db) =>
{
//查看您的账号是否存在
sql = makesql.MakeSelectSql(typeof(Model.Model.LC_User), "zNumber=@zNumber and Password=@Password", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@zNumber", zNumber),
new System.Data.SqlClient.SqlParameter("@Password", pwd)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (!ids.ReadIsOk())
{
return(new Tuple <bool, string>(false, "没有找到您的账号!"));
}
Model.Model.LC_User my_lcu = ids.GetVOList <Model.Model.LC_User>()[0];
if (my_lcu.ZType.ConvertData <GlobalBLL.AccountTypeEnum>() != GlobalBLL.AccountTypeEnum.物流账号)
{
return(new Tuple <bool, string>(false, "您的账号权限不正确,无法进行操作!"));
}
//获取绑定方账号信息
sql = makesql.MakeSelectSql(typeof(Model.Model.LC_User), "uid=@uid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", bindUid)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (!ids.ReadIsOk())
{
return(new Tuple <bool, string>(false, "没有找到要绑定方的合作物流数据!"));
}
Model.Model.LC_User bind_lcu = ids.GetVOList <Model.Model.LC_User>()[0];
if (bind_lcu.ZType.ConvertData <GlobalBLL.AccountTypeEnum>() != GlobalBLL.AccountTypeEnum.物流账号)
{
return(new Tuple <bool, string>(false, "账号类型不能为空!"));
}
#region 开始我方开始绑定
//查看我是否绑定过
sql = makesql.MakeCount(nameof(Model.Model.LC_Line), "uid=@uid and BindLogisticsUid=@BindLogisticsUid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@BindLogisticsUid", bind_lcu.UID),
new System.Data.SqlClient.SqlParameter("@uid", my_lcu.UID)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (ids.Count() == 0)
{
//绑定我方
Model.Model.LC_Line my_ll = new Model.Model.LC_Line()
{
BindLogisticsUid = bind_lcu.UID,
CreateTime = DateTime.Now,
End = bind_lcu.AreaID,
LineID = Tools.NewGuid.GuidTo16String(),
MyPhone = my_lcu.Phone.ConvertData(),
MyResponsibleName = my_lcu.UserName,
DFPhone = bind_lcu.Phone,
DFResponsibleName = bind_lcu.UserName,
UID = my_lcu.UID,
Start = my_lcu.AreaID,
Lineletter = myLineletter,
ApplicantUID = my_lcu.UID
};
//准备添加
sql = makesql.MakeInsertSQL(my_ll);
ids = db.Exec(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (!ids.ExecOk())
{
return(new Tuple <bool, string>(false, "添加绑定失败!"));
}
}
#endregion
//判断是否为相同的账号
if (bindUid.Equals(my_lcu.UID))
{
return(new Tuple <bool, string>(false, "不能绑定给自己!"));
}
if (bind_lcu.AreaID == my_lcu.AreaID)
{
return(new Tuple <bool, string>(false, "不能绑定相同地区的物流!"));
}
#region 对方开始绑定
//查看对方数据是否存在我的物流绑定
sql = makesql.MakeCount(nameof(Model.Model.LC_Line), "uid=@BindLogisticsUid and BindLogisticsUid=@uid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@BindLogisticsUid", bind_lcu.UID),
new System.Data.SqlClient.SqlParameter("@uid", my_lcu.UID)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (ids.Count() == 0)
{
//添加数据绑定
Model.Model.LC_Line bind_ll = new Model.Model.LC_Line()
{
BindLogisticsUid = my_lcu.UID,
CreateTime = DateTime.Now,
End = my_lcu.AreaID,
LineID = Tools.NewGuid.GuidTo16String(),
DFPhone = my_lcu.Phone.ConvertData(),
DFResponsibleName = my_lcu.UserName,
MyPhone = bind_lcu.Phone,
MyResponsibleName = bind_lcu.UserName,
UID = bind_lcu.UID,
Start = bind_lcu.AreaID,
Lineletter = bindLineletter,
ApplicantUID = my_lcu.UID
};
sql = makesql.MakeInsertSQL(bind_ll);
ids = db.Exec(sql);
if (!ids.flag)
{
return(new Tuple <bool, string>(false, ids.errormsg));
}
if (!ids.ExecOk())
{
return(new Tuple <bool, string>(false, "添加绑定失败!"));
}
}
#endregion
db.Commit();
return(new Tuple <bool, string>(true, string.Empty));
});
return(box);
}
/// <summary>
/// 线路绑定
/// </summary>
/// <param name="myuservo"></param>
/// <param name="lineletter">货号字母</param>
/// <param name="logistics">物流UID</param>
/// <returns></returns>
public static (bool, string) LineBinding(UserLoginVO myuservo, string lineletter, string logistics)
{
var box = db.CreateTranSandbox((db) =>
{
//获取物流账号是否存在
sql = makesql.MakeSelectSql(typeof(Model.Model.LC_User), "uid=@uid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", logistics)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ReadIsOk())
{
return(false, "获取您要绑定的物流数据操作!");
}
Model.Model.LC_User df_user = ids.GetVOList <Model.Model.LC_User>()[0];
if (df_user.ZType.ConvertData <AccountTypeEnum>() != AccountTypeEnum.物流账号)
{
return(false, "您要绑定的数据不是物流账号!");
}
//开始双方绑定
//查看我是否绑定过此物流
sql = makesql.MakeCount(nameof(Model.Model.LC_Line), "uid=@uid and BindLogisticsUid=@BindLogisticsUid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", myuservo.uid),
new System.Data.SqlClient.SqlParameter("@BindLogisticsUid", logistics)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (ids.Count() == 0)
{
//绑定自己的
Model.Model.LC_Line myline = new Model.Model.LC_Line()
{
CreateTime = DateTime.Now,
Start = myuservo.AreaID,
End = df_user.AreaID,
LineID = Tools.NewGuid.GuidTo16String(),
Lineletter = lineletter,
MyPhone = myuservo.phones.ConvertData(),
MyResponsibleName = myuservo.username,
DFPhone = df_user.Phone,
DFResponsibleName = df_user.UserName,
UID = myuservo.uid,
BindLogisticsUid = logistics,
State = 0,
ApplicantUID = myuservo.uid
};
sql = makesql.MakeInsertSQL(myline);
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "绑定对方物流数据失败!");
}
}
//查看对方是否绑定过我的物流
sql = makesql.MakeCount(nameof(Model.Model.LC_Line), "uid=@uid and BindLogisticsUid=@BindLogisticsUid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", logistics),
new System.Data.SqlClient.SqlParameter("@BindLogisticsUid", myuservo.uid)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (ids.Count() == 0)
{
//绑定对方物流
Model.Model.LC_Line dfline = new Model.Model.LC_Line()
{
Start = df_user.AreaID,
End = myuservo.AreaID,
Lineletter = string.Empty,
DFPhone = myuservo.phones.ConvertData(),
DFResponsibleName = myuservo.username,
MyPhone = df_user.Phone,
MyResponsibleName = df_user.UserName,
UID = logistics,
BindLogisticsUid = myuservo.uid,
State = 0,
CreateTime = DateTime.Now,
LineID = Tools.NewGuid.GuidTo16String(),
ApplicantUID = myuservo.uid
};
sql = makesql.MakeInsertSQL(dfline);
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "绑定您的物流数据失败!");
}
}
db.Commit();
return(true, string.Empty);
});
return(box);
}
/// <summary>
/// 主动绑定线路
/// </summary>
/// <param name="myuservo"></param>
/// <param name="lineletter"></param>
/// <param name="phone"></param>
/// <returns></returns>
public static (bool, string) LineActiveApplication(UserLoginVO myuservo, string lineletter, string phone)
{
var box = db.CreateTranSandbox((db) =>
{
//查看此物流是否存在
sql = makesql.MakeSelectSql(typeof(Model.Model.LC_User), "Phone=@Phone", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@Phone", phone)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ReadIsOk())
{
return(false, "没有找到您要绑定的物流公司数据!");
}
Model.Model.LC_User lcu = ids.GetVOList <Model.Model.LC_User>()[0];
if (lcu.State != 0)
{
return(false, "当前您要绑定的物流公司不可用!");
}
//检测我是否已经绑定过此物流
sql = makesql.MakeCount(nameof(Model.Model.LC_Line), "UID=@UID and BindLogisticsUid=@BindLogisticsUid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@UID", myuservo.uid),
new System.Data.SqlClient.SqlParameter("@BindLogisticsUid", lcu.UID)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (ids.Count() > 0)
{
return(false, "不可以重复绑定相同的物流!");
}
//开始绑定我的数据
Model.Model.LC_Line my_line = new Model.Model.LC_Line()
{
ApplicantUID = myuservo.uid,
BindLogisticsUid = lcu.UID,
LineID = Tools.NewGuid.GuidTo16String(),
CreateTime = DateTime.Now,
DFPhone = lcu.Phone,
DFResponsibleName = lcu.UserName,
Lineletter = lineletter,
End = lcu.AreaID,
MyPhone = myuservo.phones,
MyResponsibleName = myuservo.username,
Start = myuservo.AreaID,
State = 0,
UID = myuservo.uid,
};
//插入数据库
sql = makesql.MakeInsertSQL(my_line);
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "绑定失败!");
}
//绑定对方数据
Model.Model.LC_Line df_line = new Model.Model.LC_Line()
{
ApplicantUID = myuservo.uid,
BindLogisticsUid = myuservo.uid,
LineID = Tools.NewGuid.GuidTo16String(),
CreateTime = DateTime.Now,
DFPhone = myuservo.phones,
DFResponsibleName = myuservo.username,
End = myuservo.AreaID,
MyPhone = lcu.Phone,
MyResponsibleName = lcu.UserName,
Start = lcu.AreaID,
State = 0,
UID = lcu.UID,
};
sql = makesql.MakeInsertSQL(df_line);
ids = db.Exec(sql);
if (!ids.flag)
{
return(false, ids.errormsg);
}
if (!ids.ExecOk())
{
return(false, "绑定对方数据时失败!");
}
db.Commit();
return(true, string.Empty);
});
return(box);
}