/// <summary> /// 同步数据-上传. /// </summary> /// <param name="localDt"></param> /// <returns></returns> public string SyncUpDataTable(DataTable localDt, SQLConvertPattern patten) { List <string> sqlList = ConvertToSql(localDt, patten); foreach (string sql in sqlList) { remoteDbCommon.ExecuteNonQuery(sql); } //string postString=WebLibrary.Serialize.SerializeJSONClass.Serialize(localDt); //byte[] postData = Encoding.ASCII.GetBytes(postString); //remoteDbCommon.GetWebClientExt.UploadData("", postData); //remoteDbCommon.ExecuteNonQuery(remoteDbCommon); return(""); }
private List <string> ConvertToSql(DataTable dt, SQLConvertPattern pattern) { List <string> list = new List <string>(); switch (pattern) { case (SQLConvertPattern.Insert): list = GenerateInserSql(dt); break; case (SQLConvertPattern.Update): list = GenerateUpdateSql(dt); break; case (SQLConvertPattern.Delete): list = GenerateDelSql(dt); break; } return(list); }