private void ShowInfo(int _id) { BLL.car_use_recordbll bll = new BLL.car_use_recordbll(); Model.car_use_recordinfo model = bll.GetModel(_id); txtCode.Text = model.Code; txtUse_Time.Text = model.Use_Time; ddlDept_Code.SelectedValue = model.Department.Dept_Code; ddlUser_Code.SelectedValue = model.User.user_name; ddlCar_Number.SelectedValue = model.Car.Car_Number; ddlDriver_Code.SelectedValue = model.Driver.Driver_Code; txtStart_Address.Text = model.Start_Address; txtMileage_First.Text = model.Mileage_First.ToString(); txtUser_Number.Text = model.User_Number.ToString(); txtUContent.Text = model.UContent; txtEnd_Address.Text = model.End_Address; txtReturn_Time.Text = model.Return_Time; txtConnecter.Text = model.Connecter; txtTel.Text = model.Tel; if (model.OnCity == 1) { Range1.Checked = true; Range2.Checked = false; } else if (model.OnCity == 0) { Range1.Checked = false; Range2.Checked = true; } }
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 RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); this.txtKeywords.Text = this.keywords; BLL.car_use_recordbll bll = new BLL.car_use_recordbll(); DataTable tb = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount).Tables[0]; tb.Columns.Add("StatusText"); tb.Columns.Add("StatusHandleText"); for (int i = 0; i < tb.Rows.Count; i++) { int status = Convert.ToInt32(tb.Rows[i]["Status"] + ""); tb.Rows[i]["StatusText"] = GetStatusText(status); tb.Rows[i]["StatusHandleText"] = GetStatusHandleText(status); } this.rptList.DataSource = tb; this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("car_use_record_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); }
protected void btnCheckOut_Click(object sender, EventArgs e) { ChkAdminLevel("users", DTEnums.ActionEnum.Delete.ToString()); //检查权限 BLL.car_use_recordbll bll = new BLL.car_use_recordbll(); bool bupdate = true; 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) { DTcms.Model.car_use_recordinfo record = bll.GetModel(id); if (record.Status <= 3) { string strupdate = "Status=3,Checker_Code='" + admin_info.user_name + "',Check_Time='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:sss") + "'"; bll.UpdateField(id, strupdate); } else { bupdate = false; } } } if (bupdate) { JscriptMsg("批量审核成功啦!", Utils.CombUrlTxt("car_use_record_list.aspx", "group_id={0}&keywords={1}", this.group_id.ToString(), this.keywords), "Success"); } else { JscriptMsg("这些数据不能批量审核!", Utils.CombUrlTxt("car_use_record_list.aspx", "group_id={0}&keywords={1}", this.group_id.ToString(), this.keywords), "Success"); } }
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_return_recordbll().Exists(this.id)) //{ // JscriptMsg("信息不存在或已被删除!", "back", "Error"); // return; //} } if (!Page.IsPostBack) { //BLL.carbll carbll = new BLL.carbll(); //DataTable cartb = carbll.GetList(1000, "", " id").Tables[0]; //this.ddlCar_Number.Items.Clear(); //foreach (DataRow dr in cartb.Rows) //{ // this.ddlCar_Number.Items.Add(new ListItem(dr["Car_Name"].ToString(), dr["Car_Number"].ToString())); //} BLL.car_use_recordbll carusebll = new BLL.car_use_recordbll(); DataTable carusetb = carusebll.GetList(1000, " Status in(4)", " id").Tables[0]; this.ddlCar_Number.Items.Clear(); this.ddlCar_Number.Items.Add(new ListItem("请选择车牌...", "")); this.ddlSource_Code.Items.Clear(); this.ddlSource_Code.Items.Add(new ListItem("请选择单号...", "")); foreach (DataRow dr in carusetb.Rows) { this.ddlCar_Number.Items.Add(new ListItem(dr["Car_Number"].ToString(), dr["Car_Number"].ToString())); this.ddlSource_Code.Items.Add(new ListItem(dr["Code"].ToString(), dr["Code"].ToString())); } txtCode.Text = System.DateTime.Now.ToString("yyyyMMddHHmmsss"); if (action == DTEnums.ActionEnum.Edit.ToString()) //修改 { ShowInfo(this.id); } } }
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 bool DoEdit(int _id) { bool result = true; BLL.car_use_recordbll bll = new BLL.car_use_recordbll(); Model.car_use_recordinfo model = bll.GetModel(_id); model.Code = txtCode.Text.Trim(); model.Use_Time = txtUse_Time.Text.Trim(); model.Department.Dept_Code = ddlDept_Code.SelectedValue; model.User.user_name = ddlUser_Code.SelectedValue; model.Car.Car_Number = ddlCar_Number.SelectedValue; model.Driver.Driver_Code = ddlDriver_Code.SelectedValue; model.Start_Address = txtStart_Address.Text.Trim(); string s = txtMileage_First.Text.Trim(); model.Mileage_First = Convert.ToInt32(s == "" ? "0" : s); s = txtUser_Number.Text.Trim(); model.User_Number = Convert.ToInt32(s == "" ? "0" : s); model.UContent = txtUContent.Text.Trim(); model.End_Address = txtEnd_Address.Text.Trim(); model.Return_Time = txtReturn_Time.Text.Trim(); model.Connecter = txtConnecter.Text.Trim(); model.Tel = txtTel.Text.Trim(); if (Range1.Checked) { model.OnCity = 1; } else if (Range2.Checked) { model.OnCity = 0; } if (!bll.Update(model)) { result = false; } return(result); }