public GroupLineSelect() { FieldID = DNTRequest.GetInt("FieldID", 0); DataSetID = DNTRequest.GetInt("DataSetID", 0); //FormID = DNTRequest.GetInt("FormID", 0); ; dsEntity = DbHelper.GetInstance().GetWorkflow_DataSetEntityByKeyCol(DataSetID.ToString()); string[] splitStr = new string[1]; splitStr[0] = ","; string[] returnColumns = dsEntity.ReturnColumns.Split(splitStr, StringSplitOptions.RemoveEmptyEntries); SelectColumns = returnColumns; string[] returnColumnsName = dsEntity.ReturnColumnsName.Split(splitStr, StringSplitOptions.RemoveEmptyEntries); for (int j = 0; j < returnColumns.Length; j++) { nvc.Add(returnColumns[j], returnColumnsName[j]); } dsKeyColumns = dsEntity.DataSetPKColumns.Split(splitStr, StringSplitOptions.RemoveEmptyEntries); //获取参数列表 dtParameters = DbHelper.GetInstance().GetWorkflow_DataSetParameterEntityByKeyCol(DataSetID.ToString()); dtIniteSearchResult = DbHelper.GetInstance().GetDataSetTable(DataSetID, dtParameters); DataColumn[] PKdtSearchResult = new DataColumn[dsKeyColumns.Length]; for (int p = 0; p < dsKeyColumns.Length; p++) { PKdtSearchResult[p] = dtIniteSearchResult.Columns[dsKeyColumns[p]]; } dtIniteSearchResult.PrimaryKey = PKdtSearchResult; }
private Workflow_DataSetEntity GetWorkflow_DataSetFromIDataReader(DbDataReader dr) { Workflow_DataSetEntity dt = new Workflow_DataSetEntity(); if (dr.FieldCount > 0) { if (dr["DataSetID"].ToString() != "" || dr["DataSetID"] != null) dt.DataSetID = Int32.Parse(dr["DataSetID"].ToString()); if (dr["DataSetType"].ToString() != "" || dr["DataSetType"] != null) dt.DataSetType = Int32.Parse(dr["DataSetType"].ToString()); dt.DataSetName = dr["DataSetName"].ToString(); if (dr["DataSourceID"].ToString() != "" || dr["DataSourceID"] != null) dt.DataSourceID = Int32.Parse(dr["DataSourceID"].ToString()); dt.TableList = dr["TableList"].ToString(); dt.FieldList = dr["FieldList"].ToString(); dt.QueryCondition = dr["QueryCondition"].ToString(); dt.OrderBy = dr["OrderBy"].ToString(); dt.QuerySql = dr["QuerySql"].ToString(); dt.ReturnColumns = dr["ReturnColumns"].ToString(); dt.ReturnColumnsName = dr["ReturnColumnsName"].ToString(); dt.DataSetPKColumns = dr["DataSetPKColumns"].ToString(); dr.Close(); return dt; } dr.Close(); return null; }
/// <summary> /// 修改信息 /// </summary> /// <param name="_Workflow_DataSetEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public int UpdateWorkflow_DataSetForStoredProcedure(Workflow_DataSetEntity _Workflow_DataSetEntity) { DbParameter[] pramsUpdate = { MakeInParam("@DataSetName",(DbType)SqlDbType.VarChar,50,_Workflow_DataSetEntity.DataSetName ), MakeInParam("@DataSourceID",(DbType)SqlDbType.Int,4,_Workflow_DataSetEntity.DataSourceID ), MakeInParam("@TableList",(DbType)SqlDbType.VarChar,2000,_Workflow_DataSetEntity.TableList ), MakeInParam("@QueryCondition",(DbType)SqlDbType.VarChar,2000,_Workflow_DataSetEntity.QueryCondition ), MakeInParam("@ReturnColumns",(DbType)SqlDbType.VarChar,2000,_Workflow_DataSetEntity.ReturnColumns ), MakeInParam("@DataSetPKColumns",(DbType)SqlDbType.VarChar,2000,_Workflow_DataSetEntity.DataSetPKColumns ), MakeInParam("@ReturnColumnsName",(DbType)SqlDbType.VarChar,2000,_Workflow_DataSetEntity.ReturnColumnsName ), MakeInParam("@DataSetID",(DbType)SqlDbType.Int,4,_Workflow_DataSetEntity.DataSetID ) }; StringBuilder sb = new StringBuilder(); sb.Append("Update [dbo].[Workflow_DataSet]"); sb.Append(" set "); sb.Append(" [DataSetType]=2,"); sb.Append(" [DataSetName]=@DataSetName,"); sb.Append(" [DataSourceID]=@DataSourceID,"); sb.Append(" [TableList]=@TableList,"); sb.Append(" [QueryCondition]=@QueryCondition,"); sb.Append(" [ReturnColumns]=@ReturnColumns,"); sb.Append(" [DataSetPKColumns]=@DataSetPKColumns,"); sb.Append(" [ReturnColumnsName]=@ReturnColumnsName"); sb.Append(" where [DataSetID]=@DataSetID; select @@rowcount"); return Convert.ToInt32(ExecuteScalar(CommandType.Text, sb.ToString(), pramsUpdate)); }
/// <summary> /// 新增信息 /// </summary> /// <param name="_Workflow_DataSetEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public int AddWorkflow_DataSetSP(Workflow_DataSetEntity _Workflow_DataSetEntity) { DbParameter[] pramsInsert = { MakeInParam("@DataSetType",(DbType)SqlDbType.Int,4,_Workflow_DataSetEntity.DataSetType ), MakeInParam("@DataSetName",(DbType)SqlDbType.VarChar,50,_Workflow_DataSetEntity.DataSetName ), MakeInParam("@DataSourceID",(DbType)SqlDbType.Int,4,_Workflow_DataSetEntity.DataSourceID ), MakeInParam("@TableList",(DbType)SqlDbType.VarChar,2000,_Workflow_DataSetEntity.TableList ), MakeInParam("@QueryCondition",(DbType)SqlDbType.VarChar,2000,_Workflow_DataSetEntity.QueryCondition ), MakeInParam("@ReturnColumns",(DbType)SqlDbType.VarChar,2000,_Workflow_DataSetEntity.ReturnColumns ), MakeInParam("@DataSetPKColumns",(DbType)SqlDbType.VarChar,2000,_Workflow_DataSetEntity.DataSetPKColumns ), MakeInParam("@ReturnColumnsName",(DbType)SqlDbType.VarChar,2000,_Workflow_DataSetEntity.ReturnColumnsName ) }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Workflow_DataSet]"); sb.Append("("); sb.Append("[DataSetType]"); sb.Append(",[DataSetName]"); sb.Append(",[DataSourceID]"); sb.Append(",[TableList]"); sb.Append(",[QueryCondition]"); sb.Append(",[ReturnColumns]"); sb.Append(",[DataSetPKColumns]"); sb.Append(",[ReturnColumnsName]"); sb.Append(") "); sb.Append(" VALUES ("); sb.Append("@DataSetType,"); sb.Append("@DataSetName,"); sb.Append("@DataSourceID,"); sb.Append("@TableList,"); sb.Append("@QueryCondition,"); sb.Append("@ReturnColumns,"); sb.Append("@DataSetPKColumns,"); sb.Append("@ReturnColumnsName"); sb.Append(");"); sb.Append("select @@identity;"); return Convert.ToInt32(ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert)); }