/// <summary>
/// 更新里程信息按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpdateMileInfo_Click(object sender, EventArgs e)
{
if (waveformMaker.WaveformDataList[0].MileageFix.FixData == null || waveformMaker.WaveformDataList[0].MileageFix.FixData.Count == 0)
{
MessageBox.Show("没有进行里程校正，不需要更新里程！");
return;
}
if (waveformMaker.WaveformDataList[0].InvalidDataList.Count == 0)
{
return;
}
try
{
for (int i = 0; i < waveformMaker.WaveformDataList[0].InvalidDataList.Count; i++)
{
InvalidData data = waveformMaker.WaveformDataList[0].InvalidDataList[i];
float iStartMile = waveformMaker.WaveformDataList[0].MileageFix.CalcPointMileStone(long.Parse(data.sStartPoint));
float iEndMile = waveformMaker.WaveformDataList[0].MileageFix.CalcPointMileStone(long.Parse(data.sEndPoint));
invalidManager.InvalidDataUpdate(idfFilePath, data.sStartPoint,
data.sEndPoint, (iStartMile / 1000f).ToString(), (iEndMile / 1000f).ToString());
}
}
catch (Exception ex)
{
MyLogger.LogError("更新无效数据时失败", ex);
}
MessageBox.Show("更新成功！");
GetInvalidData();
}
public void Adjust_InvalidRawData_RaiseEvent()
{
var data = new InvalidData();
adjuster.OnFoundInvalidData = d => { data = d; };
buildRepositoryFake.Source = "a";
buildRepositoryFake.RawData = "{}";
adjuster.Adjust();
Assert.That(data.Data, Is.EqualTo("{}"));
Assert.That(data.Source, Is.EqualTo("a"));
}
/// <summary>
///idf数据库操作：查询--InvalidData表格
/// </summary>
/// <param name="idfFile"></param>
/// <returns></returns>
public List <InvalidData> InvalidDataList(string idfFile)
{
List <InvalidData> listIDC = new List <InvalidData>();
try
{
using (OleDbConnection sqlconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + idfFile + ";Persist Security Info=True"))
{
string sSql = "select * from InvalidData order by clng(StartPoint)";
OleDbCommand sqlcom = new OleDbCommand(sSql, sqlconn);
sqlconn.Open();
OleDbDataReader oleDBr = sqlcom.ExecuteReader();
int columnNum = oleDBr.FieldCount;
while (oleDBr.Read())
{
InvalidData idc = new InvalidData();
idc.iId = int.Parse(oleDBr.GetValue(0).ToString());
idc.sStartPoint = oleDBr.GetValue(1).ToString();
idc.sEndPoint = oleDBr.GetValue(2).ToString();
idc.sStartMile = oleDBr.GetValue(3).ToString();
idc.sEndMile = oleDBr.GetValue(4).ToString();
idc.iType = int.Parse(oleDBr.GetValue(5).ToString());
idc.sMemoText = oleDBr.GetValue(6).ToString();
idc.iIsShow = int.Parse(oleDBr.GetValue(7).ToString());
if (columnNum == 9)
{
idc.ChannelType = oleDBr.GetValue(8).ToString();
}
else
{
idc.ChannelType = "";
}
listIDC.Add(idc);
}
oleDBr.Close();
sqlconn.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("无效区段读取异常:" + ex.Message);
}
return(listIDC);
}
private void Dtm_DataRequested(DataTransferManager sender, DataRequestedEventArgs args)
{
if (dataType == DataType.Uri)
{
try
{
args.Request.Data.Properties.Title = "Native Share URI";
args.Request.Data.SetWebLink(new Uri(data));
}
catch (UriFormatException)
{
InvalidData?.Invoke(this, null);
}
}
else if (dataType == DataType.Text)
{
args.Request.Data.Properties.Title = "Native Share Text";
args.Request.Data.SetText(data);
}
}
private void OnClientDataRecevied(object sender, Data e)
{
var c = (Client)sender;
Console.WriteLine(c.User.UserName + "@" + c.Id + ": " + e.Command.ToString() + ": " + e.Content);
switch (e.Command)
{
case Command.Status:
c.Send(new Data(Command.Message, "Client #" + c.Id + ", Logged as" + c.User.UserName + ", Can Send: " + c.User.CanSend + ", Can Code: " + c.User.CanCode, "root"));
return;
case Command.SendMsg:
if (c.User.CanSend)
{
if (c.User.CanCode && e.Content.StartsWith("sh: "))
{
RunCode(e.Content.Substring(4), c);
}
else
{
foreach (var client in Clients)
{
client.Send(new Data(Command.Message, e.Content, c.User.UserName));
}
}
}
else
{
c.Send(new Data(Command.Message, "Dear " + c.User.UserName + ", You can't send any message because you are limited.", "root"));
foreach (var client in Clients.Where(a => a.User.CanCode))
{
client.Send(new Data(Command.Message, c.User.UserName + " says:\r\n\t" + e.Content, "Limited users"));
}
}
return;
case Command.Disconnect:
c.Disconnect();
return;
case Command.Login:
if (c.User.UserName == "anonymous")
{
foreach (var u in Users)
{
if (e.Content == u.UserName + ":" + u.Password)
{
c.User = u;
SendToAllAsRoot("#" + c.Id + " logged in as " + u.UserName);
return;
}
}
c.Send(new Data(Command.Message, "Bad User Name/Password", "root"));
SendToAllAsRoot("An attempt to login from #" + c.Id);
}
else
{
c.Send(new Data(Command.Message, "You've logged in already.", "root"));
}
return;
case Command.Message:
foreach (var cl in Clients.Where(a => a.User.UserName == Users[1].UserName))
{
cl.Send(new Data(Command.Message, "Message: " + e.Content, "root - Msg from Client #" + c.Id));
}
break;
default:
InvalidData?.Invoke(c, e);
return;
}
}
public static void Main(string[] args)
{
InvalidData invalidDataTest = new InvalidData();
invalidDataTest.runAll();
}
/// <summary>
/// Fires the InvalidData event.
/// </summary>
/// <param name="propertyName">Name of the property.</param>
/// <param name="message">The message.</param>
protected void FireWarning(string propertyName, string message)
{
// TODO - Add to log
InvalidData?.Invoke(this, new InvalidDataEventArgs(propertyName, message));
}
public ActionResult ImportMachine(int type)
{
var result = new ImportUploadResult()
{
IsSuccess = false
};
var invalidlist = new List <InvalidData>();
StringBuilder strbuild = new StringBuilder();
string FileName;
string savePath;
HttpPostedFileBase file = Request.Files["file"];
if (file == null || file.ContentLength <= 0)
{
result.Message = "please choose file";
return(Content(JsonHelper.JsonSerializer(result)));
}
else
{
string fileName = Path.GetFileName(file.FileName);
int filesize = file.ContentLength; //获取上传文件的大小单位为字节byte
string fileEx = Path.GetExtension(fileName); //获取上传文件的扩展名
string NoFileName = Path.GetFileNameWithoutExtension(fileName); //获取无扩展名的文件名
int Maxsize = 4000 * 1024; //定义上传文件的最大空间大小为4M
string FileType = ".xls,.xlsx"; //定义上传文件的类型字符串
FileName = NoFileName + fileEx;
if (!FileType.Contains(fileEx))
{
result.Message = "please upload .xls and .xlsx";
return(Content(JsonHelper.JsonSerializer(result)));
}
if (filesize >= Maxsize)
{
result.Message = string.Format("file size can't big than {0}", Maxsize);
return(Content(JsonHelper.JsonSerializer(result)));
}
string path = Server.MapPath("~/App_Data/uploads");
savePath = Path.Combine(path, FileName);
file.SaveAs(savePath);
}
string strConn;
strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + savePath + ";Extended Properties=Excel 12.0;";
using (OleDbConnection conn = new OleDbConnection(strConn))
{
conn.Open();
OleDbDataAdapter myCommand = new OleDbDataAdapter("select * from [Sheet1$]", strConn);
DataSet myDataSet = new DataSet();
try
{
myCommand.Fill(myDataSet, "ExcelInfo");
}
catch (Exception ex)
{
result.Message = ex.Message;
return(Content(JsonHelper.JsonSerializer(result)));
}
DataTable table = myDataSet.Tables["ExcelInfo"].DefaultView.ToTable();
try
{
for (int i = 0; i < table.Rows.Count; i++)
{
var datevalid1 = false;
var datevalid2 = false;
var invalid = new InvalidData();
if (!string.IsNullOrEmpty(table.Rows[i][6].ToString()))
{
datevalid1 = DataConvertHelper.IsDateTime(table.Rows[i][6].ToString());
if (!datevalid1)
{
invalid.Key = table.Rows[i][2].ToString();
invalid.Value1 = table.Rows[i][6].ToString();
}
}
if (!string.IsNullOrEmpty(table.Rows[i][12].ToString()))
{
datevalid2 = DataConvertHelper.IsDateTime(table.Rows[i][12].ToString());
if (!datevalid2)
{
invalid.Key = table.Rows[i][2].ToString();
invalid.Value2 = table.Rows[i][12].ToString();
}
}
if (!datevalid1 && !datevalid2)
{
invalidlist.Add(invalid);
continue;
}
var model = new MaToolModel();
model.BMClassification = type;
model.BMEquipmentName = table.Rows[i][0].ToString();
model.BMEquipmentNo = table.Rows[i][1].ToString();
model.BMFixtureNo = table.Rows[i][2].ToString();
model.BMType = table.Rows[i][3].ToString();
model.BMSerialNumber = table.Rows[i][4].ToString();
model.BMQuantity = DataConvertHelper.ToInt(table.Rows[i][5].ToString(), 0);
model.BMManufacturedDate = table.Rows[i][6].ToString();
model.BMPower = table.Rows[i][7].ToString();
model.BMOutlineDimension = table.Rows[i][8].ToString();
model.BMAbility = table.Rows[i][9].ToString();
model.BMNeedPressureAir = DataConvertHelper.GetYesOrNoValue(table.Rows[i][10].ToString());
model.BMNeedCoolingWater = DataConvertHelper.GetYesOrNoValue(table.Rows[i][11].ToString());
model.BMIncomingDate = table.Rows[i][12].ToString();
model.BMRemarks = table.Rows[i][13].ToString();
var inserResult = MaterialBusiness.SaveMaTool(model, LoginUser);
//if (type != 4)
//{
// MachineTool(type, table, i);
//}
//else {
// MaterialTool(type, table, i);
//}
}
result.invalidData = invalidlist;
result.IsSuccess = true;
}
catch (Exception ex)
{
result.Message = ex.Message;
return(Content(JsonHelper.JsonSerializer(result)));
}
conn.Close();
}
return(Content(JsonHelper.JsonSerializer(result)));
}
