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