/// <summary> /// 编辑时触发 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { if (this.GridView1.EditIndex != -1) { this.lblMsg.Visible = true; return; } this.GridView1.EditIndex = e.NewEditIndex; this.GridBind(); TextBox txtid = (TextBox)this.GridView1.Rows[e.NewEditIndex].FindControl("txtid"); txtid.Enabled = false; txtid.Enabled = false; Coolite.Ext.Web.ComboBox ComboBox1 = (Coolite.Ext.Web.ComboBox) this.GridView1.Rows[e.NewEditIndex].FindControl("ComboBox1"); ComboBox1.Visible = false; DropDownList ddlPlanType = (DropDownList)this.GridView1.Rows[e.NewEditIndex].FindControl("ddlPlanType");//用户名称标签 Label lblPlanType = (Label)this.GridView1.Rows[e.NewEditIndex].FindControl("lblPlanType"); ddlPlanType.SelectedIndex = ddlPlanType.Items.IndexOf(ddlPlanType.Items.FindByValue(lblPlanType.Text)); }
/// <summary> /// 编辑时触发 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) { if (this.GridView1.EditIndex != -1) { this.lblMsg.Visible = true; return; } this.GridView1.EditIndex = e.NewEditIndex; this.GridBind(); //DropDownList ddlstate = (DropDownList)this.GridView1.Rows[e.NewEditIndex].FindControl("ddlModelType"); //ddlstate.SelectedValue = this.GridView1.DataKeys[e.NewEditIndex].Value.ToString(); TextBox txtModelID = (TextBox)this.GridView1.Rows[e.NewEditIndex].FindControl("txtModelID"); Coolite.Ext.Web.ComboBox ComboBox1 = (Coolite.Ext.Web.ComboBox) this.GridView1.Rows[e.NewEditIndex].FindControl("ComboBox1"); txtModelID.Enabled = false; ComboBox1.Visible = false; }
/// <summary> /// 更新时触发 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { string id = this.GridView1.DataKeys[e.RowIndex].Value.ToString(); TextBox txtid = (TextBox)this.GridView1.Rows[e.RowIndex].FindControl("txtid"); TextBox txtModelID = (TextBox)this.GridView1.Rows[e.RowIndex].FindControl("txtModelID"); TextBox txtOutput = (TextBox)this.GridView1.Rows[e.RowIndex].FindControl("txtOutput"); TextBox txtOrderID = (TextBox)this.GridView1.Rows[e.RowIndex].FindControl("txtOrderID"); //TextBox txtPlanType = (TextBox)this.GridView1.Rows[e.RowIndex].FindControl("txtPlanType"); DropDownList ddlPlanType = (DropDownList)this.GridView1.Rows[e.RowIndex].FindControl("ddlPlanType"); TextBox txtremark = (TextBox)this.GridView1.Rows[e.RowIndex].FindControl("txtremark"); if (id != null && id != string.Empty) { if (!Methods.ModelIDIsInDB(txtModelID.Text.Trim())) { Methods.AjaxMessageBox(this, "输入的品号无效!"); return; } } try { sqlaccess.Open(); sqlaccess.BeginTransaction(); if (id != null && id != string.Empty) { SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue("@p1", txtid.Text.Trim()); cmd.Parameters.AddWithValue("@p2", txtModelID.Text.Trim()); cmd.Parameters.AddWithValue("@p3", txtOutput.Text.Trim()); cmd.Parameters.AddWithValue("@p4", txtOrderID.Text.Trim()); //cmd.Parameters.AddWithValue("@p5",txtPlanType.Text.Trim()); cmd.Parameters.AddWithValue("@p5", ddlPlanType.SelectedValue); cmd.Parameters.AddWithValue("@p6", txtremark.Text.Trim()); //cmd.Parameters.AddWithValue("@p7", System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:dd")); //cmd.Parameters.AddWithValue("@p8",1); cmd.CommandText = " UPDATE TA_Plan SET ModelID = @p2, Output = @p3, OrderID = @p4, PlanType = @p5,Remark = @p6 where ID = @p1"; sqlaccess.ExecuteQuerry(cmd); } else { Coolite.Ext.Web.ComboBox ComboBox1 = (Coolite.Ext.Web.ComboBox) this.GridView1.Rows[e.RowIndex].FindControl("ComboBox1"); SqlCommand cmd = new SqlCommand(); cmd.Parameters.AddWithValue("@p1", txtid.Text.Trim()); cmd.Parameters.AddWithValue("@p2", ComboBox1.SelectedItem.Value.Trim()); cmd.Parameters.AddWithValue("@p3", txtOutput.Text.Trim()); cmd.Parameters.AddWithValue("@p4", txtOrderID.Text.Trim()); //cmd.Parameters.AddWithValue("@p5",txtPlanType.Text.Trim()); cmd.Parameters.AddWithValue("@p5", ddlPlanType.SelectedValue); cmd.Parameters.AddWithValue("@p6", txtremark.Text.Trim()); cmd.Parameters.AddWithValue("@p7", System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:dd")); cmd.Parameters.AddWithValue("@p8", 1); cmd.CommandText = "INSERT INTO TA_Plan (ID, ModelID, Output, OrderID, PlanType, Remark, FoundTime, State) VALUES (@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8)"; sqlaccess.ExecuteQuerry(cmd); } sqlaccess.Commit(); this.GridView1.EditIndex = -1; this.lblMsg.Visible = false; this.lblAccMsg.Visible = false; this.GridBind(); ViewState["newMark"] = false;//新建清除 } catch (Exception ex) { sqlaccess.Rollback(); if (ex.GetType().ToString().Equals("System.Data.SqlClient.SqlException") && ((SqlException)ex).ErrorCode == -2146232060) { char[] cs = { '\r', '\n' }; Methods.AjaxMessageBox(this, ex.Message.Split(cs)[0].Replace('\'', '"')); } LogManager.Write(this, ex.Message); } finally { sqlaccess.Close(); } }
/// <summary> /// 更新时触发 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { //TextBox txtid = (TextBox)this.GridView1.Rows[e.RowIndex].FindControl("txtid"); string txtid = this.GridView1.DataKeys[e.RowIndex].Value.ToString(); TextBox txtName = (TextBox)this.GridView1.Rows[e.RowIndex].FindControl("txtName"); //DropDownList ddlModelType = (DropDownList)this.GridView1.Rows[e.RowIndex].FindControl("ddlModelType"); TextBox txtModelID = (TextBox)this.GridView1.Rows[e.RowIndex].FindControl("txtModelID"); string tmpsql = "select id from ta_model where id='" + txtModelID.Text.Trim() + "'"; ds = sqlaccess.OpenQuerry(tmpsql); if (ds != null && ds.Tables[0].Rows.Count > 0) { this.lblMsg.Visible = false; } else { if (txtid != string.Empty) { this.lblMsg.Text = "输入的品号在数据库中不存在!"; this.lblMsg.Visible = true; return; } } try { sqlaccess.Open(); sqlaccess.BeginTransaction(); if (txtid != string.Empty)//非新建状态 { System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); cmd.Parameters.AddWithValue("@p1", txtid.Trim()); cmd.Parameters.AddWithValue("@p2", txtName.Text.Trim()); cmd.Parameters.AddWithValue("@p3", txtModelID.Text.Trim()); cmd.CommandText = "update TA_Procedure set name=@p2,ModelID=@p3 where id=@p1"; sqlaccess.ExecuteQuerry(cmd); //LogManager.WriteOprationLog(SessionUser.DetailInfo, updateStr); //string logStr = "update TA_Model set id ='{0}',name='{1}',ModelType='{2}',Code='{3}' where id='{4}'"; //logStr = String.Format(logStr, txtid.Text.Trim(), txtName.Text.Trim(), ddlModelType.SelectedValue, txtCode.Text.Trim(), txtid.Text.Trim()); //Methods.WriteOprationLog(SessionUser.ID, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), logStr); } else//新建状态 { Coolite.Ext.Web.ComboBox ComboBox1 = (Coolite.Ext.Web.ComboBox) this.GridView1.Rows[e.RowIndex].FindControl("ComboBox1"); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); //cmd.Parameters.AddWithValue("@p1", txtid.Text.Trim()); cmd.Parameters.AddWithValue("@p2", txtName.Text.Trim()); cmd.Parameters.AddWithValue("@p3", ComboBox1.SelectedItem.Value.ToString().Trim()); cmd.CommandText = "insert into TA_Procedure (name,ModelID) values(@p2,@p3)"; sqlaccess.ExecuteQuerry(cmd); //string logStr = "insert into TA_Model (id,name,ModelType,Code) values('{0}','{1}','{2}','{3}')"; //logStr = String.Format(logStr, txtid.Text.Trim(), txtName.Text.Trim(), ddlModelType.SelectedValue, txtCode.Text.Trim()); //LogManager.WriteOprationLog(SessionUser.DetailInfo, updateStr); //Methods.WriteOprationLog(SessionUser.ID, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), logStr); } sqlaccess.Commit(); this.GridView1.EditIndex = -1; this.lblMsg.Visible = false; this.lblAccMsg.Visible = false; this.GridBind(); } catch (Exception ex) { sqlaccess.Rollback(); //if (ex.GetType().ToString().Equals("System.Data.SqlClient.SqlException") && ((SqlException)ex).ErrorCode == -2146232060) //{ // char[] cs = { '\r', '\n' }; Methods.AjaxMessageBox(this, ex.Message.Split(cs)[0].Replace('\'', '"')); //} this.lblMsg.Text = "更新的记录在数据库中已存在!"; this.lblMsg.Visible = true; LogManager.Write(this, ex.Message); } finally { sqlaccess.Close(); } }