private void ddlPartCode_SelectionChangeCommitted(object sender, EventArgs e)
{
TA_PART part = (TA_PART)ddlCustPartCode.SelectedItem;
if (part != null)
{
SetValue(part);
}
}
public UcPart()
{
InitializeComponent();
Readonly = false;
ddlCustPartCode.Visible = true;
ddlPartCode.Visible = true;
_part = new TA_PART();
panelColor.BackColor = Color.Transparent;
}
public static void AddOrUpdate(SpareEntities db, TA_PART selectedData)
{
try
{
db.TA_PART.AddOrUpdate(p => p.PartCode, selectedData);
}
catch (DbEntityValidationException dbEx)
{
Console.WriteLine(dbEx.ToString());
throw;
}
}
public static void AddOrUpdate(SpareEntities db, TA_PART selectedData, TS_OPERATOR oper)
{
var logType = db.TA_PART.Any(p => p.UID == selectedData.UID) ? LogType.BaseDataModify : LogType.BaseDataCreate;
try
{
db.TA_PART.AddOrUpdate(p => p.PartCode, selectedData);
OperLogController.AddLog(db, logType, oper.OperName, selectedData.ToString());
}
catch (DbEntityValidationException dbEx)
{
Console.WriteLine(dbEx.ToString());
throw;
}
}
private static void ReadPartFile(List <string> dataList, string filename, SpareEntities db)
{
Console.WriteLine(@"接收零件数据开始");
var partList = new List <TA_PART>();
for (int i = 0; i < dataList.Count; i++)
{
string strErr = "零件文件 " + filename + " 第 " + i + " 行 \t";
string data = dataList[i];
var cols = data.Split(';');
if (cols.Length != 8)
{
Console.WriteLine(strErr + @" 格式错误" + Environment.NewLine + "\t\t\t\t" + data);
continue;
}
string partCode = cols[0];
if (string.IsNullOrEmpty(partCode))
{
Console.WriteLine(strErr + @" partCode为空" + Environment.NewLine + "\t\t\t\t" + data);
continue;
}
TA_PART part = db.TA_PART.FirstOrDefault(p => p.ErpPartCode == partCode) ?? new TA_PART
{
ErpPartCode = partCode,
State = (int)DataState.Enabled,
MaxQty = 0,
MinQty = 0,
SafeQty = 0
};
if (partList.Exists(p => p.ErpPartCode == partCode))
{
Console.WriteLine(strErr + @" partCode重复" + Environment.NewLine + "\t\t\t\t" + data);
continue;
}
part.PartDesc1 = cols[1];
part.PartDesc2 = cols[2];
part.BM = cols[3];
part.Unit = cols[5];
partList.Add(part);
}
PartController.AddOrUpdate(db, partList);
Console.WriteLine(@"接收零件数据完成");
}
public void SetValues(TA_PART part)
{
var stockM = BLL.StockController.GetStockMasterByMaterialCode(part.cPartCode);
Part = part;
PartCode = part.cPartCode;
PartName = part.cPartName;
ErpCode = part.cErpCode;
UsableQty = stockM.dUsableQty;
Qty = part.dStdBoxQty;
EndTime = DateTime.Now.AddMinutes(part.nPreMinutes);
StdBoxQty = part.dStdBoxQty;
if (BtnClick != null)
{
BtnClick(this, null);
}
}
public void SetValue(TA_PART part)
{
_part = part;
if (part == null || part.PartCode == null)
{
return;
}
ddlPartCode.Text = part.PartCode;
ddlPartCode.SelectedText = part.PartCode;
ddlPartCode.SelectedItem = part;
txtPartCode.Text = part.PartCode;
txtPartName.Text = part.PartDesc1;
if (part.PartDesc1 == null)
{
return;
}
if (part.PartDesc1.Contains("黑"))
{
panelColor.BackColor = Color.Black;
}
else if (part.PartDesc1.Contains("灰"))
{
panelColor.BackColor = Color.LightGray;
}
else if (part.PartDesc1.Contains("米"))
{
panelColor.BackColor = Color.SeaShell;
}
else if (part.PartDesc1.Contains("棕"))
{
panelColor.BackColor = Color.SaddleBrown;
}
else
{
panelColor.BackColor = Color.Transparent;
}
}
private static void GetOAData(InterfaceEntities OAdb, SpareEntities db)
{
var SparePartlist = new List <TA_PART>();
var SpareBillList = new List <TB_BILL>();
var SparePOList = new List <TB_PO>();
//同步零件号
var partlist = OAdb.OA_PART.Where(p => p.IsSyn == 0).ToList();
if (partlist.Count > 0)
{
foreach (var part in partlist)
{
var SparePart = PartController.GetPartByPartCode(db, part.code);
if (SparePart == null)
{
SparePart = new TA_PART();
}
SparePart.PartCode = part.code;
SparePart.ErpPartCode = part.code;
SparePart.PartDesc1 = part.engname;
SparePart.PartDesc2 = part.name;
SparePart.Unit = part.unit;
SparePart.BM = "B";
SparePartlist.Add(SparePart);
}
PartController.AddOrUpdate(db, SparePartlist);
NotifyController.AddNotify(db, GlobalVar.OperName, NotifyType.OAInterfaceBase, "", "");
}
//同步采购订单
var OAPOBill = OAdb.OA_PO_MAIN.FirstOrDefault(p => p.IsSyn == 0);
if (OAPOBill != null)
{
var _bill = new TB_BILL()
{
BillNum = OAPOBill.orderno,
BillType = (int)BillType.PuchaseOrder,
BillTime = DateTime.Now,
OperName = OAPOBill.@operator,
SplyId = OAPOBill.suppliername,
Remark = OAPOBill.remark
};
SpareBillList.Add(_bill);
OAPOBill.IsSyn = 1;
OAdb.OA_PO_MAIN.AddOrUpdate(OAPOBill);
var OAPOList = OAdb.OA_PO_SUB.Where(p => p.OAMainID == OAPOBill.OAID);
foreach (var oaPoSub in OAPOList)
{
var SparePo = new TB_PO()
{
BillNum = _bill.BillNum,
Line = Convert.ToInt32(oaPoSub.prln),
PartCode = oaPoSub.itemnumber,
BillQty = (decimal)oaPoSub.qty
};
SparePOList.Add(SparePo);
}
BillHandler.AddPO(db, SpareBillList, SparePOList);
NotifyController.AddNotify(db, GlobalVar.OperName, NotifyType.OAInterfacePO, "", "");
}
}
public static void Delete(SpareEntities db, TA_PART data, TS_OPERATOR oper)
{
db.Entry(data).State = EntityState.Deleted;
OperLogController.AddLog(db, LogType.BaseDataDelete, oper.OperName, data.ToString());
}
