public bool IsDelete(string iID) { bool b = false; sSQL = "select count(*) from SP where S1='" + iID + "'"; int count = clsSQLCommond.Int(sSQL); if (count > 0) { b = true; } return(b); }
public bool CheckDel(string iID, string iType) { sSQL = "SELECT * FROM _TableColInfo where ColSel='LookUpData' and ColSelFlag='" + iType + "' "; DataTable dt = clsSQLCommond.ExecQuery(sSQL); for (int i = 0; i < dt.Rows.Count; i++) { sSQL = "select count(*) from " + dt.Rows[i]["TABLE_CATALOG"].ToString() + "." + dt.Rows[i]["TABLE_SCHEMA"].ToString() + "." + dt.Rows[i]["TABLE_NAME"].ToString() + " where COLUMN_NAME='" + iID + "' "; int iCount = clsSQLCommond.Int(sSQL); if (iCount > 0) { return(false); } } return(true); }
public bool GetVisitorsLog(string id) { ArrayList arrlist = new ArrayList(); sSQL = "select isnull(max(right(SS6,4)),0) as CardID from Visitors where left(SS6,8)='" + DateTime.Now.ToString("yyMMdd") + "'"; string CardID = (clsSQLCommond.Int(sSQL) + 1).ToString(); sSQL = "select * from Visitors where iiID=" + id; DataTable dt = clsSQLCommond.ExecQuery(sSQL); for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["SS6"].ToString() == "") { string newid = CardID; if (newid.Length == 1) { newid = "000" + newid; } else if (newid.Length == 2) { newid = "00" + newid; } else if (newid.Length == 3) { newid = "0" + newid; } newid = DateTime.Now.ToString("yyMMdd") + newid; arrlist.Add("update Visitors set DDate1='" + DateTime.Now.ToString() + "',II2='2',SS6='" + newid + "' where AutoID=" + dt.Rows[i]["AutoID"].ToString()); CardID = CardID + 1; } } try { clsSQLCommond.ExecSqlTran(arrlist); } catch { return(false); } return(true); }