public string Next() { string ret = "下一篇:没有了", err; string sql = "select top 1 * from smcms_article where CID = " + CID.ToString() + " and ID > " + ID.ToString() + " order by ID "; DataTable dt; if (ulLinnStudio.ulSqlHelper.GetDatatable(sql, out dt, out err)) { ret = "下一篇:<a href=\"./article.aspx?id=" + dt.Rows[0]["ID"].ToString() + "\">" + dt.Rows[0]["Title"].ToString() + "</a>"; } return(ret); }
private void Connect() { DialogResult dialogConnect; string MSG; int TDI = DriverId; int CID; bool IsEmptyField = false; if (FieldIsEmpty()) { My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("Check the empty fields.", "", this); return; } CID = Convert.ToInt32(ddlTruckCompany.SelectedValue); var List = (from b in listTruckDriver where b.TruckDriverId.Equals(TDI) & b.CompanyId.Equals(CID) select b).ToList(); if (List.Count > 0) { My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("This Driver Truck is already connected to this company.", "", this); return; } MSG = "Do you really want to connect the company " + ddlTruckCompany.Text + " to this driver truck " + lblNameDriver.Text + " ?"; dialogConnect = My.MyProject.Forms.MessageBoxCeresYesNo.ShowDialog("Connect Driver Truck", MSG, My.Resources.Resources.caution, this); if (dialogConnect == DialogResult.Yes) { if (TruckDriverCompanyService.Insert(TDI, CID)) { EmployeeActivityLogService.Insert(My.MyProject.Forms.FrmLoginWindow._userID, TruckDriverCompanyService.LastTruckDriverCompanyId().ToString(), "INSERT", "TRUCK DRIVER", "New Truck Driver Company Id: " + CID.ToString() + " Connect with TruckDriverId: " + DriverId.ToString()); LoadDataGridView(); My.MyProject.Forms.FrmParentScreen.f.LoadForm(); } else { My.MyProject.Forms.MessageBoxCeresOK.ShowDialog("ERROR", "An error has occurred, please try again. If the error persists, inform the IT department. #3421", this); } } }