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()); }