public DataSet GetChiFengDate(string BH, string jydbh, string jydbhTo = "")
{
SqlBase sqlbase = new SqlBase(ESqlConnType.ConnectionStringCF);
string where = "where 1=1";
int top = 100;
if (!string.IsNullOrEmpty(jydbh))
{
where = $" where JYDBH={jydbh}";
}
if (!string.IsNullOrEmpty(jydbh) && !string.IsNullOrEmpty(jydbhTo))
{
where = $" where JYDBH>={jydbh}";
top = 9999;
}
if (!string.IsNullOrEmpty(jydbhTo))
{
where += $" and JYDBH<={jydbhTo}";
}
string sqlStr = $"select top {top} * from M{BH} {where} and BGBH <>'' order by RECID DESC";
DataSet mdata = sqlbase.ExecuteDataset(sqlStr);
return(mdata);
}
/// <summary>
/// 获取Y数据表
/// </summary>
/// <param name="lisFields"></param>
/// <param name="jydbh"></param>
/// <param name="ytable"></param>
/// <returns></returns>
public DataSet GetParmsYtable(List <string> lisFields, string jydbh, string ytable)
{
SqlBase baseChifeng = new SqlBase(ESqlConnType.ConnectionStringCF);
if (lisFields.Count != 2)
{
return(null);
}
string sfield = lisFields[1];
sfield = string.IsNullOrEmpty(sfield) ? "*" : sfield;
string extra_sql = string.Format($"select {sfield} from ytable where JYDBH='{jydbh}'");
DataSet extra_dt = baseChifeng.ExecuteDataset(extra_sql);
return(extra_dt);
}
public DataSet GetParmsWH(string BH, List <string> lisFields, string wtdbh)
{
SqlBase baseChifeng = new SqlBase(ESqlConnType.ConnectionStringJCJT);
if (lisFields.Count != 2)
{
return(null);
}
string sfield = lisFields[1];
sfield = string.IsNullOrEmpty(sfield) ? "*" : sfield;
string extra_sql = string.Format($"select {sfield} from S_{BH} where BYZBRECID=(select RECID from M_BY where WTDBH = '{wtdbh}' AND YTDWBH in('{FormMain._qybh.Replace(",", "','")}'))");
DataSet extra_dt = baseChifeng.ExecuteDataset(extra_sql);
return(extra_dt);
}
private void btn_ok_Click(object sender, EventArgs e)
{
string tabName = "";
string sqlStr = "";
if (string.IsNullOrEmpty(this.txt_tableName.Text))
{
//同步所有的zdzdbiao
sqlStr = $" select name from sysobjects where xtype='u' and name like 'ZDZD_%'";
}
else
{
//指定的表
tabName = this.txt_tableName.Text;
sqlStr = $" select name from sysobjects where xtype='u' and name = 'ZDZD_{tabName}'";
}
//ZDZD_ZX
SqlBase _sqlBase = new SqlBase(ESqlConnType.ConnectionStringJCJT);
SqlBase _DebugTool = new SqlBase(ESqlConnType.ConnectionStringDebugTool);
SqlBase ngJCJG = new SqlBase(ESqlConnType.ConnectionStringJCJG);
//string sqlStr = string.Format($"SELECT 表名 = D.name,字段序号 = A.colorder,字段名 = A.name,字段说明 = isnull(G.[value], ''),类型 = B.name,占用字节数 = A.Length " +
// $"FROM syscolumns A Left Join systypes B On A.xusertype = B.xusertype Inner Join sysobjects D On A.id = D.id and D.xtype = 'U' and D.name <> 'dtproperties'" +
// $" Left Join syscomments E on A.cdefault = E.id Left Join sys.extended_properties G on A.id = G.major_id and A.colid = G.minor_id Left Join sys.extended_properties F On D.id = F.major_id and F.minor_id = 0 " +
// $"where d.name = '{tabName}' "
// + wheresql +
// $" Order By A.id, A.colorder");
var dtTableName = _sqlBase.ExecuteDataset(sqlStr);
if (dtTableName.Tables.Count == 0)
{
return;
}
var dt = dtTableName.Tables[0];
var sql = "";
var syxmbh = "";
DataSet ds = null;
foreach (DataRow item in dt.Rows)
{
syxmbh = item["name"].ToString().ToUpper().Replace("ZDZD_", "");
ds = _DebugTool.ExecuteDataset($" select name from sysobjects where xtype='u' and name = 'ZDZD_{syxmbh}'");
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//如果已经同步过，则执行下一个
//MessageBox.Show($"项目{syxmbh}已经同步");
continue;
}
sql = $"select * into ZDZD_{syxmbh} from jcjt_wh.dbo.ZDZD_{syxmbh} where sjbmc like 'S_{syxmbh}' or sjbmc like 'M_{syxmbh}'";
//sql = $"select * into ZDZD_{syxmbh} from ITSV.jcjt_wh.dbo.ZDZD_{syxmbh} where sjbmc like 'S_{syxmbh}' or sjbmc like 'M_{syxmbh}'";
//sql = $"alter table zdzd_{syxmbh} drop column sj_zs";
try
{
_sqlBase.ExecuteNonQuery(sql);
}
catch
{ }
}
//select* from ITSV.jcjt_wh.dbo.ZDZD_ZX where sjbmc like 'S_%' or sjbmc like 'M_%'
}
