/// <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);
}
