public void DeleteWrongStadiumData() { ModuleManager Manager = new ModuleManager(); TableDefineInfoManager TableManager = new TableDefineInfoManager(); ModelDataManager DataManager = new ModelDataManager(); String modelIndex = "05d0d71b-def3-42ee-a16a-79b34de97e9b"; DataTable dataTb = GetDataTable("select * from [biz_norm_extent_" + modelIndex + "]"); if (dataTb != null) { foreach (DataRow dataRow in dataTb.Rows) { try { DataTable dt = GetDataTable("SELECT * FROM sys_biz_reminder_stadiumData WHERE DataID = '" + dataRow["ID"].ToString() + "' AND F_IsDone=0"); if (dt == null || dt.Rows.Count == 0) { continue; } List <IndexDescriptionPair> Sheets = Manager.InitModuleInfo(modelIndex); List <TableDefineInfo> TableSchemas = new List <TableDefineInfo>(); foreach (IndexDescriptionPair pair in Sheets) { TableDefineInfo Info = TableManager.GetTableDefineInfo(pair.Index, pair.DataTable); TableSchemas.Add(Info); } String extentTable = "biz_norm_extent_" + modelIndex; TableDefineInfo ExtentTableSchema = TableManager.GetTableDefineInfo("1", extentTable); DataSet ds = DataManager.GetData(TableSchemas, ExtentTableSchema, dataRow["ID"].ToString(), dataRow["scpt"].ToString()); Object key = ds.Tables["[biz_norm_混凝土检查试件抗压强度试验报告]"].Rows[0]["col_norm_I33"]; String deleteSql = "Update dbo.sys_biz_reminder_stadiumData set F_IsDone=1 WHERE F_IsDone IS NULL AND DataID='{0}' AND DateSpan={1}"; if (key != DBNull.Value) { if (key.ToString().Contains("28")) { ExcuteCommand(String.Format(deleteSql, dataRow["ID"].ToString(), 56)); } else if (key.ToString().Contains("56")) { ExcuteCommand(String.Format(deleteSql, dataRow["ID"].ToString(), 28)); } } } catch (Exception ex) { logger.Error("Delete Old Data Error: " + ex.Message + "; ModelIndex=" + modelIndex + "; DataID=" + dataRow["ID"].ToString()); } } } }
public void MoveOldStadiumData() { ModuleManager Manager = new ModuleManager(); TableDefineInfoManager TableManager = new TableDefineInfoManager(); ModelDataManager DataManager = new ModelDataManager(); DataTable tb = GetDataTable("SELECT DISTINCT a.ID FROM dbo.sys_biz_reminder_stadiumInfo a join sys_biz_Module b on a.id=b.id WHERE a.IsActive=1"); if (tb != null) { foreach (DataRow row in tb.Rows) { String modelIndex = row["ID"].ToString(); DataTable dataTb = GetDataTable("select * from [biz_norm_extent_" + modelIndex + "]"); if (dataTb != null) { foreach (DataRow dataRow in dataTb.Rows) { try { List <IndexDescriptionPair> Sheets = Manager.InitModuleInfo(modelIndex); List <TableDefineInfo> TableSchemas = new List <TableDefineInfo>(); foreach (IndexDescriptionPair pair in Sheets) { TableDefineInfo Info = TableManager.GetTableDefineInfo(pair.Index, pair.DataTable); TableSchemas.Add(Info); } String extentTable = "biz_norm_extent_" + modelIndex; TableDefineInfo ExtentTableSchema = TableManager.GetTableDefineInfo("1", extentTable); DataSet ds = DataManager.GetData(TableSchemas, ExtentTableSchema, dataRow["ID"].ToString(), dataRow["scpt"].ToString()); InitStadium(modelIndex, ds); } catch (Exception ex) { logger.Error("Move Old Data Error: " + ex.Message + "; ModelIndex=" + modelIndex + "; DataID=" + dataRow["ID"].ToString()); } } } } } }
/// <summary> /// 为西成线11标中心,删除219条资料的28d数据,并生成1条56d数据 /// </summary> public void SpStadiumData() { ModuleManager Manager = new ModuleManager(); TableDefineInfoManager TableManager = new TableDefineInfoManager(); ModelDataManager DataManager = new ModelDataManager(); String modelIndex = "05d0d71b-def3-42ee-a16a-79b34de97e9b"; DataTable dataTb = GetDataTable("select * from [biz_norm_extent_" + modelIndex + "] WHERE scpt LIKE '0001001700010001%' "); DataTable stadiumInfo = GetStadiumInfoByModelIndex(modelIndex); StadiumConfig config = Newtonsoft.Json.JsonConvert.DeserializeObject <StadiumConfig>(stadiumInfo.Rows[0]["StadiumConfig"].ToString()); if (dataTb != null) { foreach (DataRow dataRow in dataTb.Rows) { try { DataTable dt = GetDataTable("SELECT * FROM sys_biz_reminder_stadiumData WHERE DataID='" + dataRow["ID"].ToString() + "' AND DateSpan = 56"); if (dt.Rows.Count == 0) { List <IndexDescriptionPair> Sheets = Manager.InitModuleInfo(modelIndex); List <TableDefineInfo> TableSchemas = new List <TableDefineInfo>(); foreach (IndexDescriptionPair pair in Sheets) { TableDefineInfo Info = TableManager.GetTableDefineInfo(pair.Index, pair.DataTable); TableSchemas.Add(Info); } String extentTable = "biz_norm_extent_" + modelIndex; TableDefineInfo ExtentTableSchema = TableManager.GetTableDefineInfo("1", extentTable); DataSet dataset = DataManager.GetData(TableSchemas, ExtentTableSchema, dataRow["ID"].ToString(), dataRow["scpt"].ToString()); DataTable extTable = dataset.Tables["[biz_norm_extent_" + modelIndex + "]"]; String dataID = extTable.Rows[0]["ID"].ToString(); String modelCode = extTable.Rows[0]["SCPT"].ToString(); String fName = extTable.Rows[0]["DataName"].ToString(); String fPH = config.fPH == null ? "" : dataset.Tables[config.fPH.TableName].Rows[0][config.fPH.ColumnName].ToString().Replace("'", "''"); String fZJRQ = config.fZJRQ == null ? "" : dataset.Tables[config.fZJRQ.TableName].Rows[0][config.fZJRQ.ColumnName].ToString(); String fSJBH = config.fSJBH == null ? "" : dataset.Tables[config.fSJBH.TableName].Rows[0][config.fSJBH.ColumnName].ToString().Replace("'", "''"); String fSJSize = config.fSJSize == null ? "" : dataset.Tables[config.fSJSize.TableName].Rows[0][config.fSJSize.ColumnName].ToString(); String fAdded = config.fAdded == null ? "" : dataset.Tables[config.fAdded.TableName].Rows[0][config.fAdded.ColumnName].ToString(); String fBGBH = config.fBGBH == null ? "" : dataset.Tables[config.fBGBH.TableName].Rows[0][config.fBGBH.ColumnName].ToString(); String fWTBH = config.fWTBH == null ? "" : dataset.Tables[config.fWTBH.TableName].Rows[0][config.fWTBH.ColumnName].ToString(); String insertSql = String.Format(@"INSERT INTO dbo.sys_biz_reminder_stadiumData ( DataID , Scts , ModelCode , ModelIndex , DateSpan , F_Name , F_ItemId , F_PH , F_ZJRQ , F_SJBH , F_SJSize , F_SYXM , F_BGBH , F_WTBH, F_Added ) VALUES ( '{0}' , '{1}' ,'{2}' ,'{3}' ,'{4}' ,'{5}' ,'{6}' ,'{7}' , '{8}' , '{9}' , '{10}' , '{11}' , '{12}' , '{13}','{14}' )", dataID, DateTime.Now.ToString(), modelCode, modelIndex, 56, fName, "95", fPH, fZJRQ, fSJBH, fSJSize, "混凝土抗压56天", fBGBH, fWTBH, fAdded); ExcuteCommand(insertSql); } } catch (Exception ex) { logger.Error("SP Old Data Error: " + ex.Message + "; ModelIndex=" + modelIndex + "; DataID=" + dataRow["ID"].ToString()); } } } }