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