public static void UpStaAndTime()
{
WebService service = new WebService();//新建webservice对象
EquStatus Equstatus = service.GetPage();
service.ClientTime = Convert.ToDecimal(Equstatus.sTM); //客户端上传的时长
//decimal ClientTime = Convert.ToDecimal(Equstatus.sTM);
service.EquNum = Equstatus.sNU; //光源编号
//string EquNum = Equstatus.sNU;
//string sMS = Equstatus.sMS;//机器状态
service.sMS = Equstatus.sMS;
//string sERR = Equstatus.sERR;//光源错误代码
service.sERR = Equstatus.sERR;
RetValue retValues = new RetValue();//LeftTime Operating ServerTime Status
if (!string.IsNullOrWhiteSpace(service.EquNum) && (service.EquNum != "0"))
{
if (DBHelper.IsLocked(service.EquNum))
{
DBHelper.Add(Equstatus);
retValues.Operating = "Lock";
retValues.LeftTime = Convert.ToDecimal(service.ClientTime);
retValues.Status = "Success";
retValues.ServerTime = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss");
service.GetJson(retValues);
return;
}
if (DBHelper.IsEuqNum(service.EquNum))
{
DataSet ds = DBHelper.GetEquInfo(service.EquNum); //获取该光源相应信息
service.IsDelay = ds.Tables[0].Rows[0]["IsDelay"].ToString(); //充值后的延时操作
service.IsSend = ds.Tables[0].Rows[0]["IsSend"].ToString(); //是否已发送短信
service.EquID = ds.Tables[0].Rows[0]["EquID"].ToString(); //光源ID
service.Number = ds.Tables[0].Rows[0]["Number"].ToString(); //厅号
service.ClientID = ds.Tables[0].Rows[0]["ClientID"].ToString(); //客户ID
service.ClientName = ds.Tables[0].Rows[0]["ClientName"].ToString(); //客户名
service.ClientPhone = ds.Tables[0].Rows[0]["Phone"].ToString(); //客户手机号码
service.Agent = ds.Tables[0].Rows[0]["agent"].ToString(); //代理商手机号码
service.Engineer = ds.Tables[0].Rows[0]["engineer"].ToString(); //工程师手机号码
service.Seller = ds.Tables[0].Rows[0]["seller"].ToString(); //销售人员手机号码
service.ReMaTime = Convert.ToDecimal(ds.Tables[0].Rows[0]["RemainTime"].ToString()); //数据库内该光源总剩余时长
service.ReChargeTime = Convert.ToDecimal(ds.Tables[0].Rows[0]["Precharge"].ToString()); //要充值的时长
service.IsReCharge = ds.Tables[0].Rows[0]["IsPre"].ToString(); //是否需要充值
if (service.sERR != "00" && service.sERR != "0" && !string.IsNullOrEmpty(service.sERR))
{
service.ProDesc = "";
switch (service.sERR)
{
case "01":
service.ProDesc = "温度传感器未连接";
break;
case "02":
service.ProDesc = "设备温度异常";
break;
case "03":
service.ProDesc = "设备温度严重异常";
break;
case "04":
service.ProDesc = "水冷机未连接";
break;
case "05":
service.ProDesc = "光传感器未连接";
break;
case "06":
service.ProDesc = "箱门未关闭";
break;
case "07":
service.ProDesc = "驱动配置异常";
break;
case "08":
service.ProDesc = "驱动通信异常";
break;
case "09":
service.ProDesc = "红光电流异常";
break;
case "10":
service.ProDesc = "绿光电流异常";
break;
case "11":
service.ProDesc = "蓝光电流异常";
break;
default:
break;
}
service.AddAbnotma(service.ClientID, service.EquID, service.ProDesc);
}
service.Send(service.ClientTime, service.ClientName, service.EquNum, service.Number, service.IsSend, service.ClientPhone, service.Agent, service.Seller, service.Engineer);
switch (service.IsReCharge)
{
case "Y":
retValues.Operating = IsActive("Recharge");
if (service.ClientTime <= service.ReMaTime) //如果客户端时长小于等于服务器剩余总时长(此为正常情况)
{
retValues.LeftTime = service.ReChargeTime + service.ClientTime; //返回时长为客户端时长+充值时长
retValues.ServerTime = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss");
retValues.Status = IsActive("Success");
DBHelper.UpdateEquTime(service.EquNum, retValues.LeftTime);
Equstatus.sTM = Convert.ToInt32(retValues.LeftTime).ToString();
DBHelper.Add(Equstatus);
DBHelper.ExecuteNonQuery(string.Concat(new string[] { "update Equipment set EquStatus='", service.sMS, "' WHERE EquNum='", service.EquNum, "'" }));
DBHelper.ExecuteNonQuery(string.Concat(new object[] { "update Equipment set ReviewTime='", DBHelper.GetDate(), "' WHERE EquNum='", service.EquNum, "'" }));
if (retValues.LeftTime > 500M)
{
DBHelper.UpEquIsSend(service.EquNum, "1,1,1,1");
}
else if (retValues.LeftTime <= 500M && retValues.LeftTime > 200M)
{
DBHelper.UpEquIsSend(service.EquNum, "0,1,1,1");
}
else if (retValues.LeftTime <= 200M && retValues.LeftTime > 100M)
{
DBHelper.UpEquIsSend(service.EquNum, "1,0,1,1");
}
else
{
DBHelper.UpEquIsSend(service.EquNum, "1,1,0,0");
}
service.GetJson(retValues);
return;
}
else //客户端时长大于服务器端时长
{
retValues.LeftTime = service.ReMaTime + service.ReChargeTime; //返回时长为 服务器端剩余总时长+充值时长
retValues.ServerTime = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss");
retValues.Status = IsActive("Success");
DBHelper.UpdateEquTime(service.EquNum, retValues.LeftTime);
Equstatus.sTM = Convert.ToInt32(retValues.LeftTime).ToString();
DBHelper.Add(Equstatus);
DBHelper.ExecuteNonQuery(string.Concat(new string[] { "update Equipment set EquStatus='", service.sMS, "' WHERE EquNum='", service.EquNum, "'" }));
DBHelper.ExecuteNonQuery(string.Concat(new object[] { "update Equipment set ReviewTime='", DBHelper.GetDate(), "' WHERE EquNum='", service.EquNum, "'" }));
if (retValues.LeftTime <= 500M && retValues.LeftTime > 200M)
{
DBHelper.UpEquIsSend(service.EquNum, "0,0,0,0");
}
else if (retValues.LeftTime <= 200M && retValues.LeftTime > 100M)
{
DBHelper.UpEquIsSend(service.EquNum, "1,0,0,0");
}
else
{
DBHelper.UpEquIsSend(service.EquNum, "1,1,0,0");
}
service.GetJson(retValues);
return;
}
case "N":
if (service.IsDelay == "2")
{
retValues.LeftTime = service.ReMaTime;
retValues.Operating = "Normal";
retValues.ServerTime = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss");
retValues.Status = "Success";
Equstatus.sTM = Convert.ToInt32(service.ReMaTime).ToString();
//DBHelper.Add(Equstatus);
DBHelper.ExecuteNonQuery(string.Concat(new string[] { "update Equipment set EquStatus='", service.sMS, "' WHERE EquNum='", service.EquNum, "'" }));
DBHelper.ExecuteNonQuery(string.Concat(new object[] { "update Equipment set ReviewTime='", DBHelper.GetDate(), "' WHERE EquNum='", service.EquNum, "'" }));
DBHelper.ExecuteNonQuery("update Equipment set IsDelay='0" + "' where EquNum='" + service.EquNum + "'");
service.GetJson(retValues);
return;
}
if (service.ReMaTime >= service.ClientTime) //正常情况
{
retValues.Operating = "Normal";
retValues.Status = IsActive("Success");
retValues.ServerTime = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss");
retValues.LeftTime = service.ClientTime;
Equstatus.sTM = Convert.ToInt32(retValues.LeftTime).ToString();
DBHelper.Add(Equstatus);
DBHelper.UpdateEquTime(service.EquNum, retValues.LeftTime);
DBHelper.ExecuteNonQuery(string.Concat(new string[] { "update Equipment set EquStatus='", service.sMS, "' WHERE EquNum='", service.EquNum, "'" }));
DBHelper.ExecuteNonQuery(string.Concat(new object[] { "update Equipment set ReviewTime='", DBHelper.GetDate(), "' WHERE EquNum='", service.EquNum, "'" }));
service.GetJson(retValues);
return;
}
else //如果客户端时长>服务端时长
{
retValues.Operating = "Normal";
retValues.Status = IsActive("Success");
retValues.ServerTime = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss");
retValues.LeftTime = service.ClientTime; //返回客户端的时长
DBHelper.Add(Equstatus);
//DBHelper.UpdateEquTime(service.EquNum, service.ReMaTime);
DBHelper.ExecuteNonQuery(string.Concat(new string[] { "update Equipment set EquStatus='", service.sMS, "' WHERE EquNum='", service.EquNum, "'" }));
DBHelper.ExecuteNonQuery(string.Concat(new object[] { "update Equipment set ReviewTime='", DBHelper.GetDate(), "' WHERE EquNum='", service.EquNum, "'" }));
service.GetJson(retValues);
return;
}
default:
retValues.Operating = "UnKnow";
DBHelper.Add(Equstatus);
DBHelper.ExecuteNonQuery(string.Concat(new string[] { "update Equipment set EquStatus='", service.sMS, "' WHERE EquNum='", service.EquNum, "'" }));
DBHelper.ExecuteNonQuery(string.Concat(new object[] { "update Equipment set ReviewTime='", DBHelper.GetDate(), "' WHERE EquNum='", service.EquNum, "'" }));
break;
}
}
else
{
retValues.Operating = "Please Leave This Page!";
retValues.ServerTime = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss");
retValues.LeftTime = Decimal.Zero;
retValues.Status = "Failure";
service.GetJson(retValues);
return;
}
}
else
{
//this.GetJson();
//return;
retValues.Status = "Failure";
retValues.Operating = "Please Leave This Page!";
retValues.ServerTime = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss");
retValues.LeftTime = Decimal.Zero;
service.GetJson(retValues);
return;
}
}
/// <summary>
/// 增加机器状态表数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static void Add(EquStatus model)
{
StringBuilder builder = new StringBuilder();
StringBuilder builder2 = new StringBuilder();
StringBuilder builder3 = new StringBuilder();
if (model.sNU != null)
{
builder2.Append("sNU,");
builder3.Append("'" + model.sNU + "',");
}
if (model.sMT != null)
{
builder2.Append("sMT,");
builder3.Append("'" + model.sMT + "',");
}
if (model.sMS != null)
{
builder2.Append("sMS,");
builder3.Append("'" + model.sMS + "',");
}
if (model.sTM != null)
{
builder2.Append("sTM,");
builder3.Append("'" + model.sTM + "',");
}
if (model.sLI != null)
{
builder2.Append("sLI,");
builder3.Append("'" + model.sLI + "',");
}
if (model.sURT1 != null)
{
builder2.Append("sURT1,");
builder3.Append("'" + model.sURT1 + "',");
}
if (model.sURL != null)
{
builder2.Append("sURL,");
builder3.Append("'" + model.sURL + "',");
}
if (model.sURC1 != null)
{
builder2.Append("sURC1,");
builder3.Append("'" + model.sURC1 + "',");
}
if (model.sURC2 != null)
{
builder2.Append("sURC2,");
builder3.Append("'" + model.sURC2 + "',");
}
if (model.sURC3 != null)
{
builder2.Append("sURC3,");
builder3.Append("'" + model.sURC3 + "',");
}
if (model.sURC4 != null)
{
builder2.Append("sURC4,");
builder3.Append("'" + model.sURC4 + "',");
}
if (model.sURC5 != null)
{
builder2.Append("sURC5,");
builder3.Append("'" + model.sURC5 + "',");
}
if (model.sURC6 != null)
{
builder2.Append("sURC6,");
builder3.Append("'" + model.sURC6 + "',");
}
if (model.sURC7 != null)
{
builder2.Append("sURC7,");
builder3.Append("'" + model.sURC7 + "',");
}
if (model.sURC8 != null)
{
builder2.Append("sURC8,");
builder3.Append("'" + model.sURC8 + "',");
}
if (model.sURC9 != null)
{
builder2.Append("sURC9,");
builder3.Append("'" + model.sURC9 + "',");
}
if (model.sURC10 != null)
{
builder2.Append("sURC10,");
builder3.Append("'" + model.sURC10 + "',");
}
if (model.sURC11 != null)
{
builder2.Append("sURC11,");
builder3.Append("'" + model.sURC11 + "',");
}
if (model.sURC12 != null)
{
builder2.Append("sURC12,");
builder3.Append("'" + model.sURC12 + "',");
}
if (model.sURC13 != null)
{
builder2.Append("sURC13,");
builder3.Append("'" + model.sURC13 + "',");
}
if (model.sURC14 != null)
{
builder2.Append("sURC14,");
builder3.Append("'" + model.sURC14 + "',");
}
if (model.sURC15 != null)
{
builder2.Append("sURC15,");
builder3.Append("'" + model.sURC15 + "',");
}
if (model.sUGT1 != null)
{
builder2.Append("sUGT1,");
builder3.Append("'" + model.sUGT1 + "',");
}
if (model.sUGL != null)
{
builder2.Append("sUGL,");
builder3.Append("'" + model.sUGL + "',");
}
if (model.sUGC1 != null)
{
builder2.Append("sUGC1,");
builder3.Append("'" + model.sUGC1 + "',");
}
if (model.sUGC2 != null)
{
builder2.Append("sUGC2,");
builder3.Append("'" + model.sUGC2 + "',");
}
if (model.sUGC3 != null)
{
builder2.Append("sUGC3,");
builder3.Append("'" + model.sUGC3 + "',");
}
if (model.sUGC4 != null)
{
builder2.Append("sUGC4,");
builder3.Append("'" + model.sUGC4 + "',");
}
if (model.sUGC5 != null)
{
builder2.Append("sUGC5,");
builder3.Append("'" + model.sUGC5 + "',");
}
if (model.sUGC6 != null)
{
builder2.Append("sUGC6,");
builder3.Append("'" + model.sUGC6 + "',");
}
if (model.sUGC7 != null)
{
builder2.Append("sUGC7,");
builder3.Append("'" + model.sUGC7 + "',");
}
if (model.sUGC8 != null)
{
builder2.Append("sUGC8,");
builder3.Append("'" + model.sUGC8 + "',");
}
if (model.sUGC9 != null)
{
builder2.Append("sUGC9,");
builder3.Append("'" + model.sUGC9 + "',");
}
if (model.sUGC10 != null)
{
builder2.Append("sUGC10,");
builder3.Append("'" + model.sUGC10 + "',");
}
if (model.sUGC11 != null)
{
builder2.Append("sUGC11,");
builder3.Append("'" + model.sUGC11 + "',");
}
if (model.sUGC12 != null)
{
builder2.Append("sUGC12,");
builder3.Append("'" + model.sUGC12 + "',");
}
if (model.sUGC13 != null)
{
builder2.Append("sUGC13,");
builder3.Append("'" + model.sUGC13 + "',");
}
if (model.sUGC14 != null)
{
builder2.Append("sUGC14,");
builder3.Append("'" + model.sUGC14 + "',");
}
if (model.sUGC15 != null)
{
builder2.Append("sUGC15,");
builder3.Append("'" + model.sUGC15 + "',");
}
if (model.sUBT != null)
{
builder2.Append("sUBT,");
builder3.Append("'" + model.sUBT + "',");
}
if (model.sUBL != null)
{
builder2.Append("sUBL,");
builder3.Append("'" + model.sUBL + "',");
}
if (model.sUBC1 != null)
{
builder2.Append("sUBC1,");
builder3.Append("'" + model.sUBC1 + "',");
}
if (model.sUBC2 != null)
{
builder2.Append("sUBC2,");
builder3.Append("'" + model.sUBC2 + "',");
}
if (model.sUBC3 != null)
{
builder2.Append("sUBC3,");
builder3.Append("'" + model.sUBC3 + "',");
}
if (model.sUBC4 != null)
{
builder2.Append("sUBC4,");
builder3.Append("'" + model.sUBC4 + "',");
}
if (model.sDRT1 != null)
{
builder2.Append("sDRT1,");
builder3.Append("'" + model.sDRT1 + "',");
}
if (model.sDRL != null)
{
builder2.Append("sDRL,");
builder3.Append("'" + model.sDRL + "',");
}
if (model.sDRC1 != null)
{
builder2.Append("sDRC1,");
builder3.Append("'" + model.sDRC1 + "',");
}
if (model.sDRC2 != null)
{
builder2.Append("sDRC2,");
builder3.Append("'" + model.sDRC2 + "',");
}
if (model.sDRC3 != null)
{
builder2.Append("sDRC3,");
builder3.Append("'" + model.sDRC3 + "',");
}
if (model.sDRC4 != null)
{
builder2.Append("sDRC4,");
builder3.Append("'" + model.sDRC4 + "',");
}
if (model.sDRC5 != null)
{
builder2.Append("sDRC5,");
builder3.Append("'" + model.sDRC5 + "',");
}
if (model.sDRC6 != null)
{
builder2.Append("sDRC6,");
builder3.Append("'" + model.sDRC6 + "',");
}
if (model.sDRC7 != null)
{
builder2.Append("sDRC7,");
builder3.Append("'" + model.sDRC7 + "',");
}
if (model.sDRC8 != null)
{
builder2.Append("sDRC8,");
builder3.Append("'" + model.sDRC8 + "',");
}
if (model.sDRC9 != null)
{
builder2.Append("sDRC9,");
builder3.Append("'" + model.sDRC9 + "',");
}
if (model.sDRC10 != null)
{
builder2.Append("sDRC10,");
builder3.Append("'" + model.sDRC10 + "',");
}
if (model.sDRC11 != null)
{
builder2.Append("sDRC11,");
builder3.Append("'" + model.sDRC11 + "',");
}
if (model.sDRC12 != null)
{
builder2.Append("sDRC12,");
builder3.Append("'" + model.sDRC12 + "',");
}
if (model.sDRC13 != null)
{
builder2.Append("sDRC13,");
builder3.Append("'" + model.sDRC13 + "',");
}
if (model.sDRC14 != null)
{
builder2.Append("sDRC14,");
builder3.Append("'" + model.sDRC14 + "',");
}
if (model.sDRC15 != null)
{
builder2.Append("sDRC15,");
builder3.Append("'" + model.sDRC15 + "',");
}
if (model.sDGT1 != null)
{
builder2.Append("sDGT1,");
builder3.Append("'" + model.sDGT1 + "',");
}
if (model.sDGL != null)
{
builder2.Append("sDGL,");
builder3.Append("'" + model.sDGL + "',");
}
if (model.sDGC1 != null)
{
builder2.Append("sDGC1,");
builder3.Append("'" + model.sDGC1 + "',");
}
if (model.sDGC2 != null)
{
builder2.Append("sDGC2,");
builder3.Append("'" + model.sDGC2 + "',");
}
if (model.sDGC3 != null)
{
builder2.Append("sDGC3,");
builder3.Append("'" + model.sDGC3 + "',");
}
if (model.sDGC4 != null)
{
builder2.Append("sDGC4,");
builder3.Append("'" + model.sDGC4 + "',");
}
if (model.sDGC5 != null)
{
builder2.Append("sDGC5,");
builder3.Append("'" + model.sDGC5 + "',");
}
if (model.sDGC6 != null)
{
builder2.Append("sDGC6,");
builder3.Append("'" + model.sDGC6 + "',");
}
if (model.sDGC7 != null)
{
builder2.Append("sDGC7,");
builder3.Append("'" + model.sDGC7 + "',");
}
if (model.sDGC8 != null)
{
builder2.Append("sDGC8,");
builder3.Append("'" + model.sDGC8 + "',");
}
if (model.sDGC9 != null)
{
builder2.Append("sDGC9,");
builder3.Append("'" + model.sDGC9 + "',");
}
if (model.sDGC10 != null)
{
builder2.Append("sDGC10,");
builder3.Append("'" + model.sDGC10 + "',");
}
if (model.sDGC11 != null)
{
builder2.Append("sDGC11,");
builder3.Append("'" + model.sDGC11 + "',");
}
if (model.sDGC12 != null)
{
builder2.Append("sDGC12,");
builder3.Append("'" + model.sDGC12 + "',");
}
if (model.sDGC13 != null)
{
builder2.Append("sDGC13,");
builder3.Append("'" + model.sDGC13 + "',");
}
if (model.sDGC14 != null)
{
builder2.Append("sDGC14,");
builder3.Append("'" + model.sDGC14 + "',");
}
if (model.sDGC15 != null)
{
builder2.Append("sDGC15,");
builder3.Append("'" + model.sDGC15 + "',");
}
if (model.sDBT != null)
{
builder2.Append("sDBT,");
builder3.Append("'" + model.sDBT + "',");
}
if (model.sDBL != null)
{
builder2.Append("sDBL,");
builder3.Append("'" + model.sDBL + "',");
}
if (model.sDBC1 != null)
{
builder2.Append("sDBC1,");
builder3.Append("'" + model.sDBC1 + "',");
}
if (model.sDBC2 != null)
{
builder2.Append("sDBC2,");
builder3.Append("'" + model.sDBC2 + "',");
}
if (model.sDBC3 != null)
{
builder2.Append("sDBC3,");
builder3.Append("'" + model.sDBC3 + "',");
}
if (model.sDBC4 != null)
{
builder2.Append("sDBC4,");
builder3.Append("'" + model.sDBC4 + "',");
}
if (model.sERR != null)
{
builder2.Append("sERR,");
builder3.Append("'" + model.sERR + "',");
}
if (model.sTMP1 != null)
{
builder2.Append("sTMP1,");
builder3.Append("'" + model.sTMP1 + "',");
}
if (model.sTMP2 != null)
{
builder2.Append("sTMP2,");
builder3.Append("'" + model.sTMP2 + "',");
}
if (model.sTMP3 != null)
{
builder2.Append("sTMP3,");
builder3.Append("'" + model.sTMP3 + "',");
}
if (model.sTMP4 != null)
{
builder2.Append("sTMP4,");
builder3.Append("'" + model.sTMP4 + "',");
}
if (model.sTMP5 != null)
{
builder2.Append("sTMP5,");
builder3.Append("'" + model.sTMP5 + "',");
}
if (model.sTMP6 != null)
{
builder2.Append("sTMP6,");
builder3.Append("'" + model.sTMP6 + "',");
}
if (model.sSCR1 != null)
{
builder2.Append("sSCR1,");
builder3.Append("'" + model.sSCR1 + "',");
}
if (model.sSCR2 != null)
{
builder2.Append("sSCR2,");
builder3.Append("'" + model.sSCR2 + "',");
}
if (model.sSCR3 != null)
{
builder2.Append("sSCR3,");
builder3.Append("'" + model.sSCR3 + "',");
}
if (model.sSCR4 != null)
{
builder2.Append("sSCR4,");
builder3.Append("'" + model.sSCR4 + "',");
}
if (model.sSCR5 != null)
{
builder2.Append("sSCR5,");
builder3.Append("'" + model.sSCR5 + "',");
}
if (model.sSCR6 != null)
{
builder2.Append("sSCR6,");
builder3.Append("'" + model.sSCR6 + "',");
}
if (model.sSCR7 != null)
{
builder2.Append("sSCR7,");
builder3.Append("'" + model.sSCR7 + "',");
}
if (model.sSCR8 != null)
{
builder2.Append("sSCR8");
builder3.Append("'" + model.sSCR8 + "'");
}
builder.Append("insert into EquStatus(");
builder.Append(builder2.ToString());
builder.Append(")");
builder.Append(" values (");
builder.Append(builder3.ToString());
builder.Append(")");
ExecuteNonQuery(builder.ToString());
}
