void txtcCustName_GetDataSourced(TextChooser tc, string sqlString) { try { if (sqlString.Contains("tb_customer")) { string fileds = "cust_name,cust_code"; sqlString = sqlString.Replace("*", fileds); } else if (sqlString.Contains("tb_supplier")) { string fileds = "sup_code,sup_full_name"; sqlString = sqlString.Replace("*", fileds); } DataTable dvt = CommonFuncCall.GetDataSource(sqlString); tc.SetDataSource(dvt); if (dvt != null) { tc.Search(); } } catch (Exception ex) { HXCPcClient.GlobalStaticObj.GlobalLogService.WriteLog(ex); } }
/// <summary> 绑定配件类型名称到选择器 /// </summary> /// <param name="tc"></param> /// <param name="sqlString"></param> private static void PartsType_NameBindData(TextChooser tc, string sqlString) { // sqlString = string.Format(@"select dic_name from sys_dictionaries where dic_id not in // (select parent_id from sys_dictionaries) and dic_name like '%{0}%'", tc.Text); // DataTable dt = CommonFuncCall.GetDataSource(sqlString); // tc.SetDataSource(dt); // if (dt != null) // { // tc.Search(); // } string dic_ids = string.Empty; List <string> list_dic_id = new List <string>(); CreateTreeViewChildNode(list_dic_id, "sys_parts_category"); if (list_dic_id.Count > 0) { foreach (string dic_id in list_dic_id) { dic_ids += "'" + dic_id + "',"; } } dic_ids = dic_ids.Trim(','); sqlString = string.Format(@"select dic_name from sys_dictionaries where dic_id in ({0}) and dic_name like '%{1}%'", dic_ids, tc.Text); DataTable dt = CommonFuncCall.GetDataSource(sqlString); tc.SetDataSource(dt); if (dt != null) { tc.Search(); } }
/// <summary> /// 设置速查 /// </summary> /// <param name="sqlString"></param> void tc_GetDataSourced(TextChooser tc, string sqlString) { DataTable dvt = CommonFuncCall.GetDataSource(sqlString); tc.SetDataSource(dvt); if (dvt != null) { tc.Search(); } }
/// <summary> 绑定供应商名称到选择器 /// </summary> /// <param name="tc"></param> /// <param name="sqlString"></param> private static void Sup_NameBindData(TextChooser tc, string sqlString) { DataTable dt = CommonFuncCall.GetDataSource(sqlString); tc.SetDataSource(dt); if (dt != null) { tc.Search(); } }
private void Sup_CodeBindData(string sqlString) { DataTable dt = CommonFuncCall.GetDataSource(sqlString); this.txtsup_code.SetDataSource(dt); if (dt != null) { this.txtsup_code.Search(); } }
void txtBelongCompany_GetDataSourced(ServiceStationClient.ComponentUI.TextBox.TextChooser tc, string sqlString) { sqlString = string.Format("select * from sys_user where user_name like '%{0}%' and enable_flag=1 and status=1", txtcreate_by.Text); DataTable dvt = CommonFuncCall.GetDataSource(sqlString); tc.SetDataSource(dvt); if (dvt != null) { tc.Search(); } }
void txtparent_id_GetDataSourced(ServiceStationClient.ComponentUI.TextBox.TextChooser tc, string sqlString) { sqlString = string.Format("select * from v_dictionaries where dic_name like '%{0}%' and enable_flag=1 ", txtparent_id.Text); DataTable dvt = CommonFuncCall.GetDataSource(sqlString); tc.SetDataSource(dvt); if (dvt != null) { tc.Search(); } }
/// <summary> 绑定配件类型名称到选择器 /// </summary> /// <param name="tc"></param> /// <param name="sqlString"></param> private static void PartsType_NameBindData(TextChooser tc, string sqlString) { sqlString = string.Format(@"select dic_name from sys_dictionaries where dic_id not in (select parent_id from sys_dictionaries) and dic_name like '%{0}%'", tc.Text); DataTable dt = CommonFuncCall.GetDataSource(sqlString); tc.SetDataSource(dt); if (dt != null) { tc.Search(); } }
/// <summary> /// 设置速查 /// </summary> /// <param name="sqlString"></param> void tc_GetDataSourced(TextChooser tc, string sqlString) { if (sqlString.Contains("v_vehicle")) { string fileds = string.Format(" license_plate,vin,engine_num,v_model,v_brand,v_color,turner,cust_code,cust_id,cust_name,cont_name,{0} phone ", EncryptByDB.GetDesFieldValue("cont_phone")); sqlString = sqlString.Replace("*", fileds); } DataTable dvt = CommonFuncCall.GetDataSource(sqlString); tc.SetDataSource(dvt); if (dvt != null) { tc.Search(); } }
/// <summary> /// 设置速查 /// </summary> /// <param name="sqlString"></param> void tc_GetDataSourced(TextChooser tc, string sqlString) { try { DataTable dvt = CommonFuncCall.GetDataSource(sqlString); tc.SetDataSource(dvt); if (dvt != null) { tc.Search(); } } catch (Exception ex) { HXCPcClient.GlobalStaticObj.GlobalLogService.WriteLog(ex); } }
void txtcParts_GetDataSourced(TextChooser tc, string sqlString) { try { string fileds = "parts_name,ser_parts_code"; sqlString = sqlString.Replace("*", fileds); DataTable dvt = CommonFuncCall.GetDataSource(sqlString); tc.SetDataSource(dvt); if (dvt != null) { tc.Search(); } } catch (Exception ex) { HXCPcClient.GlobalStaticObj.GlobalLogService.WriteLog(ex); } }