private string insertURL(string longURL) { libCommon.clsDB objDB = new libCommon.clsDB(); System.Data.SqlClient.SqlConnection dbCon = libMyUtil.clsCmnDB.getConnection("sa", "rhksflwk", "urlShorten", "192.168.10.10"); System.Data.SqlClient.SqlTransaction TRX; Random objRandom = new Random(); byte[] shortURL_byte; string shortURL; string Result; shortURL_byte = System.BitConverter.GetBytes(new UInt32()); objRandom.NextBytes(shortURL_byte); shortURL = libMyUtil.clsFile.toBase62(System.BitConverter.ToUInt32(shortURL_byte, 0)); dbCon.Open(); TRX = dbCon.BeginTransaction(); Result = libMyUtil.clsCmnDB.INSERT_DB(dbCon, TRX, "tb_URL", "longURL|shortURL", longURL + "|" + shortURL); if (Result.Equals("FAIL")) { TRX.Rollback(); shortURL = ""; } else { TRX.Commit(); } dbCon.Close(); return(shortURL); }
/// <summary> /// tb_aURLresult 테이블 결과 업데이트 /// </summary> /// <param name="Result">전달받은 결과값</param> private void UpdateResult(libMyUtil.pageCallingInfo callingInfo, string Result) { libCommon.clsDB objDB = new libCommon.clsDB(); System.Data.SqlClient.SqlConnection dbCon; System.Data.SqlClient.SqlTransaction TRX; string updateResult; if (System.Text.Encoding.Default.GetByteCount(Result) > 1000) { Result = Result.Substring(0, 500); } try { dbCon = objDB.GetConnection(); TRX = dbCon.BeginTransaction(); updateResult = libMyUtil.clsCmnDB.UPDATE_DB(dbCon, TRX, "tb_aURLresult", "RESULT", Result, "aURLidx|FKEY", callingInfo.aURLset_Idx + "|" + callingInfo.FKEY); if (updateResult.Equals("FAIL")) { TRX.Rollback(); objUtil.writeLog(string.Format("FAIL UPDATE URL RESULT\r\nFKEY:{0}\r\nResult:{1}", callingInfo.FKEY, Result)); } else { TRX.Commit(); } dbCon.Close(); } catch (Exception ex) { objUtil.writeLog("ERR UPDATE URL CALL RESULT : " + ex.ToString()); } }
private void insertData(string fileName, string date, string model, string width, string height) { System.Data.SqlClient.SqlConnection dbCon; System.Data.SqlClient.SqlTransaction TRX; libCommon.clsDB objDB = new libCommon.clsDB(); dbCon = objDB.GetConnection(); TRX = dbCon.BeginTransaction(); libMyUtil.clsCmnDB.INSERT_DB(dbCon, TRX, "tb_EXIFdata", "filePath|fileName|date|model|width|height", fileName + "|" + Path.GetFileName(fileName) + "|" + date + "|" + model + "|" + width + "|" + height); TRX.Commit(); dbCon.Close(); }
private void updateData(string fileName, string data) { System.Data.SqlClient.SqlConnection dbCon; System.Data.SqlClient.SqlTransaction TRX; libCommon.clsDB objDB = new libCommon.clsDB(); dbCon = objDB.GetConnection(); TRX = dbCon.BeginTransaction(); libMyUtil.clsCmnDB.UPDATE_DB(dbCon, TRX, "tb_EXIFdata", "model", data, "filePath", fileName); TRX.Commit(); dbCon.Close(); }
public string DELETE_DB(System.Data.SqlClient.SqlConnection dbCon, System.Data.SqlClient.SqlTransaction TRX, string tbName, string Wcols, string Wvals) { int i; string Result = ""; StringBuilder strBuilder = new StringBuilder(); libCommon.clsDB objDB = new libCommon.clsDB(); libCommon.clsUtil objUtil = new libCommon.clsUtil(); System.Collections.ArrayList arrWCols = new System.Collections.ArrayList(); System.Collections.ArrayList arrWVals = new System.Collections.ArrayList(); arrWCols.AddRange(objUtil.Split(Wcols, "|")); arrWVals.AddRange(objUtil.Split(Wvals, "|")); strBuilder.Append("DELETE FROM " + tbName); strBuilder.Append(" WHERE "); for (i = 0; i < arrWCols.Count; i++) { if (i > 0) { strBuilder.Append(" AND "); } strBuilder.Append("["); strBuilder.Append(objUtil.toDb(arrWCols[i].ToString())); strBuilder.Append("]"); strBuilder.Append(" = "); strBuilder.Append("'"); strBuilder.Append(objUtil.toDb(arrWVals[i].ToString())); strBuilder.Append("'"); } try { Result = objDB.ExecuteNonQuery(dbCon, TRX, strBuilder.ToString()); } catch (Exception e) { objUtil.writeLog("ERR CMN DELETE [" + tbName + "] " + "[" + Wcols + "] " + "[" + Wvals + "]"); objUtil.writeLog("ERR CMN DELETE QUERY : " + strBuilder.ToString()); objUtil.writeLog("ERR CMN DELETE MSG : " + e.ToString()); Result = "FAIL"; } return(Result); }
private bool isDupeURL(System.Data.SqlClient.SqlConnection dbCon, System.Data.SqlClient.SqlTransaction TRX, string longURL) { libCommon.clsDB objDB = new libCommon.clsDB(); System.Data.DataSet DS = new System.Data.DataSet(); string QUERY = "SELECT COUNT(*) FROM tb_URL WHERE longURL='" + longURL + "'"; DS = objDB.ExecuteDSQuery(dbCon, TRX, QUERY); if (libMyUtil.clsCmnDB.validateDS(DS)) { return(true); } else { return(false); } }