public static bool IsExistData(ExMySQLData db,
string companyId,
string groupId,
string tblName,
string col1Name,
string col1Value,
string col2Name,
string col2Value,
CommonUtl.geStrOrNumKbn col1Type)
{
StringBuilder sb;
DataTable dt;
try
{
sb = new StringBuilder();
#region SQL
sb.Append("SELECT TBL.* " + Environment.NewLine);
sb.Append(" FROM " + tblName + " AS TBL" + Environment.NewLine);
sb.Append(" WHERE TBL.DELETE_FLG = 0 " + Environment.NewLine);
if (companyId != "")
{
sb.Append(" AND TBL.COMPANY_ID = " + companyId + Environment.NewLine);
}
if (groupId != "")
{
sb.Append(" AND TBL.GROUP_ID = " + groupId + Environment.NewLine);
}
if (col1Type == CommonUtl.geStrOrNumKbn.String)
{
sb.Append(" AND TBL." + col1Name + " = " + ExEscape.zRepStr(col1Value) + Environment.NewLine);
sb.Append(" AND TBL." + col2Name + " <> " + ExEscape.zRepStr(col2Value) + Environment.NewLine);
}
else
{
sb.Append(" AND TBL." + col1Name + " = " + ExCast.zCDbl(col1Value) + Environment.NewLine);
sb.Append(" AND TBL." + col2Name + " <> " + ExCast.zCDbl(col2Value) + Environment.NewLine);
}
sb.Append(" LIMIT 0, 1" + Environment.NewLine);
#endregion
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".IsExistData", ex);
throw;
}
finally
{
}
}
public static void GetData(ExMySQLData db,
string companyId,
string groupId,
string tblName,
string col1Name,
string col1Value,
CommonUtl.geStrOrNumKbn col1Type,
string get_col1Name,
string get_col2Name,
string get_col3Name,
string get_col4Name,
string get_col5Name,
string get_another_col1Name,
string get_another_col2Name,
string get_another_col3Name,
string get_another_col4Name,
string get_another_col5Name,
ref string get_col1Value,
ref string get_col2Value,
ref string get_col3Value,
ref string get_col4Value,
ref string get_col5Value)
{
StringBuilder sb;
DataTable dt;
try
{
sb = new StringBuilder();
#region SQL
sb.Append("SELECT " + get_col1Name + Environment.NewLine);
if (!string.IsNullOrEmpty(get_col2Name)) sb.Append(" ," + get_col2Name + Environment.NewLine);
if (!string.IsNullOrEmpty(get_col3Name)) sb.Append(" ," + get_col3Name + Environment.NewLine);
if (!string.IsNullOrEmpty(get_col4Name)) sb.Append(" ," + get_col4Name + Environment.NewLine);
if (!string.IsNullOrEmpty(get_col5Name)) sb.Append(" ," + get_col5Name + Environment.NewLine);
sb.Append(" FROM " + tblName + " AS TBL" + Environment.NewLine);
sb.Append(" WHERE TBL.DELETE_FLG = 0 " + Environment.NewLine);
if (companyId != "")
{
sb.Append(" AND TBL.COMPANY_ID = " + companyId + Environment.NewLine);
}
if (groupId != "")
{
sb.Append(" AND TBL.GROUP_ID = " + groupId + Environment.NewLine);
}
if (col1Type == CommonUtl.geStrOrNumKbn.String)
{
sb.Append(" AND TBL." + col1Name + " = " + ExEscape.zRepStr(col1Value) + Environment.NewLine);
}
else
{
sb.Append(" AND TBL." + col1Name + " = " + ExCast.zCDbl(col1Value) + Environment.NewLine);
}
sb.Append(" LIMIT 0, 1" + Environment.NewLine);
#endregion
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
get_col1Value = ExCast.zCStr(dt.DefaultView[0][get_another_col1Name]);
if (!string.IsNullOrEmpty(get_col2Name)) get_col2Value = ExCast.zCStr(dt.DefaultView[0][get_another_col2Name]);
if (!string.IsNullOrEmpty(get_col3Name)) get_col3Value = ExCast.zCStr(dt.DefaultView[0][get_another_col3Name]);
if (!string.IsNullOrEmpty(get_col4Name)) get_col4Value = ExCast.zCStr(dt.DefaultView[0][get_another_col4Name]);
if (!string.IsNullOrEmpty(get_col5Name)) get_col5Value = ExCast.zCStr(dt.DefaultView[0][get_another_col5Name]);
}
else
{
get_col1Value = "";
get_col2Value = "";
get_col3Value = "";
get_col4Value = "";
get_col5Value = "";
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetData", ex);
throw;
}
finally
{
}
}
