Exemplo n.º 1
0
    /// <summary>
    /// 修改
    /// </summary>
    /// <param name="car"></param>
    /// <returns></returns>
    public Model.Car_Cars getcheers(ref Model.Car_Cars car)
    {
        Car_Cars cars = CarsManager.GetAllCarsById(Id);

        car.BuyData  = DateTime.Parse(txtBuyDate.Text.ToString());
        car.BuyMoney = Decimal.Parse(txtBuyMoney.Text.ToString());
        car.Buywork  = txtChangJia.Text.ToString();
        car.CarMark  = txtLisence.Text.ToString();
        car.ReMark   = txtRemark.Text.ToString();
        car.State    = ddlState.SelectedValue.ToString();

        car.Seating = Convert.ToInt32(txtSeating.Text);


        if (rdo1.Checked)
        {
            car.Typeid.TypeId = 1;
        }
        if (rdo2.Checked)
        {
            car.Typeid.TypeId = 2;
        }
        if (rdo3.Checked)
        {
            car.Typeid.TypeId = 3;
        }
        if (rdo4.Checked)
        {
            car.Typeid.TypeId = 4;
        }
        return(car);
    }
Exemplo n.º 2
0
    /// <summary>
    /// 删除一条记录
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void gvCars_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName == "del")
        {
            string Id = e.CommandArgument.ToString();
            try
            {
                Car_Cars cars = CarsManager.GetAllCarsById(Convert.ToInt32(Id));

                if (cars.State == "已出车" || cars.State == "维修中")
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('此车不是未出车状态不可删除!');", true);
                }
                else
                {
                    int num = CarsManager.DcseteCars(Id);

                    if (num > 0)
                    {
                        Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除成功!');", true);
                    }
                    gvCars.DataSourceID = null;
                    gvCars.DataSource   = odsCars;
                    gvCars.DataBind();
                }
            }
            catch
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除失败!');", true);
                return;
            }
        }
    }
Exemplo n.º 3
0
        /// <summary>
        /// 根据ID查询车辆信息
        /// </summary>
        /// <param name="Id"></param>
        /// <returns></returns>
        public Car_Cars GetAllCarsById(int Id)
        {
            string sql = "usp_SelcectCarsById";

            using (SqlDataReader reader = DBHelper.ExecuteReaderProc(sql, new SqlParameter("@Id", Id)))
            {
                if (reader.Read())
                {
                    Car_Cars Car = new Car_Cars();
                    Car.Car_Id   = (int)reader["Car_Id"];
                    Car.CarMark  = (string)reader["CarMark"];
                    Car.Seating  = (int)reader["Seating"];
                    Car.Typeid   = carType.GetAllCarsById((int)reader["Typeid"]);
                    Car.BuyData  = (DateTime)reader["BuyData"];
                    Car.BuyMoney = Convert.ToDecimal(reader["BuyMoney"]);
                    Car.Buywork  = (string)reader["Buywork"];
                    Car.State    = (string)reader["State"];
                    Car.ReMark   = (string)reader["ReMark"];

                    return(Car);
                }
                else
                {
                    reader.Close();
                    return(null);
                }
            }
        }
Exemplo n.º 4
0
    /// <summary>
    /// 删除一条记录
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void gvCars_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        //string cmd = e.CommandName;//获取命令名称
        //int Id = Convert.ToInt32(e.CommandArgument);//获取命令参数
        if (e.CommandName == "del")
        {
            string Id = e.CommandArgument.ToString();
            try
            {
                Car_Cars cars = CarsManager.GetAllCarsById(Convert.ToInt32(Id));

                if (cars.State == "已出车" || cars.State == "维修")
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('此车不是未出车状态不可删除!');", true);
                }
                else
                {
                    int num = CarsManager.DcseteCars(Id);

                    if (num > 0)
                    {
                        Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除成功!');", true);
                    }

                    ucpage.PageIndex = 0;
                    ucpage_onPageIndexChanging(ucpage.PageIndex);
                    //gvCars.DataSourceID = null;
                    //gvCars.DataSource = odsCars;
                    //gvCars.DataBind();
                }
            }
            catch
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除失败!');", true);
                return;
            }
        }
        else if (e.CommandName == "weixiou")
        {
            try
            {
                string   Id   = e.CommandArgument.ToString();
                Car_Cars cars = CarsManager.GetAllCarsById(Convert.ToInt32(Id));

                int num = CarsManager.UpadteCarsByIdSate(Convert.ToInt32(Id));
                if (num > 0)
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('修改成功!');", true);
                }
                ucpage.PageIndex = 0;
                ucpage_onPageIndexChanging(ucpage.PageIndex);
            }
            catch
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('维修失败!');", true);
            }
        }
    }
