public static void Update(WebStep cus) { string sql = @"UPDATE [QLCV_WebStep] SET [IDWeb] = " + cus.IDWeb + @" ,[Step] = " + cus.Step + @" ,[Action] = N'" + cus.Action + @"' ,[Message] = N'" + cus.Message + @"' WHERE IDWeb=" + cus.IDWeb + " and Step=" + cus.Step; ServerProvider.ExecuteNonQuery(sql); }
public static void Update(WebStep cus) { string sql = @"UPDATE [QLCV_WebStep] SET [IDWeb] = " + cus.IDWeb + @" ,[Step] = " + cus.Step + @" ,[Action] = N'" + cus.Action + @"' ,[Message] = N'" + cus.Message + @"' WHERE IDWeb=" + cus.IDWeb+" and Step="+cus.Step; ServerProvider.ExecuteNonQuery(sql); }
public static WebStep Get(long ID) { string sql = @"select * from QLCV_WebStep where ID=" + ID; DataTable dtTable = ServerProvider.ExecuteToDataTable(sql); if (dtTable.Rows.Count > 0) { WebStep cus = new WebStep(); return((WebStep)RootLibrary.GetObjectValue(dtTable.Rows[0], cus)); } return(null); }
public static WebStep Get(long ID) { string sql = @"select * from QLCV_WebStep where ID=" + ID; DataTable dtTable = ServerProvider.ExecuteToDataTable(sql); if (dtTable.Rows.Count > 0) { WebStep cus = new WebStep(); return (WebStep)RootLibrary.GetObjectValue(dtTable.Rows[0], cus); } return null; }
public static long Insert(WebStep cus) { string sql = @"INSERT INTO QLCV_WebStep ([IDWeb] ,[Step] ,[Action] ,[Message]) VALUES (" + cus.IDWeb + @" ," + cus.Step + @" ,N'" + cus.Action + @"' ,N'" + cus.Message + @"')"; ServerProvider.ExecuteNonQuery(sql); return(1); //return long.Parse(ServerProvider.ExecuteScalar("Select @@IDENTITY").ToString()); }
public static long Insert(WebStep cus) { string sql = @"INSERT INTO QLCV_WebStep ([IDWeb] ,[Step] ,[Action] ,[Message]) VALUES (" + cus.IDWeb + @" ," + cus.Step + @" ,N'" + cus.Action + @"' ,N'" + cus.Message + @"')"; ServerProvider.ExecuteNonQuery(sql); return 1; //return long.Parse(ServerProvider.ExecuteScalar("Select @@IDENTITY").ToString()); }
public StatusObj UpTopicWeb() { StatusObj statusObj = new StatusObj(); if (forum == null) { statusObj.Message = "Object null"; statusObj.Status = "Error"; return(statusObj); } if (string.IsNullOrEmpty(forum.UrlPost)) { statusObj.Message = "Không có link up bài"; statusObj.Status = "Error"; return(statusObj); } try { // Start WatiN WebPage wp = WebPage.GetByPage(forum.Url.Trim().ToLower()); if (wp == null) { statusObj.Message = "Trang Web này chưa được đăng ký"; statusObj.Status = "Error"; return(statusObj); } IDWeb = wp.ID; DataTable dtTable1 = WebStep.GetByIDWeb(wp.ID); if (dtTable1 == null) { statusObj.Message = "Chưa đăng ký sử dụng phần mềm"; statusObj.Status = "Register"; return(statusObj); } if (Open() == false) { statusObj.Message = "Không mở được trình duyệt"; statusObj.Status = "Error"; return(statusObj); } int i = 0; while (i < dtTable1.Rows.Count) { DataRow dtRow = dtTable1.Rows[i]; string processStep = dtRow["Action"].ToString(); if (processStep.IndexOf("Exists") < 0) { processStep = processStep.Replace("{UserName}", forum.UserName); processStep = processStep.Replace("{Password}", forum.Password); processStep = processStep.Replace("{Url}", forum.UrlPost); processStep = processStep.Replace("{IDTopic}", forum.IDTopic); string s = MyCore.ProcessStep(processStep, ie); if (s != String.Empty) { if (dtRow["Message"] != null && dtRow["Message"].ToString().Trim() != "") { Close(); statusObj.Message = dtRow["Message"].ToString(); statusObj.Status = s; return(statusObj); } } i++; } else { try { string[] a = processStep.Split('('); string processType = a[0].Trim(); string processText = a[1].Trim(')'); string[] b = processText.Split('|'); string text = b[0].Trim(); int stepYes = int.Parse(b[1]); int stepNo = int.Parse(b[2]); if (MyCore.Exist(text, ie)) { i = stepYes - 1; } else { i = stepNo - 1; } } catch { i++; } } } statusObj.Message = "Successful"; statusObj.Status = "Successful"; statusObj.Value = ie.Url; Close(); return(statusObj); } catch (Exception ex) { if (ie != null) { Close(); statusObj.Message = "Lỗi hệ thống "; statusObj.Status = "Error"; return(statusObj); } } return(statusObj); }
private void btnSave_Click(object sender, EventArgs e) { if (txtUrl.Text == "") { MessageBox.Show("Nhập vào tên trang Web"); return; } if (webpageUp == null) { webpageUp = new WebPage(); webpageUp.Page = txtUrl.Text; webpageUp.Type = NumCode.UPWEB; webpageUp.Active = 1; long ID = WebPage.Insert(webpageUp); txtID.Text = ID.ToString(); foreach (DataRow dtRow in dtSource.Rows) { try { WebStep webStep = new WebStep(); webStep.IDWeb = ID; webStep.Step = long.Parse(dtRow["Step"].ToString()); webStep.Action = dtRow["Action"].ToString(); webStep.Message = dtRow["Message"].ToString(); WebStep.Insert(webStep); } catch (Exception) { } } MessageBox.Show("Đã lưu thành công"); lookUpEditPage_EditValueChanged(null, null); } else { webpageUp.Page = txtUrl.Text; //WebPage.Update(webpageUp); WebStep.DeleteByID(webpageUp.ID); foreach (DataRow dtRow in dtSource.Rows) { try { WebStep webStep = new WebStep(); webStep.IDWeb = webpageUp.ID; webStep.Step = long.Parse(dtRow["Step"].ToString()); webStep.Action = dtRow["Action"].ToString(); webStep.Message = dtRow["Message"].ToString(); WebStep.Insert(webStep); } catch (Exception) { } } MessageBox.Show("Đã lưu thành công"); lookUpEditPage_EditValueChanged(null, null); } }