/// <summary> /// 获取该供应商下所关联的所有联系人信息 /// </summary> /// <param name="suppId"></param> /// <returns></returns> private void GetAllContacts(string suppId) { //string conId = string.Empty; //DataTable dt_contacts = new DataTable(); //DataTable dt_base_contacts = DBHelper.GetTable("查询关联的联系人ID集合", "tr_base_contacts", "cont_id", " relation_object_id='" + suppId + "'", "", ""); //if (dt_base_contacts != null && dt_base_contacts.Rows.Count > 0) //{ // foreach (DataRow dr in dt_base_contacts.Rows) // { // conId += "'" + dr["cont_id"] + "',"; // } // conId = conId.Trim(','); // gvUserInfoList.DataSource = DBHelper.GetTable("查询关联的联系人信息", "tb_contacts", "*", " cont_id in (" + conId + ")", "", ""); //} string conId = string.Empty; DataTable dt_base_contacts = DBHelper.GetTable("查询关联的联系人ID集合", "tr_base_contacts", "*", " relation_object_id='" + suppId + "'", "", ""); if (dt_base_contacts != null && dt_base_contacts.Rows.Count > 0) { isdefault defaultModel = new isdefault(); List <isdefault> list_default = new List <isdefault>(); foreach (DataRow dr in dt_base_contacts.Rows) { conId += "'" + dr["cont_id"] + "',"; defaultModel = new isdefault(); defaultModel.cont_id = dr["cont_id"].ToString(); defaultModel.is_default = dr["is_default"] == null || dr["is_default"].ToString() == "" ? "0" : dr["is_default"].ToString(); list_default.Add(defaultModel); } conId = conId.Trim(','); string TableName = string.Format(@"(select dic_name as con_post_name,tb_contacts.* from tb_contacts left join sys_dictionaries on tb_contacts.cont_post=sys_dictionaries.dic_id) as tb_contacts"); DataTable dt_contacts = DBHelper.GetTable("查询关联的联系人信息", TableName, string.Format("*,{0} phone,{1} tel", EncryptByDB.GetDesFieldValue("cont_phone"), EncryptByDB.GetDesFieldValue("cont_tel")), " cont_id in (" + conId + ")", "", ""); foreach (DataRow dr in dt_contacts.Rows) { DataGridViewRow dgvr = gvUserInfoList.Rows[gvUserInfoList.Rows.Add()]; dgvr.Cells["colcont_id"].Value = dr["cont_id"]; dgvr.Cells["colcont_name"].Value = dr["cont_name"]; dgvr.Cells["colcont_post"].Value = dr["con_post_name"]; dgvr.Cells["colcont_phone"].Value = dr["phone"]; dgvr.Cells["colcont_tel"].Value = dr["tel"]; dgvr.Cells["colremark"].Value = dr["remark"]; dgvr.Cells["colcont_email"].Value = dr["cont_email"]; if (list_default.Count > 0) { dgvr.Cells["colis_default"].Value = list_default.Where(p => p.cont_id == dr["cont_id"].ToString()).First().is_default; } string createTime = CommonCtrl.IsNullToString(dr["cont_birthday"]); if (createTime.Length > 0) { dgvr.Cells["colcont_birthday"].Value = DateTime.MinValue.AddTicks(Convert.ToInt64(createTime)).ToLocalTime(); } } } }
/// <summary> /// 获取该供应商下所关联的所有联系人信息 /// </summary> /// <param name="suppId"></param> /// <returns></returns> private void GetAllContacts(string suppId) { //string conId = string.Empty; //DataTable dt_contacts = new DataTable(); //DataTable dt_base_contacts = DBHelper.GetTable("查询关联的联系人ID集合", "tr_base_contacts", "cont_id", " relation_object_id='" + suppId + "'", "", ""); //if (dt_base_contacts != null && dt_base_contacts.Rows.Count > 0) //{ // foreach (DataRow dr in dt_base_contacts.Rows) // { // conId += "'" + dr["cont_id"] + "',"; // } // conId = conId.Trim(','); // gvUserInfoList.DataSource = DBHelper.GetTable("查询关联的联系人信息", "tb_contacts", "*", " cont_id in (" + conId + ")", "", ""); //} string conId = string.Empty; DataTable dt_base_contacts = DBHelper.GetTable("查询关联的联系人ID集合", "tr_base_contacts", "*", " relation_object_id='" + suppId + "'", "", ""); if (dt_base_contacts != null && dt_base_contacts.Rows.Count > 0) { isdefault defaultModel = new isdefault(); List<isdefault> list_default = new List<isdefault>(); foreach (DataRow dr in dt_base_contacts.Rows) { conId += "'" + dr["cont_id"] + "',"; defaultModel = new isdefault(); defaultModel.cont_id = dr["cont_id"].ToString(); defaultModel.is_default = dr["is_default"] == null || dr["is_default"].ToString() == "" ? "0" : dr["is_default"].ToString(); list_default.Add(defaultModel); } conId = conId.Trim(','); string TableName = string.Format(@"(select dic_name as con_post_name,tb_contacts.* from tb_contacts left join sys_dictionaries on tb_contacts.cont_post=sys_dictionaries.dic_id) as tb_contacts"); DataTable dt_contacts = DBHelper.GetTable("查询关联的联系人信息", TableName, string.Format("*,{0} phone,{1} tel", EncryptByDB.GetDesFieldValue("cont_phone"), EncryptByDB.GetDesFieldValue("cont_tel")), " cont_id in (" + conId + ")", "", ""); foreach (DataRow dr in dt_contacts.Rows) { DataGridViewRow dgvr = gvUserInfoList.Rows[gvUserInfoList.Rows.Add()]; dgvr.Cells["colcont_id"].Value = dr["cont_id"]; dgvr.Cells["colcont_name"].Value = dr["cont_name"]; dgvr.Cells["colcont_post"].Value = dr["con_post_name"]; dgvr.Cells["colcont_phone"].Value = dr["phone"]; dgvr.Cells["colcont_tel"].Value = dr["tel"]; dgvr.Cells["colremark"].Value = dr["remark"]; dgvr.Cells["colcont_email"].Value = dr["cont_email"]; if (list_default.Count > 0) { dgvr.Cells["colis_default"].Value = list_default.Where(p => p.cont_id == dr["cont_id"].ToString()).First().is_default; } string createTime = CommonCtrl.IsNullToString(dr["cont_birthday"]); if (createTime.Length > 0) { dgvr.Cells["colcont_birthday"].Value = DateTime.MinValue.AddTicks(Convert.ToInt64(createTime)).ToLocalTime(); } } } }