Exemplo n.º 5
0
 /// <summary>
 /// 修改车辆信息
 /// </summary>
 /// <param name="cs"></param>
 /// <returns></returns>
 public static int UpdateCars(Car_Cars cs)
 {
     try
     {
         return(carService.UpdateCars(cs));
     }
     catch (Exception ex)
     {
         throw new Exception(ex.ToString());
     }
 }
Exemplo n.º 6
0
        /// <summary>
        /// 根据状态查看车牌号码
        /// </summary>
        /// <param name="State"></param>
        /// <returns></returns>
        public IList <Car_Cars> SelectCarMarkState(string State)
        {
            string           proName = "usp_SelectCarMarkState";
            DataTable        tb      = DBHelper.GetDataTableProc(proName, new SqlParameter("@State", State));
            IList <Car_Cars> list    = new List <Car_Cars>();

            foreach (DataRow r in tb.Rows)
            {
                Car_Cars car = new Car_Cars();
                car.CarMark = (string)r["CarMark"];
                list.Add(car);
            }
            return(list);
        }
Exemplo n.º 7
0
    /// <summary>
    /// 删除车辆
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnDelete_Click1(object sender, EventArgs e)
    {
        CheckBox   chckbx      = null;
        LinkButton lkbtnDelete = null;
        string     Id          = "";

        for (int i = 0; i < this.gvCars.Rows.Count; i++)
        {
            chckbx      = this.gvCars.Rows[i].FindControl("chSelect") as CheckBox;
            lkbtnDelete = this.gvCars.Rows[i].FindControl("lnkdel") as LinkButton;
            if (chckbx.Checked)
            {
                string Id1 = lkbtnDelete.CommandArgument.ToString();
                Id += Id1 + ",";
            }
        }
        if (Id != "")
        {
            try
            {
                Id = Id.Substring(0, Id.Length - 1);
                Car_Cars cars = CarsManager.GetAllCarsById(Convert.ToInt32(Id));

                if (cars.State == "已出车" || cars.State == "维修中")
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('此车不是未出车状态不可删除!');", true);
                }
                else
                {
                    CarsManager.DcseteCars(Id);
                    gvCars.DataSourceID = null;
                    gvCars.DataSource   = CarsManager.SelectCarsDark(txtDept.Text, drlCarType.SelectedValue, drlCarStae.SelectedValue);
                    gvCars.DataBind();
                }
            }
            catch
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除失败!');", true);
                return;
            }
        }
        else
        {
            Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('请选择要删除的项!');", true);
        }
    }
Exemplo n.º 8
0
        /// <summary>
        /// 添加车辆
        /// </summary>
        /// <param name="cs"></param>
        /// <returns></returns>
        public int InsertCars(Car_Cars cs)
        {
            SqlParameter[] para = new SqlParameter[]
            {
                new SqlParameter("@BuyData", cs.BuyData),
                new SqlParameter("@BuyMoney", cs.BuyMoney),
                new SqlParameter("@Buywork", cs.Buywork),
                new SqlParameter("@CarMark", cs.CarMark),
                new SqlParameter("@ReMark", cs.ReMark),
                new SqlParameter("@State", cs.State),
                new SqlParameter("@Typeid", cs.Typeid.TypeId),
                new SqlParameter("@seating", cs.Seating)
            };
            int num = DBHelper.ExecuteNonQueryProc("usp_AddCars", para);

            return(num);
        }
Exemplo n.º 9
0
        public List <Car_Cars> GetCars(SqlDataReader reader)
        {
            List <Car_Cars> list = new List <Car_Cars>();

            while (reader.Read())
            {
                Car_Cars Car = new Car_Cars();
                Car.Car_Id   = (int)reader["Car_Id"];
                Car.CarMark  = (string)reader["CarMark"];
                Car.Seating  = (int)reader["Seating"];
                Car.Typeid   = carType.GetAllCarsById((int)reader["Typeid"]);
                Car.BuyData  = (DateTime)reader["BuyData"];
                Car.BuyMoney = Convert.ToDecimal(reader["BuyMoney"]);
                Car.Buywork  = (string)reader["Buywork"];
                Car.State    = (string)reader["State"];
                Car.ReMark   = (string)reader["ReMark"];
                list.Add(Car);
            }
            return(list);
        }
