postgresql查询后更新,怎么让查询的字段不是大写,代码如下:
#region [3.反写PLM获取数据的标识位]
sql = @"
SELECT DISTINCT
ID_TMP AS id
,'1' AS ""prcvstate""
FROM BOMMEF
WHERE 1=1
";
sqlQuery = ESSqlQuery.Create(dbErptmpSchema, sql);
IList<IDictionary> dataPartUpdate = sqlQuery.GetListView() as IList<IDictionary>;
ESDataOperator dataOperatorPlm = ESDataOperator.Create(dbPlmSchema);
dataOperatorPlm.Update("processlib", dataPartUpdate, new string[] { "id" });
#endregion