public void SaveCraftDetail(CraftDetailModel model)
{
CraftInfo craft = this.GetCraft(model.CraftDID);
CraftProbablyInfo craftProbably = this.GetCraftProbably(model.CraftDID);
craft.CraftName = model.CraftName;
craftProbably.TargetYield = model.TargetYield;
this.DataContext.SaveChanges();
}
//------------------最强分界线---
public CraftProbablyInfo GetCraftProbably(int craftDID, string code)
{
DataTable tbCraftProbablyInfo = getCraftProbably(craftDID);
if (tbCraftProbablyInfo != null && tbCraftProbablyInfo.Rows.Count > 0)
{
int i = tbCraftProbablyInfo.Rows.Count - 1;
CraftProbablyInfo info = new CraftProbablyInfo();
info.CraftDID = craftDID;
info.UseName = tbCraftProbablyInfo.Rows[i][0].ToString();
info.NowYield = tbCraftProbablyInfo.Rows[i][1].ToString();
info.TargetYield = tbCraftProbablyInfo.Rows[i][2].ToString();
info.DeviceName = tbCraftProbablyInfo.Rows[i][3].ToString();
info.PPM = double.Parse(tbCraftProbablyInfo.Rows[i][4].ToString());
info.OKCount = int.Parse(tbCraftProbablyInfo.Rows[i][5].ToString());
info.BatteryBarCode = tbCraftProbablyInfo.Rows[i][6].ToString();
if (int.Parse(tbCraftProbablyInfo.Rows[i][1].ToString()) != 0)
{
info.OKRate = (float.Parse(tbCraftProbablyInfo.Rows[i][5].ToString())
/ float.Parse(tbCraftProbablyInfo.Rows[i][1].ToString()) * 100).ToString() + "%";
}
else
{
info.OKRate = "0%";
}
if (tbCraftProbablyInfo.Rows[i][7].ToString() == "null")
{
info.code = "null";
}
else
{
info.code = tbCraftProbablyInfo.Rows[i][7].ToString();;
}
return(info);
}
else
{
//throw new Exception("执行getCraftProbably查询到空值");
CraftProbablyInfo info = new CraftProbablyInfo();
info.CraftDID = craftDID;
info.NowYield = "null";
info.TargetYield = "null";
info.UseName = "null";
info.CarNO = "null";
info.BatteryBarCode = "null";
info.DeviceName = "null";
info.PPM = 0;
info.OKCount = 0;
info.OKRate = "null";
info.code = "null";
return(info);
}
}
public CraftProbablyGetResponse Execute(CraftProbablyGetRequest request)
{
CraftProbablyGetResponse probablyGetResponse = new CraftProbablyGetResponse();
CraftProbablyInfo craftProbably = ServiceHelper.LoadService <IProductionService>().GetCraftProbably(request.CraftDID);
if (craftProbably != null)
{
probablyGetResponse.CraftProbably = craftProbably.ToModel();
}
return(probablyGetResponse);
}
private void UpdateCraftProbablyInfo(CraftProbablyInfo info)
{
Database equipDB = dataProvider.EQUIPDataBase;
string sql = string.Format(
@"update craft_probably
set BatteryBarCode = '{1}',
nowYield = {2},
targetYield = {3},
useName = '{4}',
carNO = '{5}'
where craft_did = {0};"
, info.CraftDID, info.BatteryBarCode, info.NowYield, info.TargetYield
, info.UseName, info.CarNO);
equipDB.ExecuteNonQuery(CommandType.Text, sql);
}
public List <CraftProbablyInfo> GetCraftProbablys()
{
DataTable tbCraftProbablyInfo = getCraftProbablys();
List <CraftProbablyInfo> lst = new List <CraftProbablyInfo>();
if (tbCraftProbablyInfo != null && tbCraftProbablyInfo.Rows.Count > 0)
{
CraftProbablyInfo info = new CraftProbablyInfo();
info.CraftDID = int.Parse(tbCraftProbablyInfo.Rows[0][0].ToString());
info.BatteryBarCode = tbCraftProbablyInfo.Rows[0][1].ToString();
info.NowYield = tbCraftProbablyInfo.Rows[0][2].ToString();
info.TargetYield = tbCraftProbablyInfo.Rows[0][3].ToString();
info.UseName = tbCraftProbablyInfo.Rows[0][4].ToString();
info.CarNO = tbCraftProbablyInfo.Rows[0][5].ToString();
lst.Add(info);
}
return(lst);
}
public void SaveCraftDetail(CraftDetailModel model)
{
DataTable tbCrafts = getCraftsByID(model.CraftDID);
if (tbCrafts != null && tbCrafts.Rows.Count > 0)
{
CraftInfo craft = new CraftInfo();
craft.CraftDID = int.Parse(tbCrafts.Rows[0][0].ToString());
craft.CraftNO = tbCrafts.Rows[0][1].ToString();
craft.CraftName = tbCrafts.Rows[0][2].ToString();
CraftProbablyInfo craftProbably = this.GetCraftProbably(model.CraftDID, model.code);
craft.CraftName = model.CraftName;
UpdateCraft(craft);
craftProbably.TargetYield = model.TargetYield;
UpdateCraftProbablyInfo(craftProbably);
}
else
{
throw new Exception("执行getCraftsByID查询为空");
}
}
public static CraftProbablyModel ToModel(this CraftProbablyInfo entity)
{
return(Mapper.Map <CraftProbablyInfo, CraftProbablyModel>(entity));
}