Exemplo n.º 10
0
    /// <summary>
    /// 光棒效果
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void gvCars_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            HiddenField CarId = e.Row.FindControl("lblWei") as HiddenField;

            Car_Cars cars = CarsManager.GetAllCarsById(Convert.ToInt32(CarId.Value));

            if (cars.State == "已出车" || cars.State == "维修")
            {
                LinkButton lbReturn = e.Row.FindControl("lbSend") as LinkButton;
                LinkButton lndel    = e.Row.FindControl("lbDel") as LinkButton;
                lbReturn.Enabled = false;
                lndel.Enabled    = false;
            }
            //设置行颜色
            e.Row.Attributes.Add("onmouseover", "currentcolor=this.style.backgroundColor;this.style.backgroundColor='#ff9900'");
            e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=currentcolor");
        }
    }
Exemplo n.º 11
0
    protected void ddlCarMark_SelectedIndexChanged(object sender, EventArgs e)
    {
        string name = "0";

        name = Request.QueryString["DR_name"];
        int id = Convert.ToInt32(ddlCarMark.SelectedValue);

        if (id != 0)
        {
            Car_Cars car     = CarsManager.GetAllCarsById(id);
            Car_Type cartype = (Car_Type)CarTypeManager.GetAllCarsById(car.Typeid.TypeId);
            rblDR_CarType.SelectedValue = cartype.Genre;
            if (name == "Up")
            {
                rblDR_CarType.Enabled = false;
            }
        }
        else
        {
            rblDR_CarType.SelectedValue = "普通用车";
        }
    }
Exemplo n.º 12
0
        /// <summary>
        /// 查询所有车辆信息
        /// </summary>
        /// <returns></returns>
        public IList <Car_Cars> GetAllCars()
        {
            string           cars = "usp_SelcectCas";
            DataTable        tb   = DBHelper.GetDataTableProc(cars, null);
            IList <Car_Cars> list = new List <Car_Cars>();

            foreach (DataRow r in tb.Rows)
            {
                Car_Cars Car = new Car_Cars();
                Car.Car_Id   = (int)r["Car_Id"];
                Car.CarMark  = (string)r["CarMark"];
                Car.Seating  = (int)r["Seating"];
                Car.Typeid   = carType.GetAllCarsById((int)r["Typeid"]);
                Car.BuyData  = (DateTime)r["BuyData"];
                Car.BuyMoney = Convert.ToDecimal(r["BuyMoney"]);
                Car.Buywork  = (string)r["Buywork"];
                Car.State    = (string)r["State"];
                Car.ReMark   = (string)r["ReMark"];
                list.Add(Car);
            }
            return(list);
        }
