/// <summary>
/// 料道异常的时候发送短信
/// </summary>
/// <param name="mechineID"></param>
public static void sendMsgWhenLDError(string mechineID, string ldNO)
{
string sqlT3 = "select * from asm_mechine where id=" + mechineID;
DataTable dt3 = DbHelperSQL.Query(sqlT3).Tables[0];
if (dt3.Rows.Count > 0)
{
for (int i = 0; i < dt3.Rows.Count; i++)
{
try
{
string sql21 = "select linkphone from asm_opera where id='" + dt3.Rows[i]["operaID"].ToString() + "'";
string sql22 = "select linkphone from asm_company where id='" + dt3.Rows[i]["companyID"].ToString() + "'";
DataTable d21 = DbHelperSQL.Query(sql21).Tables[0];
DataTable d22 = DbHelperSQL.Query(sql22).Tables[0];
if (d21.Rows.Count > 0 && d21.Rows[0]["linkphone"].ToString() != "")
{
OperUtil.sendMessage4(d21.Rows[0]["linkphone"].ToString(), dt3.Rows[0]["mechineName"].ToString(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Substring(11, 5), ldNO);
}
if (d22.Rows.Count > 0 && d22.Rows[0]["linkphone"].ToString() != "")
{
OperUtil.sendMessage4(d22.Rows[0]["linkphone"].ToString(), dt3.Rows[0]["mechineName"].ToString(), DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss").Substring(11, 5), ldNO);
}
}
catch (Exception ex)
{
OperUtil.Debuglog("cuowu=" + ex.Message, "料道异常短信_.txt");
}
}
}
}
