public string TransDe(string value)
{
if (lblDecoding.Visible)
{
return(CodingTran.Tran(lblDeType.Text, value));
}
else
{
return(value);
}
}
/// <summary>
/// 绑定数据
/// </summary>
public void bind()
{
if (!Common.Validate.IsDateTime(tboxTimeB.Text) || !Common.Validate.IsDateTime(tboxTimeE.Text))
{
Common.MsgBox.Show(this, App_GlobalResources.Language.Tip_TimeError);
return;
}
LabelArea.Text = DropDownListArea1.SelectedItem.Text;
if (DropDownListArea2.SelectedIndex > 0)
{
LabelArea.Text += "|" + DropDownListArea2.SelectedItem.Text;
}
if (DropDownListArea3.SelectedIndex > 0)
{
LabelArea.Text += "|" + DropDownListArea3.SelectedItem.Text;
}
DateTime searchdateB = DateTime.Now;
DateTime searchdateE = DateTime.Now;
if (tboxTimeB.Text.Length > 0)
{
searchdateB = Convert.ToDateTime(tboxTimeB.Text);
}
if (tboxTimeE.Text.Length > 0)
{
searchdateE = Convert.ToDateTime(tboxTimeE.Text);
}
LabelTime.Text = searchdateB.ToString(SmallDateTimeFormat) + " ";
string sqlwhere = " where 1=1 ";
sqlwhere += @" and F_Date='" + searchdateB.ToString(SmallDateTimeFormat) + "'";
if (DropDownListArea1.SelectedIndex > 0)
{
sqlwhere += @" and F_BigZone=" + DropDownListArea1.SelectedValue.Split(',')[1] + "";
}
if (DropDownListArea2.SelectedIndex > 0)
{
sqlwhere += @" and F_ZoneID=" + DropDownListArea2.SelectedValue.Split(',')[1] + "";
}
if (tboxRoleID.Text.Length > 0)
{
sqlwhere += @" and F_RoleID=" + tboxRoleID.Text + "";
}
string sql = "";
sql = @"SELECT distinct top 1 F_RoleName,F_RoleID FROM T_RoleLevelRank " + sqlwhere + @" ";
try
{
ds = DBHelperDigGameDB.Query(sql);
DataView myView = ds.Tables[0].DefaultView;
lblerro.Visible = true;
foreach (DataRow dr in ds.Tables[0].Rows)
{
lblerro.Text = dr["F_RoleID"] + "@@@<br/><hr/>";
if (lblDecoding.Visible)
{
string name1 = "";
if (lblDeType.Text == "100")
{
name1 = CodingTran.TranALL(dr["F_RoleName"].ToString());
}
else if (lblDeType.Text == "101")
{
name1 = CodingTran.TranALL1(dr["F_RoleName"].ToString());
}
else if (lblDeType.Text == "200")
{
name1 = CodingTran.TranALLALL(dr["F_RoleName"].ToString());
}
else if (lblDeType.Text == "300")
{
name1 = CodingTran.TranALLALLALL(dr["F_RoleName"].ToString());
}
if (tboxRoleName.Text.Length > 0)
{
if (name1.IndexOf(tboxRoleName.Text) != -1)
{
lblerro.Text += name1;
}
}
else
{
lblerro.Text += name1;
}
}
else
{
lblerro.Text += dr["F_RoleName"].ToString();
}
lblerro.Text += "<br/><hr/>";
}
}
catch (System.Exception ex)
{
lblerro.Visible = true;
lblerro.Text = App_GlobalResources.Language.LblError + ex.Message;
//lblerro.Text = sql;
}
}
