/// <summary>
/// 亮度测试更新
/// </summary>
/// <param name="piLD"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public int updateProjectorInformation_MainTable_LDZ2Dal(ProjectorInformation_LD piLD, string SQLCommand)
{
string sql = SQLhelp.GetSQLCommand(SQLCommand);
SqlParameter[] pms = new SqlParameter[]
{
new SqlParameter("@FuselageCode", SqlDbType.VarChar, 80)
{
Value = piLD.FuselageCode
},
new SqlParameter("@IlluminationValue", SqlDbType.VarChar, 50)
{
Value = piLD.IlluminationValue
},
new SqlParameter("@WiredMAC", SqlDbType.VarChar, 50)
{
Value = piLD.WiredMAC
},
new SqlParameter("@wirelessMAC", SqlDbType.VarChar, 50)
{
Value = piLD.wirelessMAC
},
};
return(SQLhelp.ExecuteNonQuery(sql, CommandType.Text, pms));
}
public bool updateProjectorInformation_MainTable_LDZ2Bll(ProjectorInformation_LD piLD, string SQLCommand)
{
if (pmtd.updateProjectorInformation_MainTable_LDZ2Dal(piLD, SQLCommand) > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 亮度测试插入
/// </summary>
/// <param name="piLD"></param>
/// <param name="SQLCommand"></param>
/// <returns></returns>
public bool insertProjectorInformation_MainTable_LDBll(ProjectorInformation_LD piLD, string SQLCommand)
{
if (pmtd.insertProjectorInformation_MainTable_LDDal(piLD, SQLCommand) > 0)
{
return(true);
}
else
{
return(false);
}
}
void ExcelInput(string fileName, bool bl)
{
try
{
DataTable dt = ExcelHelperForCs.ImportFromExcel(fileName, "Sheet1", 0);
List <ProjectorInformation_LD> list = new List <ProjectorInformation_LD>();
if (bl)
{
foreach (DataRow item in dt.Rows)
{
ProjectorInformation_LD ld = new ProjectorInformation_LD()
{
FuselageCode = item[4].ToString(),
IlluminationValue = item[5].ToString(),
LuminanceTestTime = Convert.ToDateTime(item[1].ToString()),
WiredMAC = item[2].ToString(),
wirelessMAC = item[3].ToString(),
ZhiDan = ZhiDan
};
list.Add(ld);
}
int i = 0;
foreach (ProjectorInformation_LD item in list)
{
i++;
if (pmtb.updateProjectorInformation_MainTable_LDBll(item, "updateProjectorInformation_MainTable_LD"))
{
my_context.Post(SetTextBox, "照度值写入成功！***" + " 机身码:" + item.FuselageCode + " ***时间：" + DateTime.Now.ToString() + "\r\n" + "\r\n");
}
else
{
my_context.Post(SetTextBox2, "照度值写入失败！***" + " 机身码:" + item.FuselageCode + " ***时间：" + DateTime.Now.ToString() + "\r\n" + "\r\n");
}
my_context.Post(SetLable, i.ToString() + "/" + list.Count.ToString());
}
}
else
{
foreach (DataRow item in dt.Rows)
{
ProjectorInformation_LD ld = new ProjectorInformation_LD()
{
WiredMAC = item[1].ToString(),
wirelessMAC = item[2].ToString(),
FuselageCode = item[3].ToString(),
IlluminationValue = item[4].ToString(),
ZhiDan = ZhiDan
};
list.Add(ld);
}
int i = 0;
foreach (ProjectorInformation_LD item in list)
{
i++;
if (pmtb.updateProjectorInformation_MainTable_LDZ2Bll(item, "updateProjectorInformation_MainTableLDZ2"))
{
my_context.Post(SetTextBox, "照度值写入成功！***" + " 机身码:" + item.FuselageCode + " ***时间：" + DateTime.Now.ToString() + "\r\n" + "\r\n");
}
else
{
my_context.Post(SetTextBox2, "照度值写入失败！***" + " 机身码:" + item.FuselageCode + " ***时间：" + DateTime.Now.ToString() + "\r\n" + "\r\n");
}
my_context.Post(SetLable, i.ToString() + "/" + list.Count.ToString());
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
