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