Ejemplo n.º 1
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public Maticsoft.Model.Replacement DataRowToModel(DataRow row)
 {
     Maticsoft.Model.Replacement model = new Maticsoft.Model.Replacement();
     if (row != null)
     {
         if (row["ReplacementID"] != null)
         {
             model.ReplacementID = row["ReplacementID"].ToString();
         }
         if (row["MachineFatherID"] != null)
         {
             model.MachineFatherID = row["MachineFatherID"].ToString();
         }
         if (row["MachineSonID"] != null)
         {
             model.MachineSonID = row["MachineSonID"].ToString();
         }
         if (row["ReplacementModel"] != null)
         {
             model.ReplacementModel = row["ReplacementModel"].ToString();
         }
         if (row["ReplacementName"] != null)
         {
             model.ReplacementName = row["ReplacementName"].ToString();
         }
         if (row["ReplacementState"] != null)
         {
             model.ReplacementState = row["ReplacementState"].ToString();
         }
         if (row["ReplacementPicture"] != null)
         {
             model.ReplacementPicture = row["ReplacementPicture"].ToString();
         }
         if (row["ReplacementAddTime"] != null && row["ReplacementAddTime"].ToString() != "")
         {
             model.ReplacementAddTime = DateTime.Parse(row["ReplacementAddTime"].ToString());
         }
         if (row["FFF1"] != null)
         {
             model.FFF1 = row["FFF1"].ToString();
         }
         if (row["FFF2"] != null)
         {
             model.FFF2 = row["FFF2"].ToString();
         }
         if (row["FFF3"] != null)
         {
             model.FFF3 = row["FFF3"].ToString();
         }
         if (row["FFF4"] != null)
         {
             model.FFF4 = row["FFF4"].ToString();
         }
         if (row["FFF5"] != null)
         {
             model.FFF5 = row["FFF5"].ToString();
         }
     }
     return(model);
 }
Ejemplo n.º 2
0
        protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
        {
            string id = e.CommandArgument.ToString();

            Maticsoft.Model.Replacement molr = bllr.GetModel(id);


            if (e.CommandName.ToString() == "Delete")
            {
                if (molr.ReplacementState == "已借出")
                {
                    RadAjaxManager1.Alert("已借出状态下不可删除!");
                    return;
                }
                if (bllrr.GetRecordCount(" ReplacementID =  '" + id + "' ") != 0)
                {
                    RadAjaxManager1.Alert("已存在借出历史,不可删除!");
                    return;
                }
                if (molr.ReplacementState == "未借出" || molr.ReplacementState == "已报废")
                {
                    bllr.Delete(id);
                    RadGrid1.Rebind();
                }
            }

            if (e.CommandName.ToString() == "GOGO")
            {
                Response.Redirect("SubstitutionDetails.aspx?ID=" + e.CommandArgument + "");//跳转页面
            }
        }
Ejemplo n.º 3
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!IsPostBack)
     {
         if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
         {
             Maticsoft.Model.Replacement molr = bllr.GetModel(Request.QueryString["ID"].ToString());//引用id所在行的数据
             if (molr == null)
             {
                 Response.Write("<script>window.location.href='../BackLogin.aspx'</script>");
             }
         }
     }
 }
