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; } }