private bool _UpdateIntoPageKey(Class_PageInfomationMode class_PageInfomationMode, bool PageVersionSign = false)
{
string Sql = string.Format(@"UPDATE vou_pageInfomation
SET projectId = '{1}'
,pageType = '{2}'
,pageVersion = case when pageVersion > 2147483647 then 0 else pageVersion + {12} end
,lastUpdateTime = datetime('now','localtime')
,createOperatorId = '{3}'
,doOperatorId = '{4}'
,finishCount = {11}
,methodRemark = {5}
,readOnly = {6}
,frontOperatorId = '{7}'
,createOperator = '{8}'
,doOperator = '{9}'
,frontOperator = '{10}'
WHERE pageKey = '{0}'"
, class_PageInfomationMode.pageKey
, class_PageInfomationMode.projectId
, class_PageInfomationMode.pageType
, class_PageInfomationMode.createOperatorId
, class_PageInfomationMode.doOperatorId
, (class_PageInfomationMode.methodRemark == null ? "null" : "'" + class_PageInfomationMode.methodRemark + "'")
, (class_PageInfomationMode.readOnly ? 1 : 0)
, class_PageInfomationMode.frontOperatorId
, class_PageInfomationMode.createOperator
, class_PageInfomationMode.doOperator
, class_PageInfomationMode.frontOperator
, class_PageInfomationMode.finishCount
, PageVersionSign ? "1" : "0"
);
return(mySqlite3.ExecuteSql(Sql) == 1 ? true : false);
}
public bool InsertIntoPageKey(Class_PageInfomationMode class_PageInfomationMode, bool PageVersionSign)
{
if (_GetPageKeyCount(class_PageInfomationMode.pageKey) == 0)
{
return(_InsertIntoPageKey(class_PageInfomationMode));
}
else
{
return(_UpdateIntoPageKey(class_PageInfomationMode, PageVersionSign));
}
}
private bool _InsertIntoPageKey(Class_PageInfomationMode class_PageInfomationMode)
{
string Sql = string.Format(@"INSERT INTO vou_pageInfomation(pageKey, projectId,
pageType, pageVersion, createTime, lastUpdateTime,
createOperatorId, doOperatorId, finishCount, methodRemark,readOnly,frontOperatorId
,createOperator, doOperator,frontOperator,pushSign)
VAlUES('{0}','{1}','{2}',{3},'{4}','{5}','{6}','{7}',{8},{9},{10},'{11}','{12}','{13}','{14}',0)"
, class_PageInfomationMode.pageKey, class_PageInfomationMode.projectId
, class_PageInfomationMode.pageType, class_PageInfomationMode.pageVersion
, class_PageInfomationMode.createTime.ToString("yyyy-MM-dd HH:mm:ss")
, class_PageInfomationMode.lastUpdateTime.ToString("yyyy-MM-dd HH:mm:ss")
, class_PageInfomationMode.createOperatorId, class_PageInfomationMode.doOperatorId
, class_PageInfomationMode.finishCount, (class_PageInfomationMode.methodRemark == null ? "null" : "'" + class_PageInfomationMode.methodRemark + "'")
, (class_PageInfomationMode.readOnly ? 1 : 0)
, class_PageInfomationMode.frontOperatorId
, class_PageInfomationMode.createOperator
, class_PageInfomationMode.doOperator
, class_PageInfomationMode.frontOperator
);
return(mySqlite3.ExecuteSql(Sql) == 1 ? true : false);
}
