//添加新路线
public static Tuple <bool, string> Add(Model.Model.LC_Line LC_Line, GlobalBLL.UserLoginVO uservo)
{
//查看是否存在
sql = makesql.MakeCount(nameof(Model.Model.LC_Line), "[End]=@End and uid=@uid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@End", LC_Line.End),
new System.Data.SqlClient.SqlParameter("@uid", uservo.uid)
});
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, "您已经添加过此路线,无需重复添加!"));
}
sql = makesql.MakeInsertSQL(LC_Line);
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);
}
public static Tuple <bool, string, List <Dictionary <string, I_ModelBase> > > GetLCFHADDList(GlobalBLL.UserLoginVO myuservo)
{
//获取我绑定的物流列表
sql = makesql.MakeSelectSql(typeof(Model.Model.LC_UserBindLogisticsList), "uid=@uid", new System.Data.SqlClient.SqlParameter[] {
new System.Data.SqlClient.SqlParameter("@uid", myuservo.uid)
});
ids = db.Read(sql);
if (!ids.flag)
{
return(new Tuple <bool, string, List <Dictionary <string, I_ModelBase> > >(false, ids.errormsg, null));
}
if (!ids.ReadIsOk())
{
return(new Tuple <bool, string, List <Dictionary <string, I_ModelBase> > >(false, "您没有绑定任何物流公司无法进行发货!", null));
}
var ubll_list = ids.GetVOList <Model.Model.LC_UserBindLogisticsList>();
//两表查询
Type[] tlist = new Type[] {
typeof(Model.Model.LC_User),
typeof(Model.Model.LC_Line)
};
sql = makesql.MakeSelectArrSql(tlist, "{0}.UID={1}.UID and {0}.UID in (" + ubll_list.Select(x => "'" + x.LogisticsUid + "'").ToList().ListToString() + ")");
ids = db.Read(sql);
if (!ids.flag)
{
return(new Tuple <bool, string, List <Dictionary <string, I_ModelBase> > >(false, ids.errormsg, null));
}
if (ids.ReadIsOk())
{
return(new Tuple <bool, string, List <Dictionary <string, I_ModelBase> > >(true, string.Empty, ids.GetVOList(tlist)));
}
return(new Tuple <bool, string, List <Dictionary <string, I_ModelBase> > >(true, "没有任何数据", null));
}
/// <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));
}
public static Tuple <bool, string> Add(Model.Model.LC_Line LC_Line, GlobalBLL.UserLoginVO uservo)
{
return(DAL.DAL.LC_Line.Add(LC_Line, uservo));
}