private bool DoAdd() { bool result = true; Model.car_repair_recordinfo model = new Model.car_repair_recordinfo(); BLL.car_repair_recordbll bll = new BLL.car_repair_recordbll(); model.Code = txtCode.Text.Trim(); model.Repare_Time = txtRepare_Time.Text; model.Car = new Model.carinfo(); model.Car.Car_Number = ddlCar_Number.SelectedValue; string s = txtMileage.Text; model.Mileage = Convert.ToInt32(s.Trim() == "" ? "0" : s); s = txtNext_Mileage.Text; model.Next_Mileage = Convert.ToInt32(s.Trim() == "" ? "0" : s); model.Maintenance_Item = new Model.car_maintenance_iteminfo(); model.Maintenance_Item.Code = ddlMaintenance_Item.SelectedValue; model.Repair_Plant_Code = ddlRepair_Plant.SelectedValue; model.Reason = txtReason.Text; model.Driver = new Model.car_driverinfo(); model.Driver.Driver_Code = ddlDriver_Code.SelectedValue; if (bll.Add(model) < 1) { result = false; } else { BLL.carbll carbl = new BLL.carbll(); carbl.UpdateField(model.Car.Car_Number, " Status=2"); } return(result); }
private void BindCar_Number(string strwhere) { BLL.carbll carbll = new BLL.carbll(); DataTable cartb = carbll.GetList(1000, strwhere, " id").Tables[0]; BLL.car_use_recordbll carusebll = new BLL.car_use_recordbll(); DataTable carusedtb = carusebll.GetList(1000, " Status not in(5)", " id").Tables[0]; this.ddlCar_Number.Items.Clear(); this.ddlCar_Number.Items.Add(new ListItem("请选择车牌...", "")); foreach (DataRow dr in cartb.Rows) { bool add = true; string car_number = dr["Car_Number"].ToString(); foreach (DataRow ro in carusedtb.Rows) { string carnumber = ro["Car_Number"].ToString(); if (carnumber == car_number) { add = false; break; } } if (!add) { continue; } this.ddlCar_Number.Items.Add(new ListItem(car_number, car_number)); } }
private void ShowInfo(int _id) { BLL.carbll bll = new BLL.carbll(); Model.carinfo model = bll.GetModel(_id); txtCar_Number.Text = model.Car_Number; txtCar_Name.Text = model.Car_Name; ddlDept_Pros.SelectedValue = model.Dept_Pros; ddlCar_Type.SelectedValue = model.Car_Type.Type_Code; ddlDriver.SelectedValue = model.Driver.Driver_Code; txtBuy_Date.Text = model.Buy_Date.Replace(" 0:00:00", ""); txtPrice.Text = model.Price.ToString(); txtMileage_First.Text = model.Mileage_First.ToString(); //ddlStatus.SelectedValue = model.Status.ToString(); txtOil_Consumption.Text = model.Oil_Consumption.ToString(); txtEngine_Number.Text = model.Engine_Number; txtFrame_Number.Text = model.Frame_Number; txtWeight.Text = model.Weight.ToString(); txtSeat.Text = model.Seat.ToString(); txtcContent.Text = model.cContent; string s1 = model.Image1; string s2 = model.Image2; Image1.ImageUrl = "~/" + s1.Replace("~/", ""); Image2.ImageUrl = "~/" + s2.Replace("~/", ""); //FileUpload1.FileName=model.Image1; //FileUpload2.FileName = model.Image2; }
protected void Page_Load(object sender, EventArgs e) { string _action = DTRequest.GetQueryString("action"); if (!string.IsNullOrEmpty(_action) && _action == DTEnums.ActionEnum.Edit.ToString()) { this.action = DTEnums.ActionEnum.Edit.ToString();//修改类型 this.id = DTRequest.GetQueryInt("id"); if (this.id == 0) { JscriptMsg("传输参数不正确!", "back", "Error"); return; } if (!new BLL.car_repair_recordbll().Exists(this.id)) { JscriptMsg("信息不存在或已被删除!", "back", "Error"); return; } } if (!Page.IsPostBack) { txtCode.Text = DateTime.Now.ToString("yyyyMMddHHmmsss"); BLL.carbll bll = new BLL.carbll(); DataTable tb = bll.GetList(1000, " 1=1 and Status in(0,1)", " id").Tables[0]; this.ddlCar_Number.Items.Clear(); foreach (DataRow dr in tb.Rows) { this.ddlCar_Number.Items.Add(new ListItem(dr["Car_Number"].ToString(), dr["Car_Number"].ToString())); } BLL.car_maintenance_itembll bll1 = new BLL.car_maintenance_itembll(); DataTable tb1 = bll1.GetList(1000, " 1=1 ", " id").Tables[0]; this.ddlMaintenance_Item.Items.Clear(); foreach (DataRow dr in tb1.Rows) { this.ddlMaintenance_Item.Items.Add(new ListItem(dr["Maintenance_Item_Name"].ToString(), dr["Code"].ToString())); } BLL.car_repair_plantbll bll2 = new BLL.car_repair_plantbll(); DataTable tb2 = bll2.GetList(1000, " 1=1 ", " id").Tables[0]; this.ddlRepair_Plant.Items.Clear(); foreach (DataRow dr in tb2.Rows) { this.ddlRepair_Plant.Items.Add(new ListItem(dr["Repair_Plant_Name"].ToString(), dr["Code"].ToString())); } BLL.car_driverbll bll3 = new BLL.car_driverbll(); DataTable tb3 = bll3.GetList(1000, " 1=1 ", " id").Tables[0]; this.ddlDriver_Code.Items.Clear(); foreach (DataRow dr in tb3.Rows) { this.ddlDriver_Code.Items.Add(new ListItem(dr["Driver_Name"].ToString(), dr["Driver_Code"].ToString())); } if (action == DTEnums.ActionEnum.Edit.ToString()) //修改 { ShowInfo(this.id); } } }
private bool DoEdit(int _id) { bool result = true; BLL.carbll bll = new BLL.carbll(); Model.carinfo model = bll.GetModel(_id); model.Car_Number = txtCar_Number.Text.Trim(); model.Car_Name = txtCar_Name.Text; model.Dept_Pros = ddlDept_Pros.SelectedValue; model.Car_Type.Type_Code = ddlCar_Type.SelectedValue; model.Driver.Driver_Code = ddlDriver.SelectedValue; model.Buy_Date = txtBuy_Date.Text; model.Price = Convert.ToDouble(txtPrice.Text.Trim() == "" ? "0" : txtPrice.Text.Trim()); model.Mileage_First = Convert.ToInt32(txtMileage_First.Text.Trim() == "" ? "0" : txtMileage_First.Text.Trim()); //model.Status = Convert.ToInt32(ddlStatus.SelectedValue); model.Oil_Consumption = float.Parse(txtOil_Consumption.Text.Trim() == "" ? "0" : txtOil_Consumption.Text.Trim()); model.Engine_Number = txtEngine_Number.Text; model.Frame_Number = txtFrame_Number.Text; model.Weight = float.Parse(txtWeight.Text.Trim() == "" ? "0" : txtWeight.Text.Trim()); model.Seat = Convert.ToInt32(txtSeat.Text.Trim() == "" ? "0" : txtSeat.Text.Trim()); model.cContent = txtcContent.Text; model.Image1 = Image1.ImageUrl; model.Image2 = Image2.ImageUrl; model.Image1 = model.Image1.Replace("~/", ""); model.Image2 = model.Image2.Replace("~/", ""); string savepath = HttpRuntime.AppDomainAppPath + "upload"; List <string> files = new List <string>(); bool b = ControlCenter.saveFile(savepath, ref files, Request.Files, admin_info.user_name); if (b) { for (int i = 0; i < files.Count; i++) { string s = files[i]; if (s.Contains("FileUpload1")) { model.Image1 = s; Image1.ImageUrl = s; } else if (s.Contains("FileUpload2")) { model.Image2 = s; Image2.ImageUrl = s; } } } if (!bll.Update(model)) { result = false; } return(result); }
//批量删除 protected void btnDelete_Click(object sender, EventArgs e) { ChkAdminLevel("users", DTEnums.ActionEnum.Delete.ToString()); //检查权限 BLL.carbll bll = new BLL.carbll(); 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) { bll.Delete(id); } } JscriptMsg("批量删除成功啦!", Utils.CombUrlTxt("car_use_record_list.aspx", "group_id={0}&keywords={1}", this.group_id.ToString(), this.keywords), "Success"); }
private void AfterStatus() { string strid = StringTrim(Request.Form["id"]); int id = Convert.ToInt32(strid); string strstatus = StringTrim(Request.Form["status"]); ChkAdminLevel("users", DTEnums.ActionEnum.Delete.ToString()); //检查权限 BLL.car_use_recordbll bll = new BLL.car_use_recordbll(); DTcms.Model.car_use_recordinfo record = bll.GetModel(id); int iresult = 0; if (record.Status < 2) { string strupdate = "Status=2,Checker_Code='" + admin_info.user_name + "',Check_Time='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:sss") + "'"; iresult = bll.UpdateField(id, strupdate); } else if (record.Status == 2) { string strupdate = "Status=4,Update_Time='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:sss") + "'"; iresult = bll.UpdateField(id, strupdate); BLL.carbll cbll = new BLL.carbll(); cbll.UpdateField(record.Car.Car_Number, "Status=1"); } //else if (record.Status == 4) //{ // string strupdate = "Status=5,Update_Time='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:sss") + "'"; // iresult = bll.UpdateField(id, strupdate); // BLL.carbll cbll = new BLL.carbll(); // cbll.UpdateField(record.Car.Car_Number, "Status=0"); //} if (iresult > 0) { //JscriptMsg("车辆状态修改成功!", Utils.CombUrlTxt("car_use_record_list.aspx", "group_id={0}&keywords={1}", // this.group_id.ToString(), this.keywords), "Success"); } ResultView view = new ResultView(); view.putData("result", iresult); outResult(view); }
private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); this.txtKeywords.Text = this.keywords; BLL.carbll bll = new BLL.carbll(); DataTable tb = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount).Tables[0]; tb.Columns.Add("StatusText"); for (int i = 0; i < tb.Rows.Count; i++) { int status = Convert.ToInt32(tb.Rows[i]["Status"] + ""); tb.Rows[i]["StatusText"] = GetStatusText(status); } this.rptList.DataSource = tb; this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("car_list.aspx", "group_id={0}&keywords={1}&page={2}", this.group_id.ToString(), this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private bool DoEdit(int _id) { bool result = true; BLL.car_repair_recordbll bll = new BLL.car_repair_recordbll(); Model.car_repair_recordinfo model = bll.GetModel(_id); string strcode = codelist.Value; string strcost = costlist.Value; string[] scodelist = null; string[] scostlist = null; if (strcode.Contains(",")) { scodelist = strcode.Split(new string[] { "," }, StringSplitOptions.None); } else { scodelist = new string[] { strcode }; } if (strcost.Contains(",")) { scostlist = strcost.Split(new string[] { "," }, StringSplitOptions.None); } else { scostlist = new string[] { strcost }; } for (int i = 0; i < scodelist.Length; i++) { car_repair_iteminfo iteminfo = new car_repair_iteminfo(); iteminfo.Code = scodelist[i]; try { iteminfo.Cost = decimal.Parse(scostlist[i]); } catch { } model.Car_Repair_Items.Add(iteminfo); } model.Code = ddlCode.Text; model.Repare_Time_Finish = txtRepare_Time_Finish.Text; try { model.Cost = decimal.Parse(txtCost.Text); } catch { } model.Report = txtReport.Text; int iresult = bll.UpdateField(model.ID, " Repare_Time_Finish='" + model.Repare_Time_Finish + "',Report='" + model.Report + "',Cost=" + model.Cost + ",Status=1"); if (iresult <= 0) { result = false; } else { if (bll.AddItem(model) <= 0) { result = false; } else { BLL.carbll carbl = new BLL.carbll(); carbl.UpdateField(model.Car.Car_Number, " Status=0"); } } return(result); }