public string makeEmpMultiUpdateQuery(DetailUnit _du)
{
string preString = "update EMP set ";
string whereString = "";
string setString = "";
if (_du.getMultiEmp().Equals(""))
{
return(null);
}
whereString = " where " + getMultiWhereString(_du.getMultiEmp(), "$", "ID");
if (_du.getDepartment() != -1)
{
if (!setString.Equals(""))
{
setString = setString + ", ";
}
setString = setString + "DEPARTMENT = " + _du.getDepartment();
}
if (_du.getDivision() != -1)
{
if (!setString.Equals(""))
{
setString = setString + ", ";
}
setString = setString + "DIVISION = " + _du.getDivision();
}
if (_du.getTitle() != -1)
{
if (!setString.Equals(""))
{
setString = setString + ", ";
}
setString = setString + "TITLE = " + _du.getTitle();
}
if (setString.Equals(""))
{
return(null);
}
setString = setString + ", MODIFY_DATE = GETDATE()";
return(preString + setString + whereString);
}
public string makeBadgeMultiUpdateQuery(DetailUnit _du)
{
string preString = "update BADGE set ";
string whereString = "";
string setString = "";
if (_du.getMultiEmp().Equals(""))
{
return(null);
}
whereString = " where " + getMultiWhereString(_du.getMultiBid(), "$", "BID");
if (_du.getBadgeType() != -1)
{
if (!setString.Equals(""))
{
setString = setString + ", ";
}
setString = setString + "TYPE = " + _du.getBadgeType();
}
if (_du.getBadgeStatus() != -1)
{
if (!setString.Equals(""))
{
setString = setString + ", ";
}
setString = setString + "STATUS_1 = " + _du.getBadgeStatus();
}
if (_du.getBadgeFormat() != -1)
{
if (!setString.Equals(""))
{
setString = setString + ", ";
}
setString = setString + "FORMAT = " + _du.getBadgeFormat();
}
if (_du.getDeactive() != DateTime.Now.AddYears(-10))
{
if (!setString.Equals(""))
{
setString = setString + ", ";
}
setString = setString + "DEACTIVATE_DATE = " + getCastString(getDate(_du.getDeactive()));
}
if (!_du.getByPass().Equals(""))
{
if (!setString.Equals(""))
{
setString = setString + ", ";
}
setString = setString + "BYPASS_FLAG = " + _du.getByPass();
}
if (_du.getPT() != -1)
{
if (!setString.Equals(""))
{
setString = setString + ", ";
}
setString = setString + "PT = " + _du.getPT();
}
if (!_du.getRight1().Equals(""))
{
if (!setString.Equals(""))
{
setString = setString + ", ";
}
setString = setString + "RIGHT_1 = '" + _du.getRight1() + "'";
}
if (!_du.getRight2().Equals(""))
{
if (!setString.Equals(""))
{
setString = setString + ", ";
}
setString = setString + "RIGHT_2 = '" + _du.getRight2() + "'";
}
if (!_du.getRight3().Equals(""))
{
if (!setString.Equals(""))
{
setString = setString + ", ";
}
setString = setString + "RIGHT_3 = '" + _du.getRight3() + "'";;
}
if (!_du.getRight4().Equals(""))
{
if (!setString.Equals(""))
{
setString = setString + ", ";
}
setString = setString + "RIGHT_4 = '" + _du.getRight4() + "'";;
}
if (setString.Equals(""))
{
return(null);
}
setString = setString + ", MODIFY_DATE = GETDATE()";
return(preString + setString + whereString);
}