Database Reference
In-Depth Information
public static int GetLabelID(string UserLabel)
{
int UserLabelID = 0;
string SqlStr = “select [dbo].GetLabelID('” +
UserLabel + “') “;
UserLabelID = int.Parse(DBOperations.
GetData(SqlStr).Tables 0].Rows[0][0].ToString());
return UserLabelID;
}
public static string GetBCLabel(int UserLabelID)
{
string UserLabel = “”;
string UChar = “”;
string CChar = “”;
string TSChar = “”;
string TSChar = “”;
UChar = (UserLabelID% 4).ToString();
UserLabelID = UserLabelID/4;
CChar = (UserLabelID% 4).ToString();
UserLabelID = UserLabelID/4;
TSChar = (UserLabelID% 4).ToString();
UserLabelID = UserLabelID/4;
TSChar = (UserLabelID% 4).ToString();
if (UChar = = “1”)
{
UserLabel = UserLabel + “-U”;
}
else if (UChar = = “2”)
{
UserLabel = UserLabel + “U” ;
}
if (CChar = = “1”)
{
UserLabel = UserLabel + “-C” ;
}
else if (CChar = = “2”)
{
UserLabel = UserLabel + “C”;
}
if (SChar = = “1”)
{
UserLabel = UserLabel + “-S”;
}
else if (SChar = = “2”)
Search WWH ::




Custom Search