public CDataResult <AccountListDto> ChangeStatus(AccountInput input)
{
var result = new CDataResult <AccountListDto>()
{
IsSuccess = false,
ErrorMessage = null,
Data = null
};
var account = this._accountRepository.Get(input.Id);
if (account == null)
{
result.IsSuccess = false;
result.ErrorMessage = "用户启用失败！";
}
else
{
account.IsActivated = input.IsActivated;
account.Id = input.Id;
}
var updateAccount = this._accountRepository.Update(account);
if (updateAccount == null)
{
result.IsSuccess = false;
result.ErrorMessage = "用户启用失败！";
}
else
{
result.IsSuccess = true;
result.Data = updateAccount.MapTo <AccountListDto>();
}
return(result);
}
public CDataResult <CWeatherDto> UpdateWeather(CWeatherInput input)
{
var result = new CDataResult <CWeatherDto>()
{
IsSuccess = false,
ErrorMessage = null,
Data = null
};
var weather = this._weatherRepository.Get(input.Id);
if (weather == null)
{
result.IsSuccess = false;
}
weather.Content = input.Content;
weather.Title = input.Title;
weather.Type = input.Type.Value;
var updatedWeather = this._weatherRepository.Update(weather);
if (updatedWeather == null)
{
result.IsSuccess = false;
}
else
{
result.IsSuccess = true;
result.Data = updatedWeather.MapTo <CWeatherDto>();
}
return(result);
}
public void GetStatistics(IList <CData> list, CDataResult res)
{
//计算平均值
res.WG_AVG = list.Average(c => c.Wg);
res.CIRC_AVG = list.Average(c => c.CIRC);
res.LEN_AVG = list.Average(c => c.Len);
res.PD_AVG = list.Average(c => c.Pd);
res.TV_AVG = list.Average(c => c.TV);
//计算标准偏差
IList <double> wgData = InitDoubleData(list, "WG");
res.WG_STDV = Convert.ToDecimal(ComputSD(wgData));
IList <double> lenData = InitDoubleData(list, "LEN");
res.LEN_STDV = Convert.ToDecimal(ComputSD(lenData));
IList <double> pdData = InitDoubleData(list, "PD");
res.PD_STDV = Convert.ToDecimal(ComputSD(wgData));
IList <double> circData = InitDoubleData(list, "CIRC");
res.CIRC_STDV = Convert.ToDecimal(ComputSD(lenData));
IList <double> tvData = InitDoubleData(list, "TV");
res.TV_STDV = Convert.ToDecimal(ComputSD(lenData));
}
public CDataResult <int> Update(CPictureInput input)
{
var result = new CDataResult <int>()
{
IsSuccess = false,
ErrorMessage = null,
Data = 0
};
var picture = this._pictureRepository.Get(input.Id);
if (picture == null)
{
result.IsSuccess = false;
}
else
{
picture.Title = input.Title;
picture.ImgUrl = input.ImgUrl;
picture.DisplayIndex = input.DisplayIndex;
picture.Id = input.Id;
}
var updatePicture = this._pictureRepository.Update(picture);
if (updatePicture == null)
{
result.IsSuccess = false;
}
else
{
result.IsSuccess = true;
result.Data = 1;
}
return(result);
}
public CDataResult <AccountListDto> Update(AccountInput input)
{
var result = new CDataResult <AccountListDto>()
{
IsSuccess = false,
ErrorMessage = null,
Data = null
};
var account = this._accountRepository.Get(input.Id);
if (account == null)
{
result.IsSuccess = false;
}
else
{
account.UserName = input.UserName;
account.Account = input.Account;
account.IMEICode = input.IMEICode;
account.Password = input.Password;
account.Equipments = input.Equipments;
account.IsActivated = input.IsActivated;
account.Id = input.Id;
}
var updateNotice = this._accountRepository.Update(account);
if (updateNotice == null)
{
result.IsSuccess = false;
}
else
{
result.IsSuccess = true;
result.Data = updateNotice.MapTo <AccountListDto>();
}
return(result);
}
public CDataResult <CTideDto> UpdateTide(CTideInput input)
{
var result = new CDataResult <CTideDto>()
{
IsSuccess = false,
ErrorMessage = null,
Data = null
};
var Tide = this._TideRepository.Get(input.Id);
if (Tide == null)
{
result.IsSuccess = false;
}
Tide.PublicDate = input.PublicDate;
Tide.FloodTime1 = input.FloodTime1;
Tide.FloodHigh1 = input.FloodHigh1;
Tide.FloodTime2 = input.FloodTime2;
Tide.FloodHigh2 = input.FloodHigh2;
Tide.FloodTime3 = input.FloodTime3;
Tide.FloodHigh3 = input.FloodHigh3;
Tide.FloodTime4 = input.FloodTime4;
Tide.FloodHigh4 = input.FloodHigh4;
var updatedTide = this._TideRepository.Update(Tide);
if (updatedTide == null)
{
result.IsSuccess = false;
}
else
{
result.IsSuccess = true;
result.Data = updatedTide.MapTo <CTideDto>();
}
return(result);
}
private String SaveC2StatisticsData(CDataResult res)
{
String message = "";
String sql = String.Format(@"INSERT INTO [SPC].[C2RESULTDATA]
([CHECKTIME]
,[WO]
,[MACHINE]
,[ORDERNUM]
,[PD_AVG]
,[PD_STDV]
,[PD_CPK]
,[CIRC_AVG]
,[CIRC_STDV]
,[CIRC_CPK]
,[WG_AVG]
,[WG_STDV]
,[WG_CPK]
,[LEN_AVG]
,[LEN_STDV]
,[LEN_CPK]
,[TV_AVG]
,[TV_STDV]
,[TV_CPK])
VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}')"
, res.checkTime, res.wo, res.machine, res.ordernum, res.PD_AVG, res.PD_STDV, res.PD_CPK, res.CIRC_AVG, res.CIRC_STDV
, res.CIRC_CPK, res.WG_AVG, res.WG_STDV, res.WG_CPK, res.LEN_AVG, res.LEN_STDV, res.LEN_CPK, res.TV_AVG, res.TV_STDV, res.TV_CPK);
try
{
dsSql.ExecuteNonQuery(sql, QcAnalysis.ConnectionState.KeepOpen);
}
catch (Exception ex)
{
message = ex.Message;
}
return(message);
}
public CDataResult <NoticeListDto> UpdateNotice(NoticeInput input)
{
var result = new CDataResult <NoticeListDto>()
{
IsSuccess = false,
ErrorMessage = null,
Data = null
};
var notice = this._noticeRepository.Get(input.Id);
if (notice == null)
{
result.IsSuccess = false;
}
else
{
notice.Title = input.Title;
notice.NewsAuthor = input.NewsAuthor;
notice.DisplayIndex = input.DisplayIndex;
notice.NewsContent = input.NewsContent;
notice.Id = input.Id;
}
var updateNotice = this._noticeRepository.Update(notice);
if (updateNotice == null)
{
result.IsSuccess = false;
}
else
{
result.IsSuccess = true;
result.Data = updateNotice.MapTo <NoticeListDto>();
}
return(result);
}
public CDataResult <CompanyListDto> UpdateCompany(CompanyInput input)
{
var result = new CDataResult <CompanyListDto>()
{
IsSuccess = false,
ErrorMessage = null,
Data = null
};
var company = this._companyRepository.Get(input.Id);
if (company == null)
{
result.IsSuccess = false;
}
else
{
company.CompanyName = input.CompanyName;
company.CompanyAddress = input.CompanyAddress;
company.Contactor = input.Contactor;
company.Mobile = input.Mobile;
company.Id = input.Id;
}
var updateNotice = this._companyRepository.Update(company);
if (updateNotice == null)
{
result.IsSuccess = false;
}
else
{
result.IsSuccess = true;
result.Data = updateNotice.MapTo <CompanyListDto>();
}
return(result);
}
/// <summary>
/// C2样本数据计算
/// </summary>
/// <returns></returns>
public string C2DataStatistics()
{
String message = "";
LogStr.Clear();
DateTime startTime;
DateTime endTime;
String wo;
String machine;
int orderNo;
String mat_Ctrl;
double UCL;
double LCL;
DataSet dsC2Data = GetC2DataStatTime();
CDataResult res = new CDataResult();
if (dsC2Data.Tables[0].Rows.Count > 0 || dsC2Data.Tables[1].Rows.Count > 0 || dsC2Data.Tables[2].Rows.Count > 0)
{
for (int i = 0; i < dsC2Data.Tables.Count; i++)
{
startTime = Convert.ToDateTime(dsC2Data.Tables[i].Rows[0]["CHECKTIME"]);
wo = dsC2Data.Tables[i].Rows[0]["WO"].ToString();
machine = dsC2Data.Tables[i].Rows[0]["MACHINE"].ToString();
orderNo = Convert.ToInt32(dsC2Data.Tables[i].Rows[0]["ORDERNUM"]);
DataSet dsEndTime = GetC2DataEndTime(startTime, machine);
if (dsEndTime.Tables[0].Rows.Count > 0)
{
endTime = Convert.ToDateTime(dsEndTime.Tables[0].Rows[0]["ROWTIME"]);
DataSet ds = GetC2DataFromMes(startTime, endTime, machine);
if (ds.Tables[0].Rows.Count > 19)
{
IList <CData> list = ConvetToObjList(ds.Tables[0]);
//计算平均值
res.WG_AVG = list.Average(c => c.Wg);
res.CIRC_AVG = list.Average(c => c.CIRC);
res.LEN_AVG = list.Average(c => c.Len);
res.PD_AVG = list.Average(c => c.Pd);
res.TV_AVG = list.Average(c => c.TV);
//计算标准偏差
IList <double> wgData = mu.InitDoubleData(list, "WG");
res.WG_STDV = Convert.ToDecimal(mu.ComputSD(wgData));
IList <double> lenData = mu.InitDoubleData(list, "LEN");
res.LEN_STDV = Convert.ToDecimal(mu.ComputSD(lenData));
IList <double> pdData = mu.InitDoubleData(list, "PD");
res.PD_STDV = Convert.ToDecimal(mu.ComputSD(pdData));
IList <double> circData = mu.InitDoubleData(list, "CIRC");
res.CIRC_STDV = Convert.ToDecimal(mu.ComputSD(circData));
IList <double> tvData = mu.InitDoubleData(list, "TV");
res.TV_STDV = Convert.ToDecimal(mu.ComputSD(tvData));
//其他结果值
mat_Ctrl = list[list.Count - 1].mat_Ctrl;
res.checkTime = list[list.Count - 1].testdate;
res.wo = list[list.Count - 1].Wo;
res.machine = machine;
if (wo.Equals(res.wo))
{
res.ordernum = orderNo + 1;
}
else
{
res.ordernum = 1;
}
//取标准 计算CPK
DataSet dsStandard = GetStandard(machine, mat_Ctrl);
if (dsStandard.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dsStandard.Tables[0].Rows)
{
UCL = Convert.ToDouble(dr["LCL"]);
LCL = Convert.ToDouble(dr["UCL"]);
switch (dr["TEST"].ToString())
{
case "WG":
res.WG_CPK = Convert.ToDecimal(mu.ComputCPK(wgData, UCL, Convert.ToDouble(res.WG_AVG), LCL));
break;
case "LEN_":
res.LEN_CPK = Convert.ToDecimal(mu.ComputCPK(lenData, UCL, Convert.ToDouble(res.LEN_AVG), LCL));
break;
case "CIRC":
res.CIRC_CPK = Convert.ToDecimal(mu.ComputCPK(circData, UCL, Convert.ToDouble(res.CIRC_AVG), LCL));
break;
case "PD":
res.PD_CPK = Convert.ToDecimal(mu.ComputCPK(pdData, UCL, Convert.ToDouble(res.PD_AVG), LCL));
break;
case "TV":
res.TV_CPK = Convert.ToDecimal(mu.ComputCPK(tvData, UCL, Convert.ToDouble(res.TV_AVG), LCL));
break;
default:
break;
}
}
}
dsSql.BeginTransaction();
message = SaveC2StatisticsData(res);
dsSql.CommitTransaction();
}
}
//else
//{
// res.checkTime = endTime;
// res.machine = machine;
// res.wo = wo;
//}
}
}
if (!String.IsNullOrEmpty(message))
{
string tempStr = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss ") + "C2" + message + "\r\n";
LogStr.Append(tempStr);
String savePath = "D:\\GetC2RowNum_Log";
String fileName = DateTime.Now.ToString("yyyy-MM-dd") + ".log";
String fileMsg = LogStr.ToString() + "\r\n";
LogHelper.SaveMsgToFile(savePath, fileName, fileMsg);
}
return(message);
}
