//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
ChkAdminLevel("vehicle_list", DTEnums.ActionEnum.Delete.ToString()); //检查权限
int sucCount = 0;
int errorCount = 0;
BLL.Vehicle bll = new BLL.Vehicle();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
if (bll.Delete(id))
{
sucCount += 1;
}
else
{
errorCount += 1;
}
}
}
AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除车辆" + sucCount + "条，失败" + errorCount + "条"); //记录日志
JscriptMsg("删除成功" + sucCount + "条，失败" + errorCount + "条！",
Utils.CombUrlTxt("vehicle_list.aspx", "motorcadeName={0}&keywords={1}", this._motorcadeName.ToString(), this.keywords), "Success");
}
private bool DoAdd()
{
bool result = false;
Model.Vehicle model = new Model.Vehicle();
BLL.Vehicle bll = new BLL.Vehicle();
model.PlateNumber = txtPlateNumber.Text;
model.Driver = txtDriver.Text;
model.LinkTel = txtLinkTel.Text;
model.LinkAddress = txtLinkAddress.Text;
model.Remark = txtRemark.Text;
if (bll.Add(model))
{
AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加车辆:" + model.PlateNumber); //记录日志
result = true;
}
return result;
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
if (!string.IsNullOrEmpty(_motorcadeName))
{
this.ddlMotorcadeName.SelectedValue = this._motorcadeName;
}
this.txtKeywords.Text = this.keywords;
BLL.Vehicle bll = new BLL.Vehicle();
this.rptList.DataSource = bll.GetMyList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("vehicle_list.aspx", "motorcadeName={0}&keywords={1}&page={2}",
this._motorcadeName, this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private bool DoAdd()
{
bool result = false;
Model.Vehicle model = new Model.Vehicle();
BLL.Vehicle bll = new BLL.Vehicle();
model.PlateNumber = txtPlateNumber.Text;
model.Driver = txtDriver.Text;
model.LinkTel = txtLinkTel.Text;
model.LinkAddress = txtLinkAddress.Text;
model.Remark = txtRemark.Text;
if (bll.Add(model))
{
AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加车辆:" + model.PlateNumber); //记录日志
result = true;
}
return(result);
}
private bool DoAdd()
{
bool result = false;
Model.Vehicle model = new Model.Vehicle();
BLL.Vehicle bll = new BLL.Vehicle();
model.MotorcadeName = "";
model.CarCode = txtCarCode.Text.Trim();
model.CarNumber = model.CarCode;
model.MotorcycleType = "";
model.EngineType = "";
model.ChassisNumber = "";
model.FrameNumber = "";
model.InsuranceNumber = "";
model.LoadingCapacity = 0.00M;
model.Remarks = "";
Model.Driver driver = new Model.Driver();
BLL.Driver driverBll = new BLL.Driver();
driver.CarNumber = model.CarNumber;
driver.RealName = txtRealName.Text.Trim();
driver.RealNameCode = "";
driver.IdCardNumber = "";
driver.LinkTel = txtLinkTel.Text.Trim();
driver.LinkAddress = "";
driver.BeganWorkDate = DateTime.Now;
driver.IssuedDate = DateTime.Now;
driver.AnnualDate = DateTime.Now;
driver.DrivingLicence = "";
driver.DrivingPermitNumber = "";
driver.DrivingPermitType = "";
driver.IsDimission = 0;
driver.Remarks = "";
if (bll.Add(model, driver))
{
AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加车辆:" + model.CarCode); //记录日志
result = true;
}
return result;
}
private bool DoEdit(int _id)
{
bool result = false;
BLL.Vehicle bll = new BLL.Vehicle();
Model.Vehicle model = bll.GetModel(_id);
model.PlateNumber = txtPlateNumber.Text;
model.Driver = txtDriver.Text;
model.LinkTel = txtLinkTel.Text;
model.LinkAddress = txtLinkAddress.Text;
model.Remark = txtRemark.Text;
if (bll.Update(model))
{
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改车辆:" + model.PlateNumber); //记录日志
result = true;
}
return(result);
}
private void TreeBind(string strWhere)
{
BLL.Motorcade bll = new BLL.Motorcade();
DataTable dt = bll.GetList(0, strWhere, "Id desc").Tables[0];
ddlMotorcade.Items.Clear();
ddlMotorcade.Items.Add(new ListItem("请选择车队", ""));
foreach (DataRow dr in dt.Rows)
{
this.ddlMotorcade.Items.Add(new ListItem(dr["Name"].ToString(), dr["Name"].ToString()));
}
ddlMotorcade.SelectedIndex = 0;
string motorcadeName = ddlMotorcade.SelectedValue;
BLL.Vehicle vehicleBll = new BLL.Vehicle();
ddlCarNumber.Items.Clear();
ddlCarNumber.Items.Add(new ListItem("请选择车辆", ""));
if (!string.IsNullOrEmpty(motorcadeName))
{
DataTable vehicledt = vehicleBll.GetList(0, " MotorcadeName = '" + motorcadeName + "' ", "Id desc").Tables[0];
foreach (DataRow dr in vehicledt.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
}
else
{
DataTable vehicledt = vehicleBll.GetList(0, "", "Id desc").Tables[0];
foreach (DataRow dr in vehicledt.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
}
BLL.Order orderBll = new BLL.Order();
this.rptList.DataSource = orderBll.GetList(" Quantity > DispatchedCount or (IsCharteredCar = 1 and DispatchedCount = 0.00)");
this.rptList.DataBind();
}
private void List(HttpContext context)
{
string motorcade = DTRequest.GetQueryString("motorcade");
if (string.IsNullOrEmpty(motorcade))
{
context.Response.Write("{\"status\": 0, \"msg\": \"无效的车队名称！\"}");
return;
}
try
{
DataSet ds = new BLL.Vehicle().GetList(" MotorcadeName = '" + motorcade + "' ");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("{\"status\": 1, \"msg\": \"获取成功！\",\"vehicles\" : [");
foreach (DataRow dr in ds.Tables[0].Rows)
{
sb.Append("{\"carCode\": \"" + dr["CarCode"].ToString() + "\", \"id\": \"" + dr["Id"].ToString() + "\", \"carNumber\": \"" + dr["CarNumber"].ToString() + "\"},");
}
if (sb.ToString().EndsWith(","))
{
sb.Remove(sb.Length - 1, 1);
}
sb.Append("]}");
context.Response.Write(sb.ToString());
}
else
{
context.Response.Write("{\"status\": 0, \"msg\": \"记录不存在！\"}");
}
}
catch
{
context.Response.Write("{\"status\": 0, \"msg\": \"出现异常！\"}");
return;
}
}
private void List(HttpContext context)
{
string motorcade = DTRequest.GetQueryString("motorcade");
if (string.IsNullOrEmpty(motorcade))
{
context.Response.Write("{\"status\": 0, \"msg\": \"无效的车队名称！\"}");
return;
}
try
{
DataSet ds = new BLL.Vehicle().GetList(" MotorcadeName = '" + motorcade + "' ");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("{\"status\": 1, \"msg\": \"获取成功！\",\"vehicles\" : [");
foreach (DataRow dr in ds.Tables[0].Rows)
{
sb.Append("{\"carCode\": \"" + dr["CarCode"].ToString() + "\", \"id\": \"" + dr["Id"].ToString() + "\", \"carNumber\": \"" + dr["CarNumber"].ToString() + "\"},");
}
if (sb.ToString().EndsWith(","))
{
sb.Remove(sb.Length - 1, 1);
}
sb.Append("]}");
context.Response.Write(sb.ToString());
}
else
{
context.Response.Write("{\"status\": 0, \"msg\": \"记录不存在！\"}");
}
}
catch
{
context.Response.Write("{\"status\": 0, \"msg\": \"出现异常！\"}");
return;
}
}
private bool DoAdd()
{
bool result = false;
Model.Vehicle model = new Model.Vehicle();
BLL.Vehicle bll = new BLL.Vehicle();
model.MotorcadeName = ddlMotorcadeName.SelectedValue;
model.CarCode = txtCarCode.Text.Trim();
model.CarNumber = string.IsNullOrEmpty(txtCarNumber.Text.Trim()) ? model.CarCode : txtCarNumber.Text.Trim();
model.MotorcycleType = ddlMotorcycleType.SelectedValue;
model.EngineType = txtEngineType.Text.Trim();
model.ChassisNumber = txtChassisNumber.Text.Trim();
model.FrameNumber = txtFrameNumber.Text.Trim();
model.InsuranceNumber = txtInsuranceNumber.Text.Trim();
model.LoadingCapacity = Utils.StrToDecimal(txtLoadingCapacity.Text.Trim(), 0.00M);
model.Remarks = txtRemarks.Text.Trim();
if (bll.Add(model) > 0)
{
AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加车辆:" + model.CarCode); //记录日志
result = true;
}
return result;
}
private void ShowInfo(int _id)
{
BLL.Vehicle bll = new BLL.Vehicle();
Model.Vehicle model = bll.GetModel(_id);
ddlMotorcadeName.SelectedValue = model.MotorcadeName;
txtCarCode.Text = model.CarCode;
txtCarNumber.Text = model.CarNumber;
ddlMotorcycleType.SelectedValue = model.MotorcycleType;
txtEngineType.Text = model.EngineType;
txtChassisNumber.Text = model.ChassisNumber;
txtFrameNumber.Text = model.FrameNumber;
txtInsuranceNumber.Text = model.InsuranceNumber;
txtLoadingCapacity.Text = model.LoadingCapacity.ToString();
txtRemarks.Text = model.Remarks;
}
private void TreeBind(string strWhere)
{
BLL.Customer customerBLL = new BLL.Customer();
DataTable customerDT = customerBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlCustomer.Items.Clear();
this.ddlCustomer.Items.Add(new ListItem("选择客户", ""));
foreach (DataRow dr in customerDT.Rows)
{
this.ddlCustomer.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString()));
}
this.ddlGoods.Items.Clear();
this.ddlGoods.Items.Add(new ListItem("选择货物", ""));
BLL.Vehicle vehicleBLL = new BLL.Vehicle();
DataTable vehicleDT = vehicleBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlVehicle.Items.Clear();
this.ddlVehicle.Items.Add(new ListItem("选择车辆", ""));
foreach (DataRow dr in vehicleDT.Rows)
{
this.ddlVehicle.Items.Add(new ListItem(dr["PlateNumber"].ToString(), dr["Id"].ToString()));
}
BLL.HandlingMode handlingModeBLL = new BLL.HandlingMode();
DataTable handlingModeDT = handlingModeBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlHandlingMode.Items.Clear();
this.ddlHandlingMode.Items.Add(new ListItem("选择装卸方式", ""));
foreach (DataRow dr in handlingModeDT.Rows)
{
this.ddlHandlingMode.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString()));
}
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
if (!string.IsNullOrEmpty(_motorcadeName))
{
this.ddlMotorcadeName.SelectedValue = this._motorcadeName;
}
this.txtKeywords.Text = this.keywords;
BLL.Vehicle bll = new BLL.Vehicle();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("vehicle_list.aspx", "motorcadeName={0}&keywords={1}&page={2}",
this._motorcadeName, this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
BLL.Vehicle bll = new BLL.Vehicle();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("vehicle_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void ShowInfo(int _id)
{
BLL.Vehicle bll = new BLL.Vehicle();
Model.Vehicle model = bll.GetModel(_id);
if (model != null)
{
txtCarCode.Text = model.CarCode;
BLL.Driver driverBLL = new BLL.Driver();
Model.Driver driver = driverBLL.GetModel(model.CarCode);
if (driver != null)
{
txtRealName.Text = driver.RealName;
txtLinkTel.Text = driver.LinkTel;
}
}
}
private void TreeBind(string strWhere)
{
BLL.Vehicle bll = new BLL.Vehicle();
DataTable dt = bll.GetList(0, strWhere, "Id desc").Tables[0];
ddlCarNumber.Items.Clear();
ddlCarNumber.Items.Add(new ListItem("请选择所驾车辆...", ""));
foreach (DataRow dr in dt.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
}
private void ShowInfo(int _id)
{
BLL.Vehicle bll = new BLL.Vehicle();
Model.Vehicle model = bll.GetModel(_id);
txtPlateNumber.Text = model.PlateNumber;
txtDriver.Text = model.Driver;
txtLinkTel.Text = model.LinkTel;
txtLinkAddress.Text = model.LinkAddress;
txtRemark.Text = model.Remark;
}
private void TreeBind(string strWhere)
{
BLL.Customer customerBLL = new BLL.Customer();
DataTable customerDT = customerBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlCustomer.Items.Clear();
this.ddlCustomer.Items.Add(new ListItem("客户", ""));
foreach (DataRow dr in customerDT.Rows)
{
this.ddlCustomer.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString()));
}
BLL.Goods goodsBLL = new BLL.Goods();
DataTable goodsDT = goodsBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlGoods.Items.Clear();
this.ddlGoods.Items.Add(new ListItem("货物", ""));
foreach (DataRow dr in goodsDT.Rows)
{
this.ddlGoods.Items.Add(new ListItem(dr["Name"].ToString(), dr["Id"].ToString()));
}
BLL.Vehicle vehicleBLL = new BLL.Vehicle();
DataTable vehicleDT = vehicleBLL.GetList(0, strWhere, "Id desc").Tables[0];
this.ddlVehicle.Items.Clear();
this.ddlVehicle.Items.Add(new ListItem("车辆", ""));
foreach (DataRow dr in vehicleDT.Rows)
{
this.ddlVehicle.Items.Add(new ListItem(dr["PlateNumber"].ToString(), dr["Id"].ToString()));
}
}
private void TreeBind(string strWhere)
{
BLL.Vehicle goodsBll = new BLL.Vehicle();
DataTable goodsDT = goodsBll.GetList(0, strWhere, "Id desc").Tables[0];
ddlCarNumber.Items.Clear();
ddlCarNumber.Items.Add(new ListItem("车号不限", ""));
foreach (DataRow dr in goodsDT.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
BLL.Customer customerBll = new BLL.Customer();
DataTable customerDT = customerBll.GetList(0, strWhere, "Id desc").Tables[0];
ddlCustomer1.Items.Clear();
ddlCustomer1.Items.Add(new ListItem("托运方不限", ""));
ddlCustomer2.Items.Clear();
ddlCustomer2.Items.Add(new ListItem("收货方不限", ""));
foreach (DataRow dr in customerDT.Rows)
{
if (!dr["Category"].ToString().Equals("托运方"))
{
this.ddlCustomer2.Items.Add(new ListItem(dr["ShortName"].ToString(), dr["ShortName"].ToString()));
}
if (!dr["Category"].ToString().Equals("收货方"))
{
this.ddlCustomer1.Items.Add(new ListItem(dr["ShortName"].ToString(), dr["ShortName"].ToString()));
}
}
}
private bool DoEdit(int _id)
{
bool result = false;
BLL.Vehicle bll = new BLL.Vehicle();
Model.Vehicle model = bll.GetModel(_id);
model.PlateNumber = txtPlateNumber.Text;
model.Driver = txtDriver.Text;
model.LinkTel = txtLinkTel.Text;
model.LinkAddress = txtLinkAddress.Text;
model.Remark = txtRemark.Text;
if (bll.Update(model))
{
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改车辆:" + model.PlateNumber); //记录日志
result = true;
}
return result;
}
private void TreeBind(string strWhere)
{
BLL.Motorcade bll = new BLL.Motorcade();
DataTable dt = bll.GetList(0, strWhere, "Id desc").Tables[0];
ddlMotorcade.Items.Clear();
ddlMotorcade.Items.Add(new ListItem("请选择车队", ""));
foreach (DataRow dr in dt.Rows)
{
this.ddlMotorcade.Items.Add(new ListItem(dr["Name"].ToString(), dr["Name"].ToString()));
}
ddlMotorcade.SelectedIndex = 0;
string motorcadeName = ddlMotorcade.SelectedValue;
BLL.Vehicle vehicleBll = new BLL.Vehicle();
ddlCarNumber.Items.Clear();
ddlCarNumber.Items.Add(new ListItem("请选择车辆", ""));
if (!string.IsNullOrEmpty(motorcadeName))
{
DataTable vehicledt = vehicleBll.GetList(0, " MotorcadeName = '" + motorcadeName + "' ", "Id desc").Tables[0];
foreach (DataRow dr in vehicledt.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
}
else
{
DataTable vehicledt = vehicleBll.GetList(0, "", "Id desc").Tables[0];
foreach (DataRow dr in vehicledt.Rows)
{
this.ddlCarNumber.Items.Add(new ListItem(dr["CarCode"].ToString(), dr["CarCode"].ToString()));
}
}
BLL.Order orderBll = new BLL.Order();
this.rptList.DataSource = orderBll.GetList(" Quantity > DispatchedCount or (IsCharteredCar = 1 and DispatchedCount = 0.00)");
this.rptList.DataBind();
}
