public List<VipUserGroupQuery> QueryAll(VipUserGroupQuery query, out int totalCount) { try { return _vipUserGroup.QueryAll(query, out totalCount); } catch (Exception ex) { throw new Exception("VipUserGroupMgr.QueryAll-->" + ex.Message, ex); } }
/// <summary> /// 獲取群組列表 /// </summary> /// <param name="query">實體</param> /// <param name="totalCount">數據的總記錄數</param> /// <returns></returns> public List<VipUserGroupQuery> QueryAll(VipUserGroupQuery query, out int totalCount) { StringBuilder sql = new StringBuilder(); StringBuilder sqlcount = new StringBuilder(); StringBuilder sqlstr = new StringBuilder(); try { sql.AppendLine(@"select group_id,group_name,domain,tax_id,gift_bonus,bonus_rate,bonus_expire_day,"); sql.AppendLine(@"createdate,image_name,group_category,eng_name,check_iden,site_id "); sql.AppendLine(@"from vip_user_group where 1=1 "); sqlcount.AppendFormat(@"select count(group_id) as totalCount from vip_user_group where 1=1 "); //分頁 //if (query.create_dateOne != 0) //{ // sqlstr.AppendFormat(" and createdate>={0}", query.create_dateOne); //} //if (query.create_dateTwo != 0) //{ // sqlstr.AppendFormat(" and createdate<={0}", query.create_dateTwo); //} if (query.group_id != 0) { sqlstr.AppendFormat(" and group_id={0}", query.group_id); } if (!string.IsNullOrEmpty(query.group_name)) { sqlstr.AppendFormat(" and group_name like '%{0}%'", query.group_name); } totalCount = 0; if (query.IsPage) { System.Data.DataTable _dt = _accessMySql.getDataTable(sqlcount.ToString() + sqlstr.ToString()); if (_dt.Rows.Count > 0) { totalCount = Convert.ToInt32(_dt.Rows[0]["totalCount"].ToString()); } sqlstr.AppendFormat(" limit {0},{1}", query.Start, query.Limit); } return _accessMySql.getDataTableForObj<VipUserGroupQuery>(sql.ToString() + sqlstr.ToString()); } catch (Exception ex) { throw new Exception("VipUserGroupDao.QueryAll-->" + ex.Message + sql.ToString(), ex); } }
public string SaveVipUserGroup(VipUserGroupQuery query,DataTable _dt) { string json = "{success:'true'}"; ArrayList arrList = new ArrayList(); VipUser vQuery = new VipUser(); BtobEmp bQuery=new BtobEmp (); int totalCount=0; VipUserGroupQuery oldQuery = new VipUserGroupQuery(); oldQuery = _vipUserGroupDao.GetVipUserGList(query, out totalCount).FirstOrDefault(); try { if (query.file_name == "" && oldQuery != null) { query.file_name = oldQuery.file_name; } query.m_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; query.group_committe_promotion = query.group_committe_promotion + query.group_committe_other; arrList.Add(_vipUserGroupDao.SaveVipUserGroup(query)); bQuery.group_id = query.group_id.ToString(); //excel檔匯入到btob_emp表 #region if (_dt != null) { for (int i = 0; i < _dt.Rows.Count; i++) { if (_dt.Rows[i][0].ToString() != "") { bQuery.emp_id = _dt.Rows[i][0].ToString(); bQuery.id = Convert.ToUInt32(_vipUserGroupDao.GetIdFromBtob(bQuery)); if (bQuery.id != 0) { arrList.Add(_vipUserGroupDao.GetUpdateBtobSql(bQuery)); } else { //emp_id是唯一索引,員工編號在整張表中是唯一的 if (!_vipUserGroupDao.IsEmpIdExist(bQuery)) { arrList.Add(_vipUserGroupDao.GetInsertBtobSql(bQuery)); } } } } } else { } #endregion if (arrList.Count > 0) { if (_vipUserGroupDao.execSql(arrList)) { json = "{success:'true'}"; } else { json = "{success:'false'}"; } } return json; } catch (Exception ex) { throw new Exception("VipUserGroupDao-->SaveVipUserGroup-->" + ex.Message, ex); } }
public string InsertVipUserGroup(VipUserGroupQuery query) { string json = string.Empty; Serial serial = new Serial(); ArrayList arrList = new ArrayList(); try { query.k_date = DateTime.Now; query.m_date = query.k_date; query.k_user = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; query.m_user = query.k_user; serial.Serial_id =72; serial = _ISerialImpl.GetSerialById(serial.Serial_id);//根據ID得到serial_value; query.group_id = Convert.ToUInt32(serial.Serial_Value) + 1;//將serial_value值加1就是group_id; arrList.Add( _vipUserGroupDao.InsertVipUserGroup(query)); arrList.Add(_ISerialImpl.Update(serial.Serial_id));//update serial if (_vipUserGroupDao.execSql(arrList)) { json = "{success:'true',msg:" + query.group_id + "}"; } else { json = "{success:'true',msg:" +0+ "}"; } return json; } catch (Exception ex) { throw new Exception("VipUserGroupDao-->InsertVipUserGroup-->" + ex.Message, ex); } }
public HttpResponseBase InsertVipUserGroup() { string json = string.Empty; try { VipUserGroupQuery query = new VipUserGroupQuery(); if (!string.IsNullOrEmpty(Request.Params["group_name"])) { query.group_name = Request.Params["group_name"]; } if (!string.IsNullOrEmpty(Request.Params["eng_name"])) { query.eng_name = Request.Params["eng_name"]; } if (!string.IsNullOrEmpty(Request.Params["tax_id"])) { query.tax_id = Request.Params["tax_id"]; } if (!string.IsNullOrEmpty(Request.Params["group_code"])) { query.group_code = Request.Params["group_code"]; } if (!string.IsNullOrEmpty(Request.Params["check_iden"])) { query.check_iden = Convert.ToInt32(Request.Params["check_iden"]); } if (!string.IsNullOrEmpty(Request.Params["group_capital"])) { query.group_capital = Convert.ToInt32(Request.Params["group_capital"]); } if (!string.IsNullOrEmpty(Request.Params["group_emp_number"])) { query.group_emp_number = Convert.ToInt32(Request.Params["group_emp_number"]); } if (!string.IsNullOrEmpty(Request.Params["group_emp_age"])) { query.group_emp_age = Request.Params["group_emp_age"]; } if (!string.IsNullOrEmpty(Request.Params["group_emp_gender"])) { query.group_emp_gender = Convert.ToInt32(Request.Params["group_emp_gender"]); } if (!string.IsNullOrEmpty(Request.Params["group_benefit_type"])) { query.group_benefit_type = Request.Params["group_benefit_type"]; } if (!string.IsNullOrEmpty(Request.Params["group_benefit_desc"])) { query.group_benefit_desc = Request.Params["group_benefit_desc"]; } if (!string.IsNullOrEmpty(Request.Params["group_subsidiary"])) { query.group_subsidiary = Convert.ToInt32(Request.Params["group_subsidiary"]); } if (!string.IsNullOrEmpty(Request.Params["group_hq_name"])) { query.group_hq_name = Request.Params["group_hq_name"]; } if (!string.IsNullOrEmpty(Request.Params["group_hq_code"])) { query.group_hq_code = Request.Params["group_hq_code"]; } _vipUserGroup = new VipUserGroupMgr(mySqlConnectionString); json = _vipUserGroup.InsertVipUserGroup(query); } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,msg:'0'}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public HttpResponseBase ExisTaxId() { string json = "{success:true}"; try { VipUserGroupQuery query = new VipUserGroupQuery(); if (!string.IsNullOrEmpty(Request.Params["tax_id"])) { if(!string.IsNullOrEmpty(Request.Params["group_id"])) { query.group_id = Convert.ToUInt32(Request.Params["group_id"]); } query.tax_id = Request.Params["tax_id"]; _vipUserGroup = new VipUserGroupMgr(mySqlConnectionString); if (_vipUserGroup.ExisTaxId(query) > 0) { json = "{success:true}";//tax_id不可用 } else { json = "{success:false}";//tax_id可用 } } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:true}";//emai不可用 } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public JsonResult UpVUGStatus() { { try { VipUserGroupQuery query = new VipUserGroupQuery(); if (!string.IsNullOrEmpty(Request.Params["group_id"].ToString())) { query.group_id = Convert.ToUInt32(Request.Params["group_id"].ToString()); } query.group_status = Convert.ToInt32(Request.Params["active"] ?? "0"); _vipUserGroup = new VipUserGroupMgr(mySqlConnectionString); query.m_user = (Session["caller"] as Caller).user_id; query.m_date = DateTime.Now; int result=_vipUserGroup.UpVUGStatus(query) ; if (result > 0) { return Json(new { success = "true" }); } else if (result == 0)//此企業用戶正在參加活動不可變為禁用 { return Json(new { success = "no" }); } else { return Json(new { success = "false" }); } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); return Json(new { success = "no" }); } } }
public string InsertVipUserGroup(VipUserGroupQuery query) { StringBuilder sql = new StringBuilder(); try { query.Replace4MySQL(); sql.Append("insert into vip_user_group(group_id,group_name,domain,tax_id,group_code, "); sql.Append("group_capital,group_emp_number,group_emp_age,group_emp_gender,group_benefit_type, "); sql.Append("group_benefit_desc,group_subsidiary,group_hq_name,group_hq_code,group_committe_name,"); sql.Append("group_committe_code,group_committe_promotion,"); sql.Append("group_committe_desc, image_name,gift_bonus,createdate,group_category, "); sql.Append("bonus_rate,bonus_expire_day,eng_name,check_iden,site_id,"); sql.Append("group_status,k_user,k_date,m_user,m_date) values( "); sql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',",query.group_id,query.group_name,query.domain,query.tax_id,query.group_code); sql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',",query.group_capital,query.group_emp_number,query.group_emp_age,query.group_emp_gender,query.group_benefit_type); sql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", query.group_benefit_desc, query.group_subsidiary, query.group_hq_name, query.group_hq_code, query.group_committe_name); sql.AppendFormat("'{0}','{1}',", query.group_committe_code, query.group_committe_promotion); sql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',",query.group_committe_desc, query.image_name, query.gift_bonus, query.createdate, query.group_category); sql.AppendFormat("'{0}','{1}','{2}','{3}','{4}',", query.bonus_rate, query.bonus_expire_day, query.eng_name, query.check_iden, query.site_id); sql.AppendFormat("'{0}','{1}','{2}','{3}','{4}');", query.group_status, query.k_user,CommonFunction.DateTimeToString(query.k_date), query.m_user,CommonFunction.DateTimeToString(query.m_date)); return sql.ToString(); } catch (Exception ex) { throw new Exception("VipUserGroupDao-->InsertVipUserGroup-->" + ex.Message + sql.ToString(), ex); } }
public int UpVUGStatus(VipUserGroupQuery query) { int result = 0; try { if (query.group_status ==0) { DataTable _GSDt = _vipUserGroupDao.IsGroupIdStatus(query); if (_GSDt != null && _GSDt.Rows.Count > 0)//有數據不能變為禁用 { result = 0; return result; } } return _vipUserGroupDao.UpVUGStatus(query); } catch (Exception ex) { throw new Exception("VipUserGroupDao-->UpVUGStatus-->" + ex.Message, ex); } }
public HttpResponseBase GetVipUserGroupList() { /********************************************************/ List<VipUserGroupQuery> stores = new List<VipUserGroupQuery>(); string json = string.Empty; try { VipUserGroupQuery query = new VipUserGroupQuery(); int totalCount = 0; query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量 query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "20");//用於分頁的變量 _userGroupMgr = new VipUserGroupMgr(mySqlConnectionString); string group_id_or_group_name = Request.Params["group_id_or_group_name"]; string gName = string.Empty; string gNameSubString = string.Empty; char[] specialChar = { '[', '_', '%' }; int n = 0; //if (!string.IsNullOrEmpty(Request.Params["dateOne"])) //{ // query.create_dateOne = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateOne"]).ToString("yyyy-MM-dd 00:00:00")); //} //if (!string.IsNullOrEmpty(Request.Params["dateTwo"])) //{ // query.create_dateTwo = (uint)CommonFunction.GetPHPTime(Convert.ToDateTime(Request.Params["dateTwo"]).ToString("yyyy-MM-dd 23:59:59")); //} //用於判斷是查詢條件是群組編號/群組名稱, // by zhaozhi0623j,2015/09/22 if (!string.IsNullOrEmpty(group_id_or_group_name)) { uint result = 0; if (uint.TryParse(group_id_or_group_name, out result)) { query.group_id = result; } //查詢條件為群組名稱時,判斷字符串中是否含有"%","_","[" 如有為其前方添加轉意符號"\",便於查詢 else { query.group_name = group_id_or_group_name; gName = group_id_or_group_name; n = gName.IndexOfAny(specialChar); if (n >= 0) { gNameSubString = gName.Substring(n, gName.Length - n); query.group_name = gName.Replace(gNameSubString, "\\" + gNameSubString); } } } System.Net.IPAddress[] addlist = System.Net.Dns.GetHostByName(System.Net.Dns.GetHostName()).AddressList; string ip = string.Empty; if (addlist.Length > 0) { ip = addlist[0].ToString(); } stores = _userGroupMgr.QueryAll(query, out totalCount); foreach (var item in stores) { if (item.image_name != "") { item.image_name = imgServerPath + promoPath + item.image_name; } else { item.image_name = defaultImg; } item.screatedate = CommonFunction.GetNetTime(item.createdate).ToString("yyyy/MM/dd"); item.list = _userGroupMgr.GetVuserCount(item); item.ip = ip; } IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); //这里使用自定义日期格式,如果不使用的话,默认是ISO8601格式 timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; //listUser是准备转换的对象 json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores, Formatting.Indented, timeConverter) + "}";//返回json數據 } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:true,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public int ExisTaxId(VipUserGroupQuery query) { StringBuilder sql = new StringBuilder(); try { query.Replace4MySQL(); sql.AppendFormat("select tax_id from vip_user_group where tax_id='{0}' and group_committe_promotion !='' ", query.tax_id); if (query.group_id != 0) { sql.AppendFormat(" and group_id!='{0}';",query.group_id); } DataTable _dt = _accessMySql.getDataTable(sql.ToString()); if (_dt != null && _dt.Rows.Count > 0) { return 1; } else { return 0; } } catch (Exception ex) { throw new Exception("VipUserGroupDao->ExisTaxId->" + sql.ToString() + ex.Message, ex); } }
public DataTable IsGroupIdStatus(VipUserGroupQuery query) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat("select group_id from promotions_amount_discount where `end`>='{0}' and active='1' and group_id='{1}';",CommonFunction.DateTimeToString(DateTime.Now),query.group_id); return _accessMySql.getDataTable(sql.ToString()); } catch (Exception ex) { throw new Exception("VipUserGroupDao-->IsGroupIdStatus-->" + sql.ToString() + ex.Message, ex); } }
public int UpVUGStatus(VipUserGroupQuery query) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat("set sql_safe_updates=0;update vip_user_group set group_status='{0}',m_user='******',m_date='{2}' where group_id='{3}';set sql_safe_updates=1;", query.group_status,query.m_user,CommonFunction.DateTimeToString(query.m_date), query.group_id); return _accessMySql.execCommand(sql.ToString()); } catch (Exception ex) { throw new Exception("VipUserGroupDao-->UpVUGStatus-->" + sql.ToString() + ex.Message, ex); } }
public List<VipUserGroupQuery> GetVipUserGList(VipUserGroupQuery query, out int totalCount) { StringBuilder sql = new StringBuilder(); StringBuilder sqlFrom = new StringBuilder(); StringBuilder sqlWhere = new StringBuilder(); StringBuilder sqlCount = new StringBuilder(); query.Replace4MySQL(); totalCount = 0; try { sql.Append(" select vug.group_id, vug.group_name, vug.domain , vug.tax_id ,vug.group_code,vug.group_capital ,vug.group_emp_number ,vug.group_emp_age ,vug.group_emp_gender ,vug.group_benefit_type,vug.group_benefit_desc ,vug.group_subsidiary ,vug.group_hq_name ,vug.group_hq_code ,vug.group_committe_name,vug.group_committe_code ,vug.group_committe_promotion,vug.group_committe_desc ,vug.image_name ,vug.gift_bonus ,vug.createdate ,vug.group_category,vug.bonus_rate ,vug.bonus_expire_day ,vug.eng_name ,vug.check_iden ,vug.site_id,vug.group_status ,vug.file_name,vug.k_user ,vug.k_date ,vug.m_user ,vug.m_date,mu1.user_username as 'create_user',mu2.user_username as 'update_user' "); sqlFrom.Append(" from vip_user_group vug "); sqlFrom.Append(" LEFT JOIN manage_user mu1 on vug.k_user=mu1.user_id "); sqlFrom.Append(" LEFT JOIN manage_user mu2 on vug.m_user=mu2.user_id "); sqlWhere.Append(" where 1=1 "); if (query.group_id != 0) { sqlWhere.AppendFormat(" and vug.group_id='{0}' ", query.group_id); } sqlWhere.Append(" and vug.group_committe_promotion !='' "); if (query.tax_name != "") { sqlWhere.AppendFormat(" and (vug.group_name like '%{0}%' or group_code like '%{0}%') ",query.tax_name); } if (query.group_id != 0) { sqlWhere.AppendFormat(" and vug.group_id='{0}' ", query.group_id); } if (query.IsPage) { sqlCount.Append(" select count(vug.group_id) as 'totalCount' " + sqlFrom.ToString() + sqlWhere.ToString()); DataTable _dt = _accessMySql.getDataTable(sqlCount.ToString()); if (_dt.Rows.Count > 0) { totalCount = Convert.ToInt32(_dt.Rows[0][0]); } } sqlWhere.AppendFormat(" order by vug.group_id desc limit {0},{1}; ", query.Start, query.Limit); sql.Append(sqlFrom.ToString() + sqlWhere.ToString()); return _accessMySql.getDataTableForObj<VipUserGroupQuery>(sql.ToString()); } catch (Exception ex) { throw new Exception("VipUserGroupDao-->GetVipUserGList-->" + sql.ToString() + ex.Message, ex); } }
public string SaveVipUserGroup(VipUserGroupQuery query) { StringBuilder sql = new StringBuilder(); try { query.Replace4MySQL(); sql.AppendFormat("set sql_safe_updates=0;update vip_user_group set group_name='{0}',eng_name='{1}',tax_id='{2}',group_code='{3}',group_capital='{4}',check_iden='{5}',", query.group_name, query.eng_name, query.tax_id, query.group_code, query.group_capital,query.check_iden); sql.AppendFormat("group_emp_number='{0}',group_emp_age='{1}',group_emp_gender='{2}',group_benefit_type='{3}',group_benefit_desc='{4}',", query.group_emp_number, query.group_emp_age, query.group_emp_gender, query.group_benefit_type, query.group_benefit_desc); sql.AppendFormat("group_subsidiary='{0}',group_hq_name='{1}',group_hq_code='{2}',", query.group_subsidiary, query.group_hq_name, query.group_hq_code); sql.AppendFormat("group_committe_name='{0}',group_committe_code='{1}',",query.group_committe_name,query.group_committe_code); sql.AppendFormat("group_committe_promotion='{0}',group_committe_desc='{1}',m_user='******',m_date='{3}',file_name='{4}' where group_id='{5}';set sql_safe_updates=1;", query.group_committe_promotion, query.group_committe_desc, query.m_user, CommonFunction.DateTimeToString(DateTime.Now), query.file_name,query.group_id); return sql.ToString(); } catch (Exception ex) { throw new Exception("VipUserGroupDao-->SaveVipUserGroup-->" + ex.Message + sql.ToString(), ex); } }
public List<VipUserGroupQuery> GetVipUserGList(VipUserGroupQuery query, out int totalCount) { try { List<VipUserGroupQuery> store = _vipUserGroupDao.GetVipUserGList(query, out totalCount); if (query.isSecret) { //foreach (var item in store) //{ // item.group_committe_chairman = item.group_committe_chairman.Substring(0, 1) + "**"; // if (item.group_committe_phone.ToString().Length > 3) // { // item.group_committe_phone = item.group_committe_phone.Substring(0, 3) + "***"; // } // else // { // item.group_committe_phone = item.group_committe_phone + "***"; // } // item.group_committe_mail = item.group_committe_mail.Split('@')[0] + "@***"; //} } return store; } catch (Exception ex) { throw new Exception("VipUserGroupDao-->GetVipUserGList-->" + ex.Message, ex); } }
public HttpResponseBase SaveVipUserGroup() { string json = string.Empty; try { VipUserGroupQuery query = new VipUserGroupQuery(); if (!string.IsNullOrEmpty(Request.Params["group_id"])) { query.group_id = Convert.ToUInt32(Request.Params["group_id"]); } if (!string.IsNullOrEmpty(Request.Params["group_name"])) { query.group_name = Request.Params["group_name"]; } if (!string.IsNullOrEmpty(Request.Params["eng_name"])) { query.eng_name = Request.Params["eng_name"]; } if (!string.IsNullOrEmpty(Request.Params["tax_id"])) { query.tax_id = Request.Params["tax_id"]; } if (!string.IsNullOrEmpty(Request.Params["group_code"])) { query.group_code = Request.Params["group_code"]; } if (!string.IsNullOrEmpty(Request.Params["group_capital"])) { query.group_capital = Convert.ToInt32(Request.Params["group_capital"]); } if (!string.IsNullOrEmpty(Request.Params["check_iden"])) { query.check_iden = Convert.ToInt32(Request.Params["check_iden"]); } if (!string.IsNullOrEmpty(Request.Params["group_emp_number"])) { query.group_emp_number = Convert.ToInt32(Request.Params["group_emp_number"]); } if (!string.IsNullOrEmpty(Request.Params["group_emp_age"])) { query.group_emp_age = Request.Params["group_emp_age"]; } if (!string.IsNullOrEmpty(Request.Params["group_emp_gender"])) { query.group_emp_gender = Convert.ToInt32(Request.Params["group_emp_gender"]); } if (!string.IsNullOrEmpty(Request.Params["group_benefit_type"])) { query.group_benefit_type = Request.Params["group_benefit_type"]; } if (!string.IsNullOrEmpty(Request.Params["group_benefit_desc"])) { query.group_benefit_desc = Request.Params["group_benefit_desc"].Replace("\\", "\\\\"); ; } if (!string.IsNullOrEmpty(Request.Params["group_subsidiary"])) { query.group_subsidiary = Convert.ToInt32(Request.Params["group_subsidiary"]); } if (!string.IsNullOrEmpty(Request.Params["group_hq_name"])) { query.group_hq_name = Request.Params["group_hq_name"]; } if (!string.IsNullOrEmpty(Request.Params["group_hq_code"])) { query.group_hq_code = Request.Params["group_hq_code"]; } if (!string.IsNullOrEmpty(Request.Params["group_committe_name"])) { query.group_committe_name = Request.Params["group_committe_name"]; } if (!string.IsNullOrEmpty(Request.Params["group_committe_code"])) { query.group_committe_code = Request.Params["group_committe_code"]; } if (!string.IsNullOrEmpty(Request.Params["group_committe_chairman"])) { query.group_committe_chairman = Request.Params["group_committe_chairman"]; } if (!string.IsNullOrEmpty(Request.Params["group_committe_phone"])) { query.group_committe_phone = (Request.Params["group_committe_phone"]); } if (!string.IsNullOrEmpty(Request.Params["group_committe_mail"])) { query.group_committe_mail = (Request.Params["group_committe_mail"]); } if (!string.IsNullOrEmpty(Request.Params["group_committe_promotion"])) { query.group_committe_promotion = (Request.Params["group_committe_promotion"]); } if (!string.IsNullOrEmpty(Request.Params["group_committe_other"])) { query.group_committe_other = (Request.Params["group_committe_other"]); } if (!string.IsNullOrEmpty(Request.Params["group_committe_desc"])) { query.group_committe_desc = (Request.Params[@"group_committe_desc"]).Replace("\\", "\\\\"); } DataTable _dt=new DataTable(); if (Request.Files.Count > 0) { HttpPostedFileBase excelFile = Request.Files["employee_list"]; query.file_name= excelFile.FileName; FileManagement fileManagement = new FileManagement(); string newExcelName = Server.MapPath(excelPath) + "vip_user_group" + fileManagement.NewFileName(excelFile.FileName); excelFile.SaveAs(newExcelName); NPOI4ExcelHelper helper = new NPOI4ExcelHelper(newExcelName); _dt = helper.SheetData(); } _vipUserGroup = new VipUserGroupMgr(mySqlConnectionString); json = _vipUserGroup.SaveVipUserGroup(query, _dt); } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,msg:'0'}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public int ExisTaxId(VipUserGroupQuery query) { try { return _vipUserGroupDao.ExisTaxId(query); } catch (Exception ex) { throw new Exception("VipUserGroupDao-->ExisTaxId-->" + ex.Message, ex); } }
public HttpResponseBase GetVipUserGList() { string json = string.Empty; try { VipUserGroupQuery query = new VipUserGroupQuery(); List<VipUserGroupQuery> store = new List<VipUserGroupQuery>(); query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25"); int totalCount = 0; if (!string.IsNullOrEmpty(Request.Params["tax_name"])) { query.tax_name = Request.Params["tax_name"].ToString().Trim(); } if (!string.IsNullOrEmpty(Request.Params["relation_id"])) { query.group_id = Convert.ToUInt32(Request.Params["relation_id"]); } if (Request.Params["isSecret"] == "true") { query.isSecret = true; } else { query.isSecret = false; } _vipUserGroup = new VipUserGroupMgr(mySqlConnectionString); store = _vipUserGroup.GetVipUserGList(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}"; } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); json = "{success:false,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }