private Workflow_BasicValidTypeEntity GetWorkflow_BasicValidTypeFromIDataReader(DbDataReader dr) { Workflow_BasicValidTypeEntity dt = new Workflow_BasicValidTypeEntity(); if (dr.FieldCount > 0) { if (dr["ValidTypeID"].ToString() != "" || dr["ValidTypeID"] != null) dt.ValidTypeID = Int32.Parse(dr["ValidTypeID"].ToString()); dt.ValidTypeDesc = dr["ValidTypeDesc"].ToString(); dt.ValidErrorMsg = dr["ValidErrorMsg"].ToString(); dt.ValidRule = (dr["ValidRule"].ToString()); dr.Close(); return dt; } dr.Close(); return null; }
/// <summary> /// 修改信息 /// </summary> /// <param name="_Workflow_BasicValidTypeEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string UpdateWorkflow_BasicValidType(Workflow_BasicValidTypeEntity _Workflow_BasicValidTypeEntity) { DbParameter[] pramsUpdate = { MakeInParam("@ValidTypeDesc",(DbType)SqlDbType.VarChar,200,_Workflow_BasicValidTypeEntity.ValidTypeDesc ), MakeInParam("@ValidErrorMsg",(DbType)SqlDbType.VarChar,200,_Workflow_BasicValidTypeEntity.ValidErrorMsg ), MakeInParam("@ValidRule",(DbType)SqlDbType.VarChar,200,_Workflow_BasicValidTypeEntity.ValidRule ), MakeInParam("@ValidTypeID",(DbType)SqlDbType.Int,4,_Workflow_BasicValidTypeEntity.ValidTypeID ) }; StringBuilder sb = new StringBuilder(); sb.Append("Update [dbo].[Workflow_BasicValidType]"); sb.Append(" set "); sb.Append(" [ValidTypeDesc]=@ValidTypeDesc,"); sb.Append(" [ValidErrorMsg]=@ValidErrorMsg,"); sb.Append(" [ValidRule]=@ValidRule"); sb.Append(" where [ValidTypeID]=@ValidTypeID;select @@rowcount"); return ExecuteNonQuery(CommandType.Text, sb.ToString(), pramsUpdate).ToString(); }
/// <summary> /// 新增信息 /// </summary> /// <param name="_Workflow_BasicValidTypeEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string AddWorkflow_BasicValidType(Workflow_BasicValidTypeEntity _Workflow_BasicValidTypeEntity) { DbParameter[] pramsInsert = { MakeInParam("@ValidTypeDesc",(DbType)SqlDbType.VarChar,200,_Workflow_BasicValidTypeEntity.ValidTypeDesc ), MakeInParam("@ValidErrorMsg",(DbType)SqlDbType.VarChar,200,_Workflow_BasicValidTypeEntity.ValidErrorMsg ), MakeInParam("@ValidRule",(DbType)SqlDbType.VarChar,200,_Workflow_BasicValidTypeEntity.ValidRule ) }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Workflow_BasicValidType]"); sb.Append("("); sb.Append("[ValidTypeDesc]"); sb.Append(",[ValidErrorMsg]"); sb.Append(",[ValidRule]"); sb.Append(") "); sb.Append(" VALUES ("); sb.Append("@ValidTypeDesc,"); sb.Append("@ValidErrorMsg,"); sb.Append("@ValidRule);"); sb.Append("select @@identity;"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); }
//此类要更改,因为只考虑了TextBox值的赋值过程 private void SetPannelData(Workflow_BasicValidTypeEntity _Workflow_BasicValidTypeEntity) { //BindDropDownList(_psacnEntity.PSACNDAT); txtValidTypeID.Value = _Workflow_BasicValidTypeEntity.ValidTypeID.ToString(); //验证方式编号 if (_Workflow_BasicValidTypeEntity.ValidTypeDesc != null) txtValidTypeDesc.Text = _Workflow_BasicValidTypeEntity.ValidTypeDesc.ToString(); //验证方式描述 if (_Workflow_BasicValidTypeEntity.ValidErrorMsg != null) txtValidErrorMsg.Text = _Workflow_BasicValidTypeEntity.ValidErrorMsg.ToString(); //验证不通过时的提示信息 if (_Workflow_BasicValidTypeEntity.ValidRule != null) txtValidRule.Text = _Workflow_BasicValidTypeEntity.ValidRule.ToString(); //验证用的正则表达式 strOperationState = "Update"; }
//此类要更改,完成赋值工作 private string SaveData() { Workflow_BasicValidTypeEntity _Workflow_BasicValidTypeEntity = new Workflow_BasicValidTypeEntity(); _Workflow_BasicValidTypeEntity.ValidTypeID = (txtValidTypeID.Value.Trim() == "" || txtValidTypeID.Value == null) ? 0 : Convert.ToInt32(txtValidTypeID.Value); _Workflow_BasicValidTypeEntity.ValidTypeDesc = txtValidTypeDesc.Text; _Workflow_BasicValidTypeEntity.ValidErrorMsg = txtValidErrorMsg.Text; _Workflow_BasicValidTypeEntity.ValidRule = txtValidRule.Text; string sResult = "-1"; if (strOperationState == "Add") sResult = DbHelper.GetInstance().AddWorkflow_BasicValidType(_Workflow_BasicValidTypeEntity); else if (strOperationState == "Update") sResult = DbHelper.GetInstance().UpdateWorkflow_BasicValidType(_Workflow_BasicValidTypeEntity); return sResult; }
//1。更改key字段在GridView中的哪一行,默认都是第5行,第一二列为button 第三列为checkBox 第四列为edit字段,第五列 关键字列 //2。通过关键字获取单条记录。 protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { int index = -1; if (e.CommandName == "select") { programmaticAddModalPopup.Show(); strOperationState = "Update"; index = Convert.ToInt32(e.CommandArgument); //获取行号 string keyCol = GridView1.DataKeys[index].Value.ToString(); //第二处待修改位置 Workflow_BasicValidTypeEntity _Workflow_BasicValidTypeEntity = new Workflow_BasicValidTypeEntity(); _Workflow_BasicValidTypeEntity = DbHelper.GetInstance().GetWorkflow_BasicValidTypeEntityByKeyCol(keyCol); if (_Workflow_BasicValidTypeEntity != null) SetPannelData(_Workflow_BasicValidTypeEntity); } }