public void SyncOper(IAMSCMUow amscmUow)
{
ynhnTransportManage.Models.AccountMembershipService MembershipService = new ynhnTransportManage.Models.AccountMembershipService();
var ltbLogin = amscmUow.tbLogin.GetAll().ToList();
foreach (DXInfo.Models.tbLogin tbLogin in ltbLogin)
{
DXInfo.Models.aspnet_Users user = uow.aspnet_Users.GetAll().Where(w => w.UserName == tbLogin.vcLoginID).FirstOrDefault();
DXInfo.Models.Depts dept = uow.Depts.GetAll().Where(w => w.DeptCode == tbLogin.vcDeptID).FirstOrDefault();
if (user == null)
{
if (dept != null)
{
MembershipCreateStatus createStatus = MembershipService.CreateUser(tbLogin.vcLoginID, tbLogin.vcPwd, tbLogin.vcOperName, dept.DeptId);
}
}
else
{
DXInfo.Models.aspnet_Membership memberShip = uow.aspnet_Membership.GetAll().Where(w => w.UserId == user.UserId).FirstOrDefault();
if (memberShip == null)
{
if (dept != null)
{
MembershipCreateStatus createStatus = MembershipService.CreateUser(tbLogin.vcLoginID, tbLogin.vcPwd, tbLogin.vcOperName, dept.DeptId);
}
}
}
}
}
public static List <DXInfo.Models.tbBillOfMaterials> getBOM(IAMSCMUow uow)
{
List <DXInfo.Models.tbBillOfMaterials> ltbBillOfMaterials = (from d in uow.tbBillOfMaterials.GetAll() select d).ToList();
ltbBillOfMaterials.ForEach(delegate(DXInfo.Models.tbBillOfMaterials tbBillOfMaterials)
{
tbBillOfMaterials.cnnBaseQtyN = tbBillOfMaterials.cnnBaseQtyD / tbBillOfMaterials.cnnBaseQtyD;
tbBillOfMaterials.cnnBaseQtyD = 1;
});
return(ltbBillOfMaterials);
}
public static void SyncGoods(DXInfo.Models.tbInventory inv, IAMSCMUow uow)
{
DXInfo.Models.tbGoods tbGoods = uow.tbGoods.GetById(g => g.vcGoodsID == inv.cnvcInvCode);
if (inv.cnbSale)
{
if (tbGoods == null)
{
DXInfo.Models.tbGoods gs = new DXInfo.Models.tbGoods();
gs.vcGoodsID = inv.cnvcInvCode;
gs.vcGoodsName = inv.cnvcInvName;
gs.vcSpell = Helper.GetChineseSpell(inv.cnvcInvName);
gs.nPrice = Convert.ToDecimal(inv.cnfRetailPrice);
gs.nRate = 0;
gs.iIgValue = -1;
gs.cNewFlag = "0";
gs.vcComments = "存货档案添加同步";
uow.tbGoods.Add(gs);
}
else
{
if (tbGoods.vcGoodsName != inv.cnvcInvName)
{
tbGoods.vcGoodsName = inv.cnvcInvName;
tbGoods.vcSpell = Helper.GetChineseSpell(inv.cnvcInvName);
}
if (inv.cnfRetailPrice > 0)
{
tbGoods.nPrice = Convert.ToDecimal(inv.cnfRetailPrice);
}
tbGoods.vcComments = "存货档案修改同步";
}
}
else
{
if (tbGoods != null)
{
uow.tbGoods.Delete(tbGoods);
}
}
}
public void SyncGT(IAMSCMUow amscmUow)
{
var ltbCommCode = amscmUow.tbCommCode.GetAll().Where(w => w.vcCommSign == "GT").ToList();
foreach (DXInfo.Models.tbCommCode commCode in ltbCommCode)
{
var oldInvCat = uow.InventoryCategory.GetAll().Where(w => w.Code == commCode.vcCommCode).FirstOrDefault();
if (oldInvCat == null)
{
DXInfo.Models.InventoryCategory newInvCat = new DXInfo.Models.InventoryCategory();
newInvCat.Code = commCode.vcCommCode;
newInvCat.Name = commCode.vcCommName;
if (System.Configuration.ConfigurationManager.AppSettings.AllKeys.Contains("AMSApp"))
{
newInvCat.ProductType = (int)DXInfo.Models.ProductType.Product;
}
newInvCat.CategoryType = (int)DXInfo.Models.CategoryType.StockManage;
uow.InventoryCategory.Add(newInvCat);
}
}
uow.Commit();
}
public static void AddStockDetal(IAMSCMUow uow, DXInfo.Models.tbStockMain tbStockMain, string cnvcInvCode
, string cnvcComUnitCode, decimal cnnQuantity, string cnvcMainComUnitCode, decimal cnnMainQuantity, decimal cnnPrice, decimal cnnAmount)
{
DXInfo.Models.tbStockDetail tbStockDetail = new DXInfo.Models.tbStockDetail();
tbStockDetail.cnnMainId = tbStockMain.cnnMainId;
tbStockDetail.cnvcInvCode = cnvcInvCode;
tbStockDetail.cnvcComUnitCode = cnvcComUnitCode;
tbStockDetail.cnnQuantity = cnnQuantity;
tbStockDetail.cnvcMainComUnitCode = cnvcMainComUnitCode;
tbStockDetail.cnnMainQuantity = cnnMainQuantity;
tbStockDetail.cnnPrice = cnnPrice;
tbStockDetail.cnnAmount = cnnAmount;
tbStockDetail.cndOperDate = tbStockMain.cndCreateDate;
tbStockDetail.cnvcOper = tbStockMain.cnvcCreaterId;
tbStockDetail.cnvcOperName = tbStockMain.cnvcCreaterName;
uow.tbStockDetail.Add(tbStockDetail);
uow.Commit();
DXInfo.Models.tbStockDetailLog tbStockDetailLog = new DXInfo.Models.tbStockDetailLog();
ServiceHelper.SetEntity <DXInfo.Models.tbStockDetail, DXInfo.Models.tbStockDetailLog>(tbStockDetail, tbStockDetailLog);
uow.tbStockDetailLog.Add(tbStockDetailLog);
}
public tbNameCode(IAMSCMUow uow)
{
this.Uow = uow;
}
public tbDept(IAMSCMUow uow)
{
this.Uow = uow;
}
public tbStockDetail(IAMSCMUow uow)
{
this.Uow = uow;
}
public tbInventory(IAMSCMUow uow)
{
this.Uow = uow;
}
public tbStockMain(IAMSCMUow uow)
{
this.Uow = uow;
}
public tbComputationUnit(IAMSCMUow uow)
{
this.Uow = uow;
}
public tbMonthlyBalance(IAMSCMUow uow)
{
this.Uow = uow;
}
public AccountController(IFairiesMemberManageUow uow, IAMSCMUow amscmUow) : base(uow)
{
this.AmscmUow = amscmUow;
this.Uow.Db.ExecuteSqlCommand("SET TRANSACTION ISOLATION LEVEL READ COMMITTED;");
}
public StockReport(IAMSCMUow uow)
{
this.Uow = uow;
}
public tbWarehouse(IAMSCMUow uow)
{
this.Uow = uow;
}
public tbLogin(IAMSCMUow uow)
{
this.Uow = uow;
}
public tbSupplier(IAMSCMUow uow)
{
this.Uow = uow;
}
public tbBillOfMaterials(IAMSCMUow uow)
{
this.Uow = uow;
}
public tbComputationGroup(IAMSCMUow uow)
{
this.Uow = uow;
}
public tbProductClass(IAMSCMUow uow)
{
this.Uow = uow;
}
