/// <summary> /// /// </summary> /// <param name="appTypeGuid"></param> /// <returns></returns> // private static string GetClassByGuid(string appTypeGuid) // { // string strClass = string.Empty; // string strSql = "SELECT LEFT(CLASS, 8) FROM APP_OPERATION_TYPE WHERE APP_GUID = " + TSqlBuilder.Instance.CheckQuotationMark(appTypeGuid); // // DataAccess da = new DataAccess(HGLogDefine.C_CONN_STRING); // // using (da.dBContextInfo) // { // da.dBContextInfo.OpenConnection(); // // object obj = da.SqlDBHelper.ExecuteScalar(da.dBContextInfo.Context, CommandType.Text, strSql); // // if(false==(obj is DBNull)) // strClass = (string)obj; // } // // return strClass; // } /// <summary> /// /// </summary> /// <returns></returns> public static string GetClassForApp() { string strSql = "SELECT ISNULL(MAX(CLASS + 1), 1) FROM APP_LOG_TYPE WHERE LEN(CLASS) = 8"; string strTemp = "00000000" + InnerCommon.ExecuteScalar(strSql).ToString(); return(strTemp.Substring(strTemp.Length - 8, 8)); }
/// <summary> /// /// </summary> /// <param name="appTypeGuid"></param> /// <param name="strSort"></param> /// <returns></returns> public static string GetNewClassValue(string appTypeGuid, string strSort) { string strSql = "SELECT ISNULL(MAX(CLASS + 1), 1) FROM APP_OPERATION_TYPE WHERE APP_GUID = " + TSqlBuilder.Instance.CheckQuotationMark(appTypeGuid, true); string strTemp = "0000" + InnerCommon.ExecuteScalar(strSql).ToString(); return(strSort + strTemp.Substring(strTemp.Length - 4, 4)); }
/// <summary> /// /// </summary> /// <param name="displayName"></param> /// <param name="strTableName"></param> /// <returns></returns> public static string GetGuidByDisplayName(string displayName, string strTableName) { string strGuid = string.Empty; string strSql = "SELECT GUID FROM " + strTableName + " WHERE DISPLAYNAME = " + TSqlBuilder.Instance.CheckQuotationMark(displayName, true); object obj = InnerCommon.ExecuteScalar(strSql); if (false == (obj is DBNull)) { strGuid = (string)obj; } return(strGuid); }