public string getSurveyNotRepeatItem(long SID, long UID) { string str; Label_0017: str = ""; //objComm.CommandText = "SELECT TOP 1 ExpandContent FROM SurveyExpand WHERE SID=" + SID.ToString() + " AND UID=" + UID.ToString() + " AND ExpandType=2"; SqlDataReader reader = new checkState_Layer().GetSurveyExpand(SID.ToString(), UID.ToString(), "2"); int num = 0; Label_0002: switch (num) { case 0: if (!reader.Read()) { break; } num = 1; goto Label_0002; case 1: str = reader["ExpandContent"].ToString(); num = 2; goto Label_0002; case 2: break; default: goto Label_0017; } reader.Dispose(); return(str); }
public int getUID(long SID) { Label_0017: int num = 0; //objComm.CommandText = "SELECT TOP 1 UID FROM SurveyTable WHERE SID=" + SID.ToString(); SqlDataReader reader = new checkState_Layer().GetSurveyTable1(SID.ToString()); int num2 = 1; Label_0002: switch (num2) { case 0: break; case 1: if (!reader.Read()) { break; } num2 = 2; goto Label_0002; case 2: num = Convert.ToInt32(reader["UID"]); num2 = 0; goto Label_0002; default: goto Label_0017; } reader.Dispose(); return(num); }
public int getSurveyStatus(OleDbCommand objComm, long SID, long UID) { int num; Label_0017: num = 0; objComm.CommandText = "SELECT TOP 1 State FROM SurveyTable WHERE SID=" + SID.ToString() + " AND UID=" + UID.ToString(); SqlDataReader reader = new checkState_Layer().GetSurveyTable(SID.ToString(), UID.ToString()); int num2 = 0; Label_0002: switch (num2) { case 0: if (!reader.Read()) { break; } num2 = 2; goto Label_0002; case 1: break; case 2: num = Convert.ToInt32(reader["State"]); if ((1 != 0) && (0 != 0)) { } num2 = 1; goto Label_0002; default: goto Label_0017; } reader.Dispose(); return(num); }