public static List <string> hatNames() { //Sloppy method for storing the https://backpack.tf/unusuals HTML source. string[] unusualList = (new HTMLFile().getFile()).Split(new[] { "id='unusual-pricelist'>" }, StringSplitOptions.None)[1].Split(new[] { "<li title=\"Unusual " }, StringSplitOptions.None); List <string> hatList = new List <string>(); string hatName; foreach (string Unusual in unusualList) { hatName = Unusual.Split(new[] { "\" class=" }, StringSplitOptions.None)[0]; if (Unusual.Length > 0) { hatList.Add(Unusual.Split(new[] { "<a href=\"/unusual/" }, StringSplitOptions.None)[1].Split(new[] { "\">" }, StringSplitOptions.None)[0]); } } return(hatList); }
/// <summary> /// 新增一条质检记录 /// </summary> /// <param name="qcRecord">质检实体</param> /// <returns></returns> public static bool Insert(Unusual qcRecord) { bool rbool = true; using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { try { db.Unusual.InsertOnSubmit(qcRecord); db.SubmitChanges(); rbool = true; } catch { rbool = false; } finally { db.Connection.Close(); } } return(rbool); }
/// <summary> /// 新增一异常记录 /// </summary> /// <param name="qcRecord"> </param> /// /// <param name="rint"> </param> /// <returns></returns> public static bool InsertOneQCRecord(Unusual unusual, out int rint) { rint = 0; bool rbool = true; using (DCQUALITYDataContext db = new DCQUALITYDataContext()) { try { db.Unusual.InsertOnSubmit(unusual); db.SubmitChanges(); rint = unusual.Unusual_Id; rbool = true; } catch { rbool = false; } finally { db.Connection.Close(); } } return(rbool); }
public MainFrom mf;//主窗体 /// <summary> /// 单击发送按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSMSSend_Click(object sender, EventArgs e) { //短信内容 if (string.IsNullOrEmpty(txtcontent.Text.Trim())) { MessageBox.Show("请输入短信内容"); return; } //质检状态改为暂停质检 LinQBaseDao.Query("update QCInfo set QCInfo_Dictionary_ID=(select Dictionary_ID from Dictionary where Dictionary_Name='暂停质检') where QCInfo_ID=" + QcinfoID); //添加异常信息 //insert into Unusual values(质检编号,异常类型编号,异常类型编号,'内容','未处理',经手人编号,0) Unusual un = new Unusual(); un.Unusual_QCInfo_ID = QcinfoID; un.Unusual_UnusualType_Id = Convert.ToInt32(cboUnusualType_Name.SelectedValue); un.Unusual_TestItems_ID = Convert.ToInt32(cboUnusualType_Name.SelectedValue); un.Unusual_content = cboUnusualType_Name.Text + "异常:" + txtcontent.Text.Trim(); un.Unusual_State = "未处理"; un.Unusual_ISSMSSend = false; un.Unusual_time = LinQBaseDao.getDate(); int u_id = 0; if (UnusualDAL.InsertOneQCRecord(un, out u_id)) { MessageBox.Show("短信发送成功!"); int TestItems_ID = Convert.ToInt32(cboUnusualType_Name.SelectedValue); //发送内容及发送人 DataSet SMSDs = LinQBaseDao.Query("select top(1)* from SMSConfigure where SMSConfigure_TestItems_ID=" + TestItems_ID);//只会存在一条 #region 取内容 string[] SMSContent = SMSDs.Tables[0].Rows[0]["SMSConfigure_SendContent"].ToString().Split(','); string[] SMSContentTxt = SMSDs.Tables[0].Rows[0]["SMSConfigure_SendContentText"].ToString().Split(','); string Contents = SMSSendContent(SMSContent, un.Unusual_Id, SMSContentTxt, un.Unusual_content);//存储短信内容 #endregion #region 取号码、姓名,并对其号码发送短信(号码和姓名同位置是一组数据) string[] SMSPhon = SMSDs.Tables[0].Rows[0]["SMSConfigure_ReceivePhone"].ToString().Split(';'); //号码 string[] SMSName = SMSDs.Tables[0].Rows[0]["SMSConfigure_Receive"].ToString().Split(';'); //姓名 for (int y = 0; y < SMSPhon.Count(); y++) //循环要发送的人数的电话号码 { if (SMSPhon[y] != "") { SmsSend ss = new SmsSend(); ss.SmsSend_Phone = SMSPhon[y]; ss.SmsSend_Text = Contents; ss.SmsSend_userName = SMSName[y]; ss.SmsSend_IsSend = "0"; ss.SmsSend_Unusunal_ID = un.Unusual_Id; bool b = SmsSendDAL.Insert(ss); } } #endregion Emety(); } else { MessageBox.Show("短信发送失败!"); return; } }