Exemplo n.º 13
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        try
        {
            string name = "0";
            name = Request.QueryString["S_name"];
            Services se = new Services();
            se.S_Id = Convert.ToInt32(Request.QueryString["S_Id"]);
            if (ddlS_Branch.SelectedItem.Text.Trim() == "请选择")
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('温馨提示:请选择正确的部门!');", true);
                return;
            }
            else
            {
                se.S_Branch = ddlS_Branch.SelectedItem.Text.Trim();
            }
            if (ddlJerquePeople.SelectedValue.Trim() == "")
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('温馨提示:该部门没人,请选择其它部门!');", true);
                return;
            }
            else
            {
                se.JerquePeople = ddlJerquePeople.SelectedItem.Text.Trim();
            }

            se.BeginDate = Convert.ToDateTime(txtBeginDate.Value);
            se.EndDate   = Convert.ToDateTime(txtEndDate.Value);
            if (se.BeginDate >= se.EndDate)
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('温馨提示:进厂日期必须大于出厂日期!');", true);
                return;
            }
            if (ddlCarMark.SelectedItem.Text.Trim() == "请选择")
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('温馨提示:请选择正确的车牌号!');", true);
                return;
            }
            else
            {
                se.CarMark = ddlCarMark.SelectedItem.Text.Trim();
            }

            //图片上传判断
            string FileName = "";
            if (fuBillPhoto.PostedFile != null)
            {
                FileName = System.IO.Path.GetFileName(fuBillPhoto.PostedFile.FileName).ToLower();
                if (FileName == "")
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('清单照片不能为空!');", true);
                    return;
                }
                fuBillPhoto.PostedFile.SaveAs(Server.MapPath("~/images/UpLoad/" + FileName));
                se.BillPhoto = "~/images/UpLoad/" + FileName;
            }
            else
            {
                se.BillPhoto = image.ImageUrl;
            }
            image.ImageUrl = se.BillPhoto;

            se.CarType  = rblCarType.SelectedValue.Trim();
            se.S_Reason = Server.HtmlDecode(txtS_Reason.Text.Trim());

            se.S_Cost        = Convert.ToDouble(txtS_Cost.Text.Trim());
            se.S_FactoryName = txtS_FactoryName.Text.Trim();
            se.S_People      = ddlS_People.SelectedItem.Text.Trim();
            se.S_Result      = Server.HtmlDecode(txtS_Result.Text.Trim());
            se.S_Type        = ddlS_Type.SelectedValue;
            se.UseCost       = Convert.ToDouble(txtUseCost.Text.Trim());
            if (name == "Up")
            {
                int result = ServicesManager.updateService(se);
                if (result != 0)
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新成功!');window.location.href='Servicelist.aspx'", true);
                }
                else
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新失败!');", true);

                    return;
                }
            }
            else
            {
                int result = ServicesManager.addService(se);
                if (result != 0)
                {
                    int      id  = Convert.ToInt32(ddlCarMark.SelectedItem.Value);
                    Car_Cars car = CarsManager.GetAllCarsById(id);
                    car.State  = "未出车";
                    car.Car_Id = id;
                    CarsManager.UpdateCars(car);
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "温馨提示:", "alert('添加成功!');window.location.href='Servicelist.aspx'", true);
                }
                else
                {
                    Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加失败!');", true);

                    return;
                }
            }
        }
        catch (Exception ex)
        {
            throw new Exception(ex.ToString());
        }
    }
Exemplo n.º 14
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        string name = "0";

        name = Request.QueryString["S_name"];
        Services se = new Services();

        se.S_Id      = Convert.ToInt32(Request.QueryString["S_Id"]);
        se.BeginDate = Convert.ToDateTime(txtBeginDate.Value);

        string FileName = System.IO.Path.GetFileName(fuBillPhoto.PostedFile.FileName).ToLower();

        if (!string.IsNullOrEmpty(FileName))
        {
            fuBillPhoto.PostedFile.SaveAs(Server.MapPath("~/images/UpLoad/" + FileName));
            se.BillPhoto = "~/images/UpLoad/" + FileName;
        }
        else
        {
            se.BillPhoto = "";
        }
        image.ImageUrl   = se.BillPhoto;
        se.CarMark       = ddlCarMark.SelectedItem.Text;
        se.CarType       = rblCarType.SelectedValue;
        se.S_Reason      = txtS_Reason.Text;
        se.EndDate       = Convert.ToDateTime(txtEndDate.Value);
        se.JerquePeople  = ddlJerquePeople.SelectedItem.Text;
        se.S_Branch      = ddlS_Branch.SelectedItem.Text;
        se.S_Cost        = Convert.ToDouble(txtS_Cost.Text);
        se.S_FactoryName = txtS_FactoryName.Text;
        se.S_People      = ddlS_People.SelectedItem.Text;
        se.S_Result      = txtS_Result.Text;
        se.S_Type        = ddlS_Type.SelectedValue;
        se.UseCost       = Convert.ToDouble(txtUseCost.Text);
        if (name == "Up")
        {
            int result = ServicesManager.updateService(se);
            if (result != 0)
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新成功!');window.location.href='Servicelist.aspx'", true);
            }
            else
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('更新失败!');", true);

                return;
            }
        }
        else
        {
            int result = ServicesManager.addService(se);
            if (result != 0)
            {
                int      id  = Convert.ToInt32(ddlCarMark.SelectedItem.Value);
                Car_Cars car = CarsManager.GetAllCarsById(id);
                car.State  = "未出车";
                car.Car_Id = id;
                CarsManager.UpdateCars(car);
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加成功!');window.location.href='Servicelist.aspx'", true);
            }
            else
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加失败!');", true);

                return;
            }
        }
    }