Ejemplo n.º 4
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public Maticsoft.Model.Replacement GetModel(string ReplacementID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1  ");
            strSql.Append(" ReplacementID,MachineFatherID,MachineSonID,ReplacementModel,ReplacementName,ReplacementState,ReplacementPicture,ReplacementAddTime,FFF1,FFF2,FFF3,FFF4,FFF5 ");
            strSql.Append(" from Replacement ");
            strSql.Append(" where ReplacementID='" + ReplacementID + "' ");
            Maticsoft.Model.Replacement model = new Maticsoft.Model.Replacement();
            DataSet ds = DbHelperSQL.Query(strSql.ToString());

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 5
0
        /*
         */
        public Maticsoft.Model.Replacement GetModelJYF(string ReplacementID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1  ");
            strSql.Append(" * ");
            strSql.Append(" from Replacement a,Declaration b ");
            strSql.Append(" where b.ReplacementID='" + ReplacementID + "' and a.ReplacementID = b.ReplacementID  ");
            Maticsoft.Model.Replacement model = new Maticsoft.Model.Replacement();
            DataSet ds = DbHelperSQL.Query(strSql.ToString());

            if (ds.Tables[0].Rows.Count > 0)
            {
                return(DataRowToModel(ds.Tables[0].Rows[0]));
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 6
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
                {
                    Maticsoft.Model.Replacement molr = bllr.GetModel(Request.QueryString["ID"].ToString());//引用id所在行的数据
                    if (molr == null)
                    {
                        Response.Write("<script>window.location.href='~/BackLogin.aspx'</script>");
                    }

                    Maticsoft.Model.MachineFatherType molmf = bllmf.GetModel(molr.MachineFatherID);
                    Maticsoft.Model.MachineSonType    molms = bllms.GetModel(molr.MachineSonID);

                    Label1.Text = molr.ReplacementID;
                    Label2.Text = molr.ReplacementModel;
                    Label3.Text = molr.ReplacementName;
                    Label4.Text = molmf.MachineFatherName + "-" + molms.MachineSonName;
                    Label5.Text = molr.ReplacementState;
                    Label6.Text = molr.ReplacementAddTime.ToString();

                    string st = molr.ReplacementPicture;

                    string[] sop = st.Split(';');

                    ImgList.Clear();

                    for (int i = 0; i < sop.Length - 1; i++)
                    {
                        ImgModel img = new ImgModel();
                        img.ID     = ImgList.Count + 1;
                        img.imgUrl = sop[i];
                        ImgList.Add(img);
                        RadListView1.Rebind();
                    }
                }
            }
        }
Ejemplo n.º 7
0
        protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
        {
            string id = e.CommandArgument.ToString();

            if (e.CommandName == "Chanel")
            {
                Response.Redirect("RepairEdit.aspx?ID=" + e.CommandArgument + "");//跳转修改页面
            }
            if (e.CommandName == "UP")
            {
                Declaration_Mol = Declaration_Bll.GetModel(e.CommandArgument.ToString());
                Declaration_Mol.DeclarationState = "装备中心待受理";
                Declaration_Bll.Update(Declaration_Mol);
                DataLoad();
                RadGrid1.Rebind();
            }
            if (e.CommandName == "Return")
            {
                Declaration_Mol = Declaration_Bll.GetModel(e.CommandArgument.ToString());
                Declaration_Mol.DeclarationState = "未上报";
                Declaration_Bll.Update(Declaration_Mol);
                DataLoad();
                RadGrid1.Rebind();
            }
            if (e.CommandName == "CheckOK")
            {
                Declaration_Mol = Declaration_Bll.GetModel(e.CommandArgument.ToString());
                Declaration_Mol.DeclarationState = "维修完成";
                Declaration_Bll.Update(Declaration_Mol);
                DataLoad();
                RadGrid1.Rebind();
            }
            if (e.CommandName == "CheckBack")
            {
                Declaration_Mol = Declaration_Bll.GetModel(e.CommandArgument.ToString());
                Replacement_Mol = Replacement_Bll.GetModelJYF(Declaration_Mol.ReplacementID);
                if (Declaration_Mol.ReplacementUse != "否")
                {
                    Replacement_Mol.ReplacementState = "未借出";
                    Replacement_Bll.Update(Replacement_Mol);
                    ReplacementRecord_Mol = ReplacementRecord_Bll.GetModelJYF2(Declaration_Mol.ReplacementID);
                    ReplacementRecord_Mol.ReplacementBackTime = DateTime.Now;
                    ReplacementRecord_Bll.Update(ReplacementRecord_Mol);
                }


                Declaration_Mol.DeclarationState = "报修单位已取回";
                Declaration_Bll.Update(Declaration_Mol);
                DataLoad();
                RadGrid1.Rebind();
            }
            if (e.CommandName == "Repair2")
            {
                Lable_xxx.Text = e.CommandArgument.ToString();
                //Response.Redirect("RepairBackAdd.aspx?ID=" + e.CommandArgument + "");
            }
            if (e.CommandName == "CheckRepair2Back")
            {
                Declaration_Mol = Declaration_Bll.GetModel(e.CommandArgument.ToString());
                Replacement_Mol = Replacement_Bll.GetModelJYF(Declaration_Mol.ReplacementID);
                if (Declaration_Mol.ReplacementUse != "否")
                {
                    Replacement_Mol.ReplacementState = "未借出";
                    Replacement_Bll.Update(Replacement_Mol);
                    ReplacementRecord_Mol.ReplacementBackTime = DateTime.Now;
                    ReplacementRecord_Bll.Update(ReplacementRecord_Mol);
                }
                Declaration_Mol.DeclarationState = "报修单位已取回(返修)";
                Declaration_Bll.Update(Declaration_Mol);
                DataLoad();
                RadGrid1.Rebind();
            }
            if (e.CommandName == "CheckRepair2OK")
            {
                Declaration_Mol = Declaration_Bll.GetModel(e.CommandArgument.ToString());
                Declaration_Mol.DeclarationState = "返修完成";
                Declaration_Bll.Update(Declaration_Mol);
                DataLoad();
                RadGrid1.Rebind();
            }
            if (e.CommandName == "Down")
            {
                Response.Redirect("RepairReport.aspx?ID=" + e.CommandArgument + "");//跳转报表页面
            }
        }
Ejemplo n.º 8
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool Add(Maticsoft.Model.Replacement model)
        {
            StringBuilder strSql  = new StringBuilder();
            StringBuilder strSql1 = new StringBuilder();
            StringBuilder strSql2 = new StringBuilder();

            if (model.ReplacementID != null)
            {
                strSql1.Append("ReplacementID,");
                strSql2.Append("'" + model.ReplacementID + "',");
            }
            if (model.MachineFatherID != null)
            {
                strSql1.Append("MachineFatherID,");
                strSql2.Append("'" + model.MachineFatherID + "',");
            }
            if (model.MachineSonID != null)
            {
                strSql1.Append("MachineSonID,");
                strSql2.Append("'" + model.MachineSonID + "',");
            }
            if (model.ReplacementModel != null)
            {
                strSql1.Append("ReplacementModel,");
                strSql2.Append("'" + model.ReplacementModel + "',");
            }
            if (model.ReplacementName != null)
            {
                strSql1.Append("ReplacementName,");
                strSql2.Append("'" + model.ReplacementName + "',");
            }
            if (model.ReplacementState != null)
            {
                strSql1.Append("ReplacementState,");
                strSql2.Append("'" + model.ReplacementState + "',");
            }
            if (model.ReplacementPicture != null)
            {
                strSql1.Append("ReplacementPicture,");
                strSql2.Append("'" + model.ReplacementPicture + "',");
            }
            if (model.ReplacementAddTime != null)
            {
                strSql1.Append("ReplacementAddTime,");
                strSql2.Append("'" + model.ReplacementAddTime + "',");
            }
            if (model.FFF1 != null)
            {
                strSql1.Append("FFF1,");
                strSql2.Append("'" + model.FFF1 + "',");
            }
            if (model.FFF2 != null)
            {
                strSql1.Append("FFF2,");
                strSql2.Append("'" + model.FFF2 + "',");
            }
            if (model.FFF3 != null)
            {
                strSql1.Append("FFF3,");
                strSql2.Append("'" + model.FFF3 + "',");
            }
            if (model.FFF4 != null)
            {
                strSql1.Append("FFF4,");
                strSql2.Append("'" + model.FFF4 + "',");
            }
            if (model.FFF5 != null)
            {
                strSql1.Append("FFF5,");
                strSql2.Append("'" + model.FFF5 + "',");
            }
            strSql.Append("insert into Replacement(");
            strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
            strSql.Append(")");
            strSql.Append(" values (");
            strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
            strSql.Append(")");
            int rows = DbHelperSQL.ExecuteSql(strSql.ToString());

            if (rows > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Ejemplo n.º 9
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(Maticsoft.Model.Replacement model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Replacement set ");
            if (model.MachineFatherID != null)
            {
                strSql.Append("MachineFatherID='" + model.MachineFatherID + "',");
            }
            else
            {
                strSql.Append("MachineFatherID= null ,");
            }
            if (model.MachineSonID != null)
            {
                strSql.Append("MachineSonID='" + model.MachineSonID + "',");
            }
            else
            {
                strSql.Append("MachineSonID= null ,");
            }
            if (model.ReplacementModel != null)
            {
                strSql.Append("ReplacementModel='" + model.ReplacementModel + "',");
            }
            else
            {
                strSql.Append("ReplacementModel= null ,");
            }
            if (model.ReplacementName != null)
            {
                strSql.Append("ReplacementName='" + model.ReplacementName + "',");
            }
            else
            {
                strSql.Append("ReplacementName= null ,");
            }
            if (model.ReplacementState != null)
            {
                strSql.Append("ReplacementState='" + model.ReplacementState + "',");
            }
            else
            {
                strSql.Append("ReplacementState= null ,");
            }
            if (model.ReplacementPicture != null)
            {
                strSql.Append("ReplacementPicture='" + model.ReplacementPicture + "',");
            }
            else
            {
                strSql.Append("ReplacementPicture= null ,");
            }
            if (model.ReplacementAddTime != null)
            {
                strSql.Append("ReplacementAddTime='" + model.ReplacementAddTime + "',");
            }
            else
            {
                strSql.Append("ReplacementAddTime= null ,");
            }
            if (model.FFF1 != null)
            {
                strSql.Append("FFF1='" + model.FFF1 + "',");
            }
            else
            {
                strSql.Append("FFF1= null ,");
            }
            if (model.FFF2 != null)
            {
                strSql.Append("FFF2='" + model.FFF2 + "',");
            }
            else
            {
                strSql.Append("FFF2= null ,");
            }
            if (model.FFF3 != null)
            {
                strSql.Append("FFF3='" + model.FFF3 + "',");
            }
            else
            {
                strSql.Append("FFF3= null ,");
            }
            if (model.FFF4 != null)
            {
                strSql.Append("FFF4='" + model.FFF4 + "',");
            }
            else
            {
                strSql.Append("FFF4= null ,");
            }
            if (model.FFF5 != null)
            {
                strSql.Append("FFF5='" + model.FFF5 + "',");
            }
            else
            {
                strSql.Append("FFF5= null ,");
            }
            int n = strSql.ToString().LastIndexOf(",");

            strSql.Remove(n, 1);
            strSql.Append(" where ReplacementID='" + model.ReplacementID + "' ");
            int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString());

            if (rowsAffected > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Ejemplo n.º 10
0
        protected void RadButton2_Click(object sender, EventArgs e)
        {
            DeclarationModel = DeclarationBLL.GetModel(Request["id"].ToString());//获取相对应ID的值
            ReplacementModel = ReplacementBLL.GetModel(DropDownList1.SelectedValue);
            string search1  = TextBox2.Text;
            string xxdz1    = TextBox2.Text.Trim();                                                           //删除空格
            Regex  pattern1 = new Regex("[%--`~!@#$^&*()=|{}':;',\\[\\].<>/?~!@#¥……&*()——|{}【】‘;:”“'。,、? ]"); //判断特殊字符

            if (Label10.Text == "是")                                                                          //如果申请使用代用机
            {
                if (RadioButton2.Checked == true)                                                             //如果为装备中心修理
                {
                    //判断是否为空,是否含有特殊字符
                    if (String.IsNullOrEmpty(DropDownList1.SelectedItem.Text.Trim()))
                    {
                        RadAjaxManager1.Alert("请输入代用机编号");
                    }
                    else if (String.IsNullOrEmpty(TextBox2.Text))
                    {
                        RadAjaxManager1.Alert("请输入设备描述");
                    }
                    else if (String.IsNullOrEmpty(TextBox3.Text))
                    {
                        RadAjaxManager1.Alert("请输入故障预判");
                    }
                    else if (String.IsNullOrEmpty(RadDatePicker1.SelectedDate.ToString()))
                    {
                        RadAjaxManager1.Alert("请输入完修时间");
                    }
                    else if ((pattern1.IsMatch(xxdz1) == true))
                    {
                        RadAjaxManager1.Alert("请不要输入特殊字符");
                    }
                    else if (RadDatePicker1.SelectedDate < DateTime.Now)
                    {
                        RadAjaxManager1.Alert("完修时间不能小于当前时间");
                    }

                    //还少判断设备描述的特殊字符、完修时间不能小于当前时间
                    else
                    {
                        //将输入框的值传入数据库并进行跳转
                        DeclarationModel.ReplacementID = DropDownList1.SelectedValue;

                        DeclarationModel.DeviceDescription = TextBox2.Text;
                        DeclarationModel.FaultPrediction   = TextBox3.Text;
                        DeclarationModel.EstimateTime      = RadDatePicker1.SelectedDate;
                        DeclarationModel.DeclarationState  = "装备中心维修中";
                        DeclarationModel.ListID            = Label1.Text;
                        DeclarationModel.RepairerName      = UsersInfo.UserName;
                        DeclarationModel.RepairerID        = UsersInfo.UserID;
                        DeclarationBLL.Update(DeclarationModel);
                        //这边add上面的四个内容
                        ReplacementRecordModel.UserID = DeclarationModel.UserID;
                        ReplacementRecordModel.ReplacementLendTime = DateTime.Now;
                        ReplacementRecordModel.ReplacementID       = ReplacementModel.ReplacementID;
                        ReplacementRecordModel.ReplacementRecordID = DateTime.Now.ToString("yyyyMMddHHmmssms");
                        ReplacementRecordModel.ReplacementName     = ReplacementModel.ReplacementName;
                        ReplacementRecordBLL.Add(ReplacementRecordModel);

                        ReplacementModel.ReplacementState = "已借出";
                        ReplacementBLL.Update(ReplacementModel);
                        //add代用机使用记录添加用户,使用时间
                        //代用机状态为已借出
                        RadAjaxManager1.Redirect("RepairManagementZB.aspx");
                    }
                }
                else
                {
                    if (String.IsNullOrEmpty(DropDownList1.SelectedItem.Text.Trim()))
                    {
                        RadAjaxManager1.Alert("请输入代用机编号");
                    }
                    else if (RadioButton1.Checked == true)//如果是建议报废
                    {
                        DeclarationModel.DeclarationState = "建议报废";
                        DeclarationModel.RepairerName     = UsersInfo.UserName;
                        DeclarationModel.RepairerID       = UsersInfo.UserID;
                        DeclarationModel.ListID           = Label1.Text; //填写故障现象
                        DeclarationBLL.Update(DeclarationModel);         //更新数据
                        RadAjaxManager1.Redirect("RepairManagementZB.aspx");
                        //update状态为建议报废
                    }
                    else if (RadioButton3.Checked == true)//如果是维修基地修理
                    {
                        DeclarationModel.DeclarationState = "维修基地待受理";
                        DeclarationModel.ListID           = Label1.Text; //填写故障现象
                        DeclarationBLL.Update(DeclarationModel);         //更新数据
                        ReplacementRecordModel.UserID = DeclarationModel.UserID;
                        ReplacementRecordModel.ReplacementLendTime = DateTime.Now;
                        ReplacementRecordModel.ReplacementID       = ReplacementModel.ReplacementID;
                        ReplacementRecordModel.ReplacementRecordID = DateTime.Now.ToString("yyyyMMddHHmmssms");
                        ReplacementRecordModel.ReplacementName     = ReplacementModel.ReplacementName;
                        ReplacementRecordBLL.Add(ReplacementRecordModel);

                        ReplacementModel.ReplacementState = "已借出";
                        ReplacementBLL.Update(ReplacementModel);
                        RadAjaxManager1.Redirect("RepairManagementZB.aspx");
                        //update状态为维修中心待受理
                    }
                }
            }
            else
            {
                if (RadioButton2.Checked == true)//如果为装备中心修理
                {
                    //判断输入框是否为空,含有特殊字符

                    if (String.IsNullOrEmpty(TextBox2.Text))
                    {
                        RadAjaxManager1.Alert("请输入设备描述");
                    }
                    else if (String.IsNullOrEmpty(TextBox3.Text))
                    {
                        RadAjaxManager1.Alert("请输入故障预判");
                    }
                    else if (String.IsNullOrEmpty(RadDatePicker1.SelectedDate.ToString()))
                    {
                        RadAjaxManager1.Alert("请输入完修时间");
                    }
                    else if ((pattern1.IsMatch(xxdz1) == true))
                    {
                        RadAjaxManager1.Alert("请不要输入特殊字符");
                    }
                    else if (Convert.ToDateTime(RadDatePicker1.SelectedDate.Value.ToString("yyyy-MM-dd")) < Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")))
                    {
                        RadAjaxManager1.Alert("完修时间不能小于当前时间");
                    }
                    //还少判断设备描述的特殊字符、完修时间不能小于当前时间
                    else
                    {
                        //将输入框的数据添加到数据库
                        DeclarationModel.DeviceDescription = TextBox2.Text;
                        DeclarationModel.FaultPrediction   = TextBox3.Text;
                        DeclarationModel.EstimateTime      = RadDatePicker1.SelectedDate;
                        DeclarationModel.DeclarationState  = "装备中心维修中";
                        DeclarationModel.ListID            = Label1.Text;
                        DeclarationModel.RepairerName      = UsersInfo.UserName;
                        DeclarationModel.RepairerID        = UsersInfo.UserID;
                        DeclarationBLL.Update(DeclarationModel);//更新数据
                        //这边add上面的四个内容

                        RadAjaxManager1.Redirect("RepairManagementZB.aspx");//跳转页面
                    }
                }
                else
                {
                    if (RadioButton1.Checked == true)//如果是建议报废
                    {
                        DeclarationModel.DeclarationState = "建议报废";
                        DeclarationModel.RepairerName     = UsersInfo.UserName;
                        DeclarationModel.ListID           = Label1.Text;     //填写故障现象
                        DeclarationModel.RepairerID       = UsersInfo.UserID;
                        DeclarationBLL.Update(DeclarationModel);             //更新数据
                        RadAjaxManager1.Redirect("RepairManagementZB.aspx"); //跳转页面
                        //update状态为建议报废
                    }
                    else if (RadioButton3.Checked == true)//如果是维修基地修理
                    {
                        DeclarationModel.DeclarationState = "维修基地待受理";
                        DeclarationModel.ListID           = Label1.Text;     //填写单号
                        DeclarationBLL.Update(DeclarationModel);             //更新数据
                        RadAjaxManager1.Redirect("RepairManagementZB.aspx"); //跳转页面
                        //update状态为维修中心待受理
                    }
                }
            }
        }
Ejemplo n.º 11
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (!string.IsNullOrEmpty(Request.QueryString["ID"]))
                {
                    Maticsoft.Model.Replacement molr = bllr.GetModel(Request.QueryString["ID"].ToString());//引用id所在行的数据

                    if (molr.ReplacementState == "已借出")
                    {
                        Response.Write("<script>alert('已借出,无法修改!');window.location.href='SubstituteMachine.aspx'</script>");
                        return;
                    }
                    if (molr.ReplacementState == "已报废")
                    {
                        Response.Write("<script>alert('已报废,无法修改!');window.location.href='SubstituteMachine.aspx'</script>");
                        return;
                    }

                    if (molr == null)
                    {
                        Response.Write("<script>window.location.href='~/BackLogin.aspx'</script>");
                    }

                    MachineFather.Items.Clear();
                    MachineSon.Items.Clear();
                    MachineFather.Items.Add("请选择...");
                    MachineSon.Items.Add("请选择...");

                    MachineFather.DataSource     = bllmf.GetList("");
                    MachineFather.DataTextField  = "MachineFatherName";
                    MachineFather.DataValueField = "MachineFatherID";
                    MachineFather.DataBind();

                    MachineSon.DataSource     = bllms.GetList(" MachineFatherID ='" + MachineFather.SelectedValue + "'  ");
                    MachineSon.DataTextField  = "MachineSonName";
                    MachineSon.DataValueField = "MachineSonID";
                    MachineSon.DataBind();

                    Maticsoft.Model.MachineFatherType molmf = bllmf.GetModel(molr.MachineFatherID);
                    Maticsoft.Model.MachineSonType    molms = bllms.GetModel(molr.MachineSonID);

                    ReplacementName.Text        = molr.ReplacementName;
                    ReplacementModel.Text       = molr.ReplacementModel;
                    MachineFather.SelectedValue = molmf.MachineFatherID;

                    MachineSon.Items.Clear();       //清子类下拉框项目
                    MachineSon.Items.Add("请选择..."); //给市下拉框添加请选择
                    MachineSon.DataSource     = bllms.GetList(" MachineFatherID ='" + MachineFather.SelectedValue + "'  ");
                    MachineSon.DataTextField  = "MachineSonName";
                    MachineSon.DataValueField = "MachineSonID";
                    MachineSon.DataBind();

                    MachineSon.SelectedValue = molms.MachineSonID;
                    //DropDownList1.SelectedValue = molr.ReplacementState;

                    string st = molr.ReplacementPicture;

                    string[] sop = st.Split(';');

                    ImgList.Clear();

                    for (int i = 0; i < sop.Length - 1; i++)        //修改图片显示
                    {
                        ImgModel img = new ImgModel();
                        img.ID     = ImgList.Count + 1;
                        img.imgUrl = sop[i];
                        ImgList.Add(img);
                        RadListView1.Rebind();
                    }

                    //imgPic.ImageUrl = molr.ReplacementPicture;
                }
            }
        }
Ejemplo n.º 12
0
        protected void btnadd_Click(object sender, EventArgs e)
        {
            string name   = "^[a-zA-Z0-9\u4e00-\u9fa5-]{1,}$";//字母数字汉字-
            Regex  rxname = new Regex(name);

            if (ReplacementName.Text == "")
            {
                Response.Write("<script>alert('请输入名称!')</script>");
                return;
            }
            if ((bllr.GetList("ReplacementName ='" + ReplacementName.Text + "'").Tables[0].Rows.Count) > 1)
            {
                Response.Write("<script>alert('已存在该名称!')</script>");
                return;
            }
            if (ReplacementModel.Text == "")
            {
                Response.Write("<script>alert('请输入型号!')</script>");
                return;
            }
            if (MachineFather.SelectedValue == "请选择")
            {
                Response.Write("<script>alert('请选择父类!')</script>");
                return;
            }
            if (MachineSon.SelectedValue == "请选择")
            {
                Response.Write("<script>alert('请选择子类!')</script>");
                return;
            }
            //if (DropDownList1.SelectedValue == "请选择")
            //{
            //    Response.Write("<script>alert('请选择状态!')</script>");
            //    return;
            //}
            if (!rxname.IsMatch(ReplacementName.Text.Trim()) && ReplacementName.Text.Trim() != "")
            {
                RadAjaxManager1.Alert("不能输入特殊字符!");
                return;
            }
            if (!rxname.IsMatch(ReplacementModel.Text.Trim()) && ReplacementModel.Text.Trim() != "")
            {
                RadAjaxManager1.Alert("不能输入特殊字符!");
                return;
            }
            //if (imgPic.ImageUrl == "")
            //{
            //    Response.Write("<script>alert('请选择图片!')</script>");
            //    return;
            //}
            //if (DropDownList1.SelectedValue == "已报废" && TBBF.Text == "")
            //{
            //    Response.Write("<script>alert('请输入报废原因!')</script>");
            //    return;
            //}
            else
            {
                Maticsoft.Model.Replacement molr = bllr.GetModel(Request.QueryString["ID"].ToString());
                molr.ReplacementName  = ReplacementName.Text.Trim();
                molr.ReplacementModel = ReplacementModel.Text.Trim();
                molr.MachineFatherID  = MachineFather.SelectedValue;
                molr.MachineSonID     = MachineSon.SelectedValue;
                if (YES1.Checked == true)
                {
                    molr.ReplacementState = "已报废";
                }
                else
                {
                    molr.ReplacementState = "未借出";
                }
                //molr.ReplacementState = DropDownList1.SelectedValue;
                //molr.ReplacementPicture = imgPic.ImageUrl;

                //ImgModel img = new ImgModel();

                string aa = "";

                foreach (ImgModel img in ImgList)
                {
                    aa += img.imgUrl + ";";
                }

                molr.ReplacementPicture = aa;

                //if (DropDownList1.SelectedValue == "已报废")
                //{
                //    molr.FFF1 = TBBF.Text;
                //}
                if (YES1.Checked == true)
                {
                    molr.FFF1 = TBBF.Text;
                }

                bllr.Update(molr);
                Response.Write("<script>alert('修改成功!');window.location.href='SubstituteMachine.aspx'</script>");
            }
        }