/// <summary>
/// 查找重复VCU信息
/// </summary>
/// <param name="item"></param>
public static int RepeatVCUconfig(T_VCUConfig item)
{
try
{
return(_sqlSugar.Queryable <T_VCUConfig>().Where(t => t.mtoc == item.mtoc).Count());
}
catch (Exception ex)
{
Log.Error($"查询记录失败！\r\n mtoc={item.mtoc}", ex);
}
return(0);
}
/// <summary>
/// 删除VCU配置信息
/// </summary>
/// <param name="item"></param>
public async static Task <int> DeleteVCUconfig(T_VCUConfig item)
{
try
{
return(await _sqlSugar.Deleteable <T_VCUConfig>().Where(t => t.id == item.id).ExecuteCommandAsync());
}
catch (Exception ex)
{
Log.Error($"删除记录失败！\r\n id={item.id}", ex);
}
return(0);
}
/// <summary>
/// 保存VCU相关信息
/// </summary>
/// <param name="item"></param>
public async static Task <int> SaveVCUconfig(T_VCUConfig item)
{
try
{
return(await _sqlSugar.Insertable(item).ExecuteCommandAsync());
}
catch (Exception ex)
{
string jsonstr = Newtonsoft.Json.JsonConvert.SerializeObject(item);
Log.Error($"添加记录失败！\r\n {jsonstr}", ex);
}
return(0);
}
/// <summary>
/// 单机表格显示
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvStandard_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.RowIndex >= 0)
{
//VCUItem = new VCUconfig();
//VCUItem.Id = int.Parse(this.dgvStandard.Rows[e.RowIndex].Cells[0].Value + "");
//VCUItem.MTOC = this.dgvStandard.Rows[e.RowIndex].Cells[1].Value + "";
//VCUItem.DriverName = this.dgvStandard.Rows[e.RowIndex].Cells[2].Value + "";
//VCUItem.DriverPath = this.dgvStandard.Rows[e.RowIndex].Cells[3].Value + "";
//VCUItem.BinName = this.dgvStandard.Rows[e.RowIndex].Cells[4].Value + "";
//VCUItem.BinPath = this.dgvStandard.Rows[e.RowIndex].Cells[5].Value + "";
//VCUItem.CalName = this.dgvStandard.Rows[e.RowIndex].Cells[6].Value + "";
//VCUItem.CalPath = this.dgvStandard.Rows[e.RowIndex].Cells[7].Value + "";
//VCUItem.SoftWareVersion = this.dgvStandard.Rows[e.RowIndex].Cells[8].Value + "";
//VCUItem.ElementNum = this.dgvStandard.Rows[e.RowIndex].Cells[9].Value + "";
//VCUItem.HardWareCode = this.dgvStandard.Rows[e.RowIndex].Cells[10].Value + "";
//VCUItem.HW = this.dgvStandard.Rows[e.RowIndex].Cells[11].Value + "";
//VCUItem.SW = this.dgvStandard.Rows[e.RowIndex].Cells[12].Value + "";
//VCUItem.Sign = this.dgvStandard.Rows[e.RowIndex].Cells[13].Value + "";
t_VCUConfig = new T_VCUConfig();
t_VCUConfig.id = int.Parse(this.dgvStandard.Rows[e.RowIndex].Cells[0].Value + "");
t_VCUConfig.mtoc = this.dgvStandard.Rows[e.RowIndex].Cells[1].Value + "";
t_VCUConfig.drivername = this.dgvStandard.Rows[e.RowIndex].Cells[2].Value + "";
t_VCUConfig.driverpath = this.dgvStandard.Rows[e.RowIndex].Cells[3].Value + "";
t_VCUConfig.binname = this.dgvStandard.Rows[e.RowIndex].Cells[4].Value + "";
t_VCUConfig.binpath = this.dgvStandard.Rows[e.RowIndex].Cells[5].Value + "";
t_VCUConfig.calname = this.dgvStandard.Rows[e.RowIndex].Cells[6].Value + "";
t_VCUConfig.calpath = this.dgvStandard.Rows[e.RowIndex].Cells[7].Value + "";
t_VCUConfig.softwareversion = this.dgvStandard.Rows[e.RowIndex].Cells[8].Value + "";
t_VCUConfig.elementNum = this.dgvStandard.Rows[e.RowIndex].Cells[9].Value + "";
t_VCUConfig.hardwarecode = this.dgvStandard.Rows[e.RowIndex].Cells[10].Value + "";
t_VCUConfig.HW = this.dgvStandard.Rows[e.RowIndex].Cells[11].Value + "";
t_VCUConfig.SW = this.dgvStandard.Rows[e.RowIndex].Cells[12].Value + "";
t_VCUConfig.sign = this.dgvStandard.Rows[e.RowIndex].Cells[13].Value + "";
}
}
catch (Exception)
{
throw;
}
}
public AddConfig(T_VCUConfig VCUItem)
{
InitializeComponent();
this.t_VCUConfig = VCUItem;
}
public AddConfig()
{
InitializeComponent();
t_VCUConfig = null;
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void button2_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(this.tbMTOC.Text.Trim()) ||
string.IsNullOrEmpty(this.tbHardwareCode.Text.Trim()) ||
string.IsNullOrEmpty(this.tbsoftwareVersion.Text.Trim()) ||
string.IsNullOrEmpty(this.tbHW.Text.Trim()) ||
string.IsNullOrEmpty(this.tbElementCode.Text.Trim()) ||
string.IsNullOrEmpty(this.tbSW.Text.Trim()) ||
string.IsNullOrEmpty(this.tbDriver.Text.Trim()) ||
string.IsNullOrEmpty(this.tbWrite.Text.Trim()) ||
string.IsNullOrEmpty(this.tbCal.Text.Trim()))
{
MessageBox.Show("请填写全部信息", "提示");
return;
}
string localConnectionString = ConfigurationManager.ConnectionStrings["localCnnStr"] + "";
Configer Conbll = new Configer(localConnectionString);
if (t_VCUConfig == null)
{
if (this.btDriver.Text != "已导入" || this.btWrite.Text != "已导入" || this.btCal.Text != "已导入")
{
MessageBox.Show("请导入文件", "提示");
return;
}
// VCUconfig item = new VCUconfig();
// item.MTOC = this.tbMTOC.Text.ToUpper();
// item.HardWareCode = this.tbHardwareCode.Text.ToUpper();
// item.HW = this.tbHW.Text;
// item.SoftWareVersion = this.tbsoftwareVersion.Text;
// item.SW = this.tbSW.Text; ;
// item.ElementNum = this.tbElementCode.Text;
// item.Sign = this.tbSign.Text;
// item.DriverName = this.tbDriver.Text;
// item.BinName = this.tbWrite.Text;
// item.CalName = this.tbCal.Text;
// item.DriverPath = System.Configuration.ConfigurationManager.AppSettings["driverPos"];
// //item.DriverPath = System.Configuration.ConfigurationSettings.AppSettings["driver"];
// item.BinPath = System.Configuration.ConfigurationManager.AppSettings["writePos"];
//// item.BinPath = System.Configuration.ConfigurationSettings.AppSettings["bin"];
// item.CalPath = System.Configuration.ConfigurationManager.AppSettings["calPos"];
//int isRep = Conbll.RepeatVCUconfig(item);
// if (isRep > 0)
// {
// MessageBox.Show("已经拥有该车型的数据了，请重新命名", "提示");
// return;
// }
// else
// {
// Conbll.SaveVCUconfig(item);
// MessageBox.Show("新增成功");
// }
T_VCUConfig item = new T_VCUConfig();
item.mtoc = this.tbMTOC.Text.ToUpper();
item.hardwarecode = this.tbHardwareCode.Text.ToUpper();
item.HW = this.tbHW.Text;
item.softwareversion = this.tbsoftwareVersion.Text;
item.SW = this.tbSW.Text;;
item.elementNum = this.tbElementCode.Text;
item.sign = this.tbSign.Text;
item.drivername = this.tbDriver.Text;
item.binname = this.tbWrite.Text;
item.calname = this.tbCal.Text;
item.driverpath = System.Configuration.ConfigurationManager.AppSettings["driverPos"];
item.binpath = System.Configuration.ConfigurationManager.AppSettings["writePos"];
item.calpath = System.Configuration.ConfigurationManager.AppSettings["calPos"];
int tmpK = Comm.SqlComm.RepeatVCUconfig(item);
if (tmpK > 0)
{
MessageBox.Show("已经拥有该车型的数据了，请重新命名", "提示");
return;
}
int tmpAddCount = await Comm.SqlComm.SaveVCUconfig(item);
string msg = tmpAddCount > 0 ? "新增成功" : "新增失败";
MessageBox.Show(msg);
}
else
{
//VCUconfig item = new VCUconfig();
//item.Id = VCUItem.Id;
//item.MTOC = this.tbMTOC.Text.ToUpper();
//item.HardWareCode = this.tbHardwareCode.Text.ToUpper();
//item.HW = this.tbHW.Text;
//item.SoftWareVersion = this.tbsoftwareVersion.Text;
//item.SW = this.tbSW.Text; ;
//item.ElementNum = this.tbElementCode.Text;
//item.Sign = this.tbSign.Text;
//item.DriverName = this.tbDriver.Text;
//item.BinName = this.tbWrite.Text;
//item.CalName = this.tbCal.Text;
//item.DriverPath = System.Configuration.ConfigurationManager.AppSettings["driverPos"];
////item.DriverPath = System.Configuration.ConfigurationSettings.AppSettings["driver"];
//item.BinPath = System.Configuration.ConfigurationManager.AppSettings["writePos"];
//// item.BinPath = System.Configuration.ConfigurationSettings.AppSettings["bin"];
//item.CalPath = System.Configuration.ConfigurationManager.AppSettings["calPos"];
//Conbll.UpdateVCUconfig(item);
//MessageBox.Show("修改成功");
t_VCUConfig.mtoc = this.tbMTOC.Text.ToUpper();
t_VCUConfig.hardwarecode = this.tbHardwareCode.Text.ToUpper();
t_VCUConfig.HW = this.tbHW.Text;
t_VCUConfig.softwareversion = this.tbsoftwareVersion.Text;
t_VCUConfig.SW = this.tbSW.Text;;
t_VCUConfig.elementNum = this.tbElementCode.Text;
t_VCUConfig.sign = this.tbSign.Text;
t_VCUConfig.drivername = this.tbDriver.Text;
t_VCUConfig.binname = this.tbWrite.Text;
t_VCUConfig.calname = this.tbCal.Text;
t_VCUConfig.driverpath = System.Configuration.ConfigurationManager.AppSettings["driverPos"];
t_VCUConfig.binpath = System.Configuration.ConfigurationManager.AppSettings["writePos"];
t_VCUConfig.calpath = System.Configuration.ConfigurationManager.AppSettings["calPos"];
int tmpK = await Comm.SqlComm.UpdateVCUconfig(t_VCUConfig);
string msg = tmpK > 0 ? "修改成功" : "修改失败";
MessageBox.Show(msg);
}
this.Dispose();
this.Close();
}
catch (Exception)
{
throw;
}
}
