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