Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 0.79 KB | None | 0 0
  1. private void UnLockScheduleID(string pk_TemplateId, string exeScheduleID)
  2. {
  3.     string sSQL = string.Format("Update X_arConsImportSet Set exeScheduleID='' Where TemplateId={0} And exeScheduleID={1}"
  4.                         , LibStringBuilder.GetQuotedString(pk_TemplateId)
  5.                         , LibStringBuilder.GetQuotedString(exeScheduleID));
  6.     base.DataAccess.ExecuteNonQuery(sSQL);
  7. }
  8. private bool LockScheduleID(string pk_TemplateId, string exeScheduleID)
  9. {
  10.     string sSQL = string.Format("Update X_arConsImportSet Set exeScheduleID={0} Where TemplateId={1} And exeScheduleID=''"
  11.                         , LibStringBuilder.GetQuotedString(exeScheduleID)
  12.                         , LibStringBuilder.GetQuotedString(pk_TemplateId));
  13.     return (base.DataAccess.ExecuteNonQuery(sSQL) > 0);
  14. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement