public void GetLineForPrint()
{
using (FASEntities FAS = new FASEntities())
{
LineForPrint = FAS.FAS_Lines.Where(c => c.LineID == LineID).Select(c => c.Print_Line).FirstOrDefault();
}
}
public ArrayList GetInfoPacing(int serialnumber)
{
using (var FAS = new FASEntities())
{
var ArrayList = new ArrayList();
var list = (from pac in FAS.FAS_PackingGS
join lit in FAS.FAS_Liter on pac.LiterID equals lit.ID
join us in FAS.FAS_Users on pac.PackingByID equals us.UserID
from st in FAS.FAS_Start.Where(c => c.SerialNumber == pac.SerialNumber).DefaultIfEmpty()
where pac.SerialNumber == serialnumber
select new
{
fullst = !st.FullSTBSN.Equals(null),
liter = lit.LiterName + pac.LiterIndex,
pac.PalletNum,
pac.BoxNum,
pac.UnitNum,
pac.PackingDate,
us.UserName
});
if (list.Count() == 0)
{
return(ArrayList);
}
var report = list.First().GetType().GetProperties().Select(c => c.GetValue(list.First()));
foreach (var value in report)
{
ArrayList.Add(value);
}
return(ArrayList);
}
}
bool Checkrange()
{
using (var fas = new FASEntities())
{
return(fas.FAS_Fixed_RG.Where(c => c.LotID == LOTID).Select(c => c.LotID == c.LotID).FirstOrDefault());
}
}
void GetWorkScenarioID(string Scenario)
{
using (var fas = new FASEntities())
{
WorkScenarioId = fas.FAS_WorkingScenario.Where(c => c.Scenario == Scenario).Select(c => c.ID).FirstOrDefault();
}
}
public DateTime GetManufDate(string SN)
{
using (var _fas = new FASEntities())
{
return(_fas.FAS_Start.Where(c => c.FullSTBSN == SN).Select(c => c.ManufDate).FirstOrDefault());
}
}
private void AbortBT_Click(object sender, EventArgs e)
{
List <int> list = new List <int>();
for (int i = 0; i < SNGrid.RowCount; i++)
{
list.Add(int.Parse(SNGrid[1, i].Value.ToString()));
}
using (var fas = new FASEntities())
{
var delete = fas.FAS_Upload.Where(c => list.Contains(c.SerialNumber));
fas.FAS_Upload.RemoveRange(delete);
var deleteFas = fas.FAS_Start.Where(c => list.Contains(c.SerialNumber));
fas.FAS_Start.RemoveRange(deleteFas);
//--------------------------------------------------------------------------------------------------
var _fas = fas.FAS_SerialNumbers.Where(c => list.Contains(c.SerialNumber)).AsEnumerable().Select(c =>
{ c.IsUsed = false; c.IsActive = true; c.IsUploaded = false; c.IsWeighted = false; c.IsPacked = false;
return(c); });
foreach (FAS_SerialNumbers item in _fas)
{
fas.Entry(item).State = (System.Data.Entity.EntityState)EntityState.Modified;
}
fas.SaveChanges();
}
INFO.Text = "Номера откреплены успешно!";
SNGrid.DataSource = null;
}
public ArrayList GetSerialNum(int shortSN)
{
using (var Fas = new FASEntities())
{
var ArrayList = new ArrayList();
var list = (from S in Fas.FAS_SerialNumbers
join F in Fas.FAS_Start on S.SerialNumber equals F.SerialNumber
where S.LOTID == LOTID & S.SerialNumber == shortSN
select new { F.PCBID, S.IsUsed, S.IsActive, S.IsUploaded, S.IsWeighted, S.IsPacked, S.InRepair });
try
{
var report = list.First().GetType().GetProperties().Select(c => c.GetValue(list.First()));
foreach (var value in report)
{
ArrayList.Add(value);
}
return(ArrayList);
}
catch (Exception)
{
return(ArrayList);
}
}
}
void GetLineID()
{
using (FASEntities FAS = new FASEntities())
{
LineID = FAS.FAS_Lines.Where(c => c.LineName == CB_Line.Text).Select(c => c.LineID).FirstOrDefault();
}
}
void AddSerialNumberHDCPCert(short LotID)
{
using (var fas = new FASEntities())
{
for (int i = 0; i < NumerSN.Value; i++)
{
var _ser = new FAS_SerialNumbers()
{
LOTID = LotID,
IsUsed = false,
IsActive = true,
IsUploaded = false,
IsWeighted = false,
IsPacked = false,
InRepair = false,
FAS_HDCP = new FAS_HDCP()
{
HDCPName = HDCPGrid[0, i].Value.ToString(),
HDCPContent = File.ReadAllBytes(HDCPGrid[1, i].Value.ToString()),
},
FAS_CERT = new FAS_CERT()
{
CERTName = CertGrid[0, i].Value.ToString(),
CertContent = File.ReadAllBytes(CertGrid[1, i].Value.ToString()),
}
};
fas.FAS_SerialNumbers.Add(_ser);
fas.SaveChanges();
}
}
}
private void UpdateBT_Click(object sender, EventArgs e) //Update данных
{
short lotid = short.Parse(GridInfo[1, 2].Value.ToString());
using (var FAS = new FASEntities())
{
var _fas = FAS.FAS_GS_LOTs.Where(c => c.LOTID == lotid);
_fas.FirstOrDefault().LOTCode = short.Parse(GridInfo[1, 0].Value.ToString()); //LotCode
_fas.FirstOrDefault().FULL_LOT_Code = GridInfo[1, 1].Value.ToString(); //FullLotCode
_fas.FirstOrDefault().ModelID = modelID; //Model
_fas.FirstOrDefault().Specification = GridInfo[1, 4].Value.ToString(); // Spec
_fas.FirstOrDefault().Manufacturer = GridInfo[1, 5].Value.ToString(); //DTVS
_fas.FirstOrDefault().Operator = GridInfo[1, 6].Value.ToString(); // TRICOLOR
_fas.FirstOrDefault().MarketID = GridInfo[1, 7].Value.ToString(); // Market
_fas.FirstOrDefault().PTID = GridInfo[1, 8].Value.ToString(); //Ptid
_fas.FirstOrDefault().BoxCapacity = int.Parse(GridInfo[1, 9].Value.ToString()); //BOX
_fas.FirstOrDefault().PalletCapacity = int.Parse(GridInfo[1, 10].Value.ToString()); //Pallet
_fas.FirstOrDefault().IsHDCPUpload = bool.Parse(GridInfo[1, 11].Value.ToString()); //HDCP
_fas.FirstOrDefault().IsCertUpload = bool.Parse(GridInfo[1, 12].Value.ToString()); //Cert
_fas.FirstOrDefault().IsMACUpload = bool.Parse(GridInfo[1, 13].Value.ToString()); //Mac
_fas.FirstOrDefault().ModelCheck = bool.Parse(GridInfo[1, 14].Value.ToString()); //ModelCH
_fas.FirstOrDefault().SWRead = bool.Parse(GridInfo[1, 15].Value.ToString()); //SW
_fas.FirstOrDefault().SWGS1Read = bool.Parse(GridInfo[1, 16].Value.ToString()); //SW1
_fas.FirstOrDefault().GetWeight = bool.Parse(GridInfo[1, 17].Value.ToString()); //Weight
_fas.FirstOrDefault().LabelScenarioID = labelscenarioId; // Label
_fas.FirstOrDefault().WorkingScenarioID = WorkScenarioId;
_fas.FirstOrDefault().CreateDate = DateTime.Parse(GridInfo[1, 20].Value.ToString()); //Date
FAS.SaveChanges();
MessageBox.Show("Сохранено!", "Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
void GetSNCount()
{
using (var fas = new FASEntities())
{
SNCount = fas.FAS_SerialNumbers.Where(c => c.LOTID == lotid).Count();
}
}
string GetLotName()
{
using (var fas = new FASEntities())
{
return(fas.FAS_GS_LOTs.Where(c => c.LOTID == lotid).Select(c => c.FULL_LOT_Code).FirstOrDefault());
}
}
bool CheckCounter()
{
using (var FAS = new FASEntities())
{
return(FAS.FAS_PackingCounter.Where(c => c.LOTID == LOTID & c.LineID == LineID & c.LitIndex == LitIndex).Select(c => c.ID == c.ID).FirstOrDefault());
}
}
string CheckSerialNumber(string SerialNumber)
{
if (!int.TryParse(SerialNumber.Substring(15), out int k))
{
return($"Ошибка преобразования серийного номера - {SerialNumber} - в число, не верный номер!"); //Ошибка преобразования
}
int serial = int.Parse(SerialNumber.Substring(15));
using (var fas = new FASEntities())
{
bool Result = fas.FAS_SerialNumbers.Where(c => c.SerialNumber == serial & c.LOTID == LOTID).Select(c => c.SerialNumber == c.SerialNumber).FirstOrDefault();
if (!Result)
{
return($"Серийный номер - {SerialNumber} - не найден в таблице Fas_SerialNumbers в текущем лоте!"); //номер не найден в лоте
}
Result = fas.FAS_SerialNumbers.Where(c => c.SerialNumber == serial & c.LOTID == LOTID & c.IsUsed == true).Select(c => c.SerialNumber == c.SerialNumber).FirstOrDefault();
if (!Result)
{
return($"Серийный номер - {SerialNumber} - имеет статус IsUsed = 0, номер не использован в базе "); //Номер не использован
}
var ser = fas.FAS_Start.Where(c => c.FullSTBSN == SerialNumber).Select(c => c.FullSTBSN).FirstOrDefault();
if (string.IsNullOrEmpty(ser))
{
return($"Серийный номер - {SerialNumber} - не найден в таблице Fas_Start"); //Номер не зарегистрирован на FasStart
}
return(ser);
}
}
void AddPackingGS()
{
using (var fas = new FASEntities())
{
var _fas = new FAS_PackingGS
{
SerialNumber = ShortSN,
LiterID = literID,
LiterIndex = LitIndex,
PalletNum = Arraylpac[0],
BoxNum = Arraylpac[1],
LOTID = (short)LOTID,
UnitNum = Arraylpac[2],
PackingDate = DateTime.UtcNow.AddHours(2),
PackingByID = (short)UserID
};
var _fas1 = fas.FAS_SerialNumbers.Where(c => c.SerialNumber == ShortSN);
_fas1.FirstOrDefault().IsPacked = true;
//fas.SaveChanges();
fas.FAS_PackingGS.Add(_fas);
fas.SaveChanges();
}
}
ArrayList GetPac() //отсутствует баркод
{
using (var FAS = new FASEntities())
{
var ArrayList = new ArrayList();
var list = from P in FAS.FAS_PackingGS
join S in FAS.FAS_Start on P.SerialNumber equals S.SerialNumber
join L in FAS.FAS_Liter on P.LiterID equals L.ID
where P.SerialNumber == ShortSN
select new { P.UnitNum, S.FullSTBSN, Liter = L.LiterName + P.LiterIndex, P.PalletNum, P.BoxNum, P.PackingDate };
try
{
var report = list.First().GetType().GetProperties().Select(c => c.GetValue(list.First()));
foreach (var value in report)
{
ArrayList.Add(value);
}
return(ArrayList);
}
catch (Exception)
{
return(ArrayList);
}
}
}
public bool CheckPacking(int serialnumber)
{
using (var fas = new FASEntities())
{
return(fas.FAS_PackingGS.Select(c => c.SerialNumber == serialnumber).FirstOrDefault());
}
}
object WorkScenario()
{
using (var fas = new FASEntities())
{
return(fas.FAS_WorkingScenario.Select(c => c.Scenario + " | " + c.Description).ToList());
}
}
int CheckSerialNumer(int serialnumber)
{
using (FASEntities FAS = new FASEntities())
{
return(FAS.FAS_SerialNumbers.Where(c => c.SerialNumber == serialnumber && c.PrintStationID == StationID).Select(c => c.SerialNumber).FirstOrDefault());
}
}
object ModelList()
{
using (var fas = new FASEntities())
{
return(fas.FAS_Models.Where(c => c.ModelTypeID == 1).Select(c => c.ModelName).Distinct().ToList());
}
}
void GetModelId(string model)
{
using (var fas = new FASEntities())
{
modelID = fas.FAS_Models.Where(c => c.ModelName == model).Select(c => c.ModelID).FirstOrDefault();
}
}
List <bool> CheckTableData(int ShortSN) //Проверка флажков
{
using (var FAS = new FASEntities())
{
var List = new List <bool>();
var list = (from ST in FAS.FAS_Start
from UP in FAS.FAS_Upload.Where(c => c.SerialNumber == ST.SerialNumber).DefaultIfEmpty()
from Pac in FAS.FAS_PackingGS.Where(c => c.SerialNumber == ST.SerialNumber).DefaultIfEmpty()
where ST.SerialNumber == ShortSN
select new
{
ST = !ST.SerialNumber.Equals(null),
UP = !UP.SerialNumber.Equals(null),
Pac = !Pac.SerialNumber.Equals(null),
});
var report = list.First().GetType().GetProperties().Select(c => c.GetValue(list.First()));
foreach (var value in report.OfType <bool>())
{
List.Add(value);
}
return(List);
}
}
byte GetLiterID()
{
using (var Fas = new FASEntities())
{
var linename = ArrayList[2].ToString();
return((byte)Fas.FAS_Liter.Where(c => c.Description == linename).Select(c => c.ID).FirstOrDefault());
}
}
int GetPCBID()
{
using (var fas = new FASEntities())
{
var sernumber = int.Parse(FullSTBSN.Substring(15));
return(fas.FAS_Start.Where(c => c.SerialNumber == sernumber).Select(c => c.PCBID).FirstOrDefault());
}
}
public int GetErrorCodeID(string err)
{
using (var FAS = new FASEntities())
{
return((from er in FAS.FAS_ErrorCode
where er.ErrGroup == 1 && er.Category + er.Code == err
select er.ErrorCodeID).FirstOrDefault());
}
}
public void DeleteToDBDesis(int serial)
{
using (var FAS = new FASEntities())
{
var fas = FAS.FAS_Start.Where(c => c.SerialNumber == serial).FirstOrDefault();
FAS.FAS_Start.Remove(fas);
FAS.SaveChanges();
}
}
void update()
{
using (FASEntities FAS = new FASEntities())
{
var F = FAS.FAS_SerialNumbers.Where(c => c.SerialNumber == SerNumber);
F.FirstOrDefault().IsActive = false;
FAS.SaveChanges();
}
}
void SetSerialNumber()
{
using (var fas = new FASEntities())
{
//var _fas = fas.FAS_SerialNumbers.Where(c => c.SerialNumber == ShortSN);
//_fas.FirstOrDefault().IsPacked = true;
//fas.SaveChanges();
}
}
void updateLine()
{
using (FASEntities Fas = new FASEntities())
{
var App = Fas.FAS_App_ListForPC.Where(c => c.StationID == BaseC.StationID & c.App_ID == BaseC.IDApp);
App.FirstOrDefault().LineID = (byte)this.LineID;
App.FirstOrDefault().CreateDate = DateTime.UtcNow.AddHours(2);
Fas.SaveChanges();
}
}
void updateSerNum(int serialNumber)
{
using (FASEntities FAS = new FASEntities())
{
var FAS_S = FAS.FAS_SerialNumbers.Where(c => c.SerialNumber == serialNumber);
FAS_S.FirstOrDefault().IsUsed = true;
FAS_S.FirstOrDefault().PrintStationID = (short)StationID;
FAS.SaveChanges();
}
}
