public EnterpriseInfo Get()
{
var model = new EnterpriseInfo();
var hotels = ProcessInvoke <HotelRestaurantProcess>().HotelsInDistrict(Guid.Parse("B20071A6-A30E-9FAD-4C7F-4C353641A645"));
foreach (var hotel in hotels)
{
var enterp = new Enterprise()
{
QYBM = hotel.ProjectCode,
QYMC = $"{hotel.RaletedCompany.CompanyName}({hotel.ProjectName})",
QYDZ = hotel.AddressDetail,
PER = hotel.ChargeMan,
TEL = hotel.Telephone,
QYSTREET = hotel.Street.ItemValue,
XPOS = hotel.Longitude.ToString(),
YPOS = hotel.Latitude.ToString(),
};
var devs = ProcessInvoke <RestaurantDeviceProcess>().GetDevicesByRestaurant(hotel.Id);
if (devs.Count > 0)
{
enterp.CASE_ID = $"HPLB{devs.First().DeviceNodeId.Substring(4, 4)}";
enterp.CASE_NAM = devs.First().DeviceName;
}
model.data.Add(enterp);
}
model.result = "success";
return(model);
}
public QYKQ_04_Dal(string name, EnterpriseInfo content, DateTime time)
{
this.Name = name;
this.Content = content;
this.Time = time;
this.QYCode = this.Content.QIYECODE;
}
public IHttpActionResult GetEntSiteListByEnterpriseID(EnterpriseInfo enterpriseInfo)
{
try
{
var page = GetPageResult(EntSiteInfoContract.EntSiteInfo.Where(m => m.Enterprise.Id == enterpriseInfo.Id), m => new
{
m.Id,
m.SiteName,
m.SiteCode,
m.SitePhone,
m.SiteManager,
Enterprise_Id = m.Enterprise.Id,
m.Enterprise.EnterpriseName,
m.Description,
m.Remark,
m.CreatedTime,
m.CreatorUserId,
m.LastUpdatedTime,
m.LastUpdatorUserId
});
return(Json(new OperationResult(OperationResultType.Success, "读取某企业下厂区信息列表数据成功！", page)));
}
catch (Exception ex)
{
return(Json(new OperationResult(OperationResultType.Error, "读取某企业下厂区信息列表数据失败！", ex.ToString())));
}
}
public bool SendInvoiceToMail(string ToEmail, Attachment attach)
{
CultureInfo culture = new CultureInfo("vi-VN");
EnterpriseInfo seller = EnterpriseInfo_DAO.Instance.LoadEnterpriseInfoById(Account_DAO.Instance.CheckUsername());
Invoice bill = Invoice_DAO.Instance.GetListInvoiceByInvoiceNumber(attach.Name);
string Title = "HÓA ĐƠN BÁN HÀNG " + seller.EnterpriseName;
string Content = " Kính gửi Quý Khách hàng,\n\n" +
" Hóa đơn của quý khách bao gồm:" +
"\n\n - Mã số thuế đơn vị phát hành: " + seller.EnterpriseTaxCode +
"\n\n - Mã số hóa đơn: " + bill.InvoiceNumber +
"\n\n - Ngày lập: " + bill.InvoiceIssuedDate.ToString("dd/MM/yyyy") +
"\n\n - Tên người mua: " + bill.BuyerLegalName +
"\n\n - Tông tiền thanh toán: " + bill.TotalAmountAfterDiscount.ToString("c0", culture) +
"\n\n - Tiền bằng chữ: " + bill.TotalAmountInWords +
"\n\n" + seller.EnterpriseName + " xin trân trọng cảm ơn Quý khách đã sử dụng sản phẩm/dịch vụ của chúng tôi!";
try
{
MailMessage mail = new MailMessage(GetEmail().EmailAddress, ToEmail, Title, Content);
SmtpClient client = new SmtpClient(GetEmail().Server);
client.Port = GetEmail().Port;
client.Credentials = new System.Net.NetworkCredential(GetEmail().EmailAddress, GetEmail().Pass);
client.EnableSsl = true;
mail.Attachments.Add(attach);
client.Send(mail);
InsertMailDeliveryHistory(ToEmail, bill.BuyerLegalName, bill.InvoiceNumber, true, "");
return(true);
}
catch (Exception ex)
{
string detailError = ex.Message;
InsertMailDeliveryHistory(ToEmail, bill.BuyerLegalName, bill.InvoiceNumber, false, detailError);
return(false);
}
}
public bool Execute()
{
try
{
if (!QYCode.StartsWith("KQ"))
{
MyLibrary.Log.Debug(Name + "_文件名称没有标识符'KQ'；企业号码：" + QYCode);
return(true);
}
EnterpriseInfo NewUserList = MyLibrary.Json.DeserializeObject(Content, typeof(EnterpriseInfo)) as EnterpriseInfo;
QYKQ_04_Dal q = new QYKQ_04_Dal(Name, NewUserList, Time);
string Result = q.Handle();
if (Result != "0")
{
MyLibrary.Log.Error(Name + "错误；" + Result + " 企业号码：" + QYCode);
}
}
catch (Exception ex)
{
MyLibrary.Log.Error(Name + "错误；" + ex.Message + " 企业号码：" + QYCode);
}
return(true);
}
public JsonResult AddInfo(EnterpriseInfo enterpriseInfo)
{
Admin adminId = Session["AdminInfo"] as Admin;
enterpriseInfo.Admin = adminId;
info = bll.AddInfo(enterpriseInfo);
return(Json(info));
}
public async Task <int> createEntAcount(EntRegisterInfo entRegisterInfo)
{
var user = new UserRequest()
{
Username = entRegisterInfo.Username, Password = entRegisterInfo.Password
};
var acount = await _acountService.get(user);
if (acount != null)
{
return(0);
}
else
{
//var newacc = await _acountService.create(entRegisterInfo.Username, entRegisterInfo.Password, "ROLE_ENTERPRISE");
var newacc = new Acount()
{
Username = entRegisterInfo.Username,
Password = entRegisterInfo.Password,
ObjectRole = "ROLE_ENTERPRISE"
};
_dbContext.Acounts.Add(newacc);
var ent = new Enterprise()
{
Name = entRegisterInfo.Name,
Email = entRegisterInfo.Email,
Phone = entRegisterInfo.Phone,
Skype = entRegisterInfo.Skype,
Position = entRegisterInfo.Position
};
if (entRegisterInfo.Gender == "male")
{
ent.Gender = true;
}
else
{
ent.Gender = false;
}
_dbContext.Enterprises.Add(ent);
ent.Acount = newacc;
var entInfo = new EnterpriseInfo()
{
Company_Name = entRegisterInfo.Company_name,
Tax_Code = entRegisterInfo.Tax_code,
Area = entRegisterInfo.Area,
Phone = entRegisterInfo.Company_phone,
Email = entRegisterInfo.Company_Email,
Website = entRegisterInfo.Website,
Scale = entRegisterInfo.Scale
};
_dbContext.EnterpriseInfos.Add(entInfo);
entInfo.Enterprise = ent;
return(await _dbContext.SaveChangesAsync());
}
}
/// <summary>
/// 获取上传数据。
/// </summary>
/// <returns></returns>
private EnterpriseInfo GetData()
{
EnterpriseInfo result = null;
using (StreamReader file = File.OpenText(@"JsonData\EnterpriseInfo.json"))
{
JsonSerializer serializer = new JsonSerializer();
result = (EnterpriseInfo)serializer.Deserialize(file, typeof(EnterpriseInfo));
}
return(result);
}
public List <EnterpriseInfo> LoadEnterpriseInfo(string taxcode)
{
List <EnterpriseInfo> list = new List <EnterpriseInfo>();
DataTable data = DataProvider.Instance.ExcuteQuery("select * from ThongTinDoanhNghiep where MST = " + taxcode);
foreach (DataRow item in data.Rows)
{
EnterpriseInfo l = new EnterpriseInfo(item);
list.Add(l);
}
return(list);
}
/// <summary>
/// 添加企业信息
/// </summary>
/// <returns></returns>
public ResultInfo.Info AddInfo(EnterpriseInfo enterpriseInfo)
{
if (enterpriseInfo != null)
{
info.ResultType = ResultInfo.BaseResultType.IsNull;
if (string.IsNullOrEmpty(enterpriseInfo.Title))
{
info.Msg = "标题不能为空！";
}
else if (enterpriseInfo.HtmlRegion == null)
{
info.Msg = "请选择所在区域！";
}
else if (enterpriseInfo.Content == null)
{
info.Msg = "内容不能为空！";
}
else
{
var updateData = db.EnterpriseInfo.Where(p => p.Id == enterpriseInfo.Id);
if (updateData.Count() > 0)//如果事先存在，那么就执行修改
{
var data = updateData.FirstOrDefault();
data.Content = enterpriseInfo.Content;
data.Title = enterpriseInfo.Title;
data.Admin = db.Attach(enterpriseInfo.Admin, p => p.Id);
data.HtmlRegion = db.Attach(enterpriseInfo.HtmlRegion, p => p.Id);
data.AddDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
enterpriseInfo.Admin = db.Attach(enterpriseInfo.Admin, p => p.Id);
enterpriseInfo.HtmlRegion = db.Attach(enterpriseInfo.HtmlRegion, p => p.Id);
//基础数据处理
enterpriseInfo.AddDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
db.EnterpriseInfo.Add(enterpriseInfo);
}
db.SaveChanges();
info.Msg = "保存成功";
info.ResultType = ResultInfo.BaseResultType.Success;
}
}
else
{
info.Msg = "保存失败";
info.ResultType = ResultInfo.BaseResultType.Error;
}
return(info);
}
/// <summary>
/// 获取所有企业
/// </summary>
/// <returns></returns>
public ReturnMessage <List <CodeNameDTO> > GetEnterprises()
{
ReturnMessage <List <CodeNameDTO> > ret = new ReturnMessage <List <CodeNameDTO> >();
List <CodeNameDTO> dtoList = new List <CodeNameDTO>();
EnterpriseInfo enterpriseInfo = new EnterpriseInfo();
List <Enterprise> allEnterpriseForPortal = enterpriseInfo.GetAllEnterpriseForPortal();
foreach (Enterprise enterprise in allEnterpriseForPortal)
{
CodeNameDTO codeNameDTO = new CodeNameDTO();
codeNameDTO.Code = enterprise.Code;
codeNameDTO.Name = enterprise.Name;
dtoList.Add(codeNameDTO);
}
ret.Result = dtoList;
return(ret);
}
public PageEntity.EnterpriseInfo getEnterprise(string name)
{
SqlParameter parm = new SqlParameter(uN, SqlDbType.VarChar);
parm.Value = name;
EnterpriseInfo enterprise = new EnterpriseInfo();
using (SqlDataReader rdr = SqlServerHelper.ExecuteReader(SqlServerHelper.ConnectionString, CommandType.Text, SQL_SELECT_ENTER_STATE, parm))
{
if (rdr.Read())
{
enterprise.enterpriseID = (int)rdr[0];
enterprise.enterpriseName = (string)rdr[1];
enterprise.enterpriseEmail = (string)rdr[3];
}
}
return(enterprise);
}
/// <summary>
/// 微信推广注册
/// </summary>
/// <param name="Param"></param>
/// <returns></returns>
public object WeChatRegist(RequestEnterprise Param)
{
Param.InviteCode = Encoding.Default.GetString(Convert.FromBase64String(Param.InviteCode));
EnterpriseInviteCode InviteCode = Kily.Set <EnterpriseInviteCode>().Where(t => t.InviteCode.Equals(Param.InviteCode)).FirstOrDefault();
InviteCode.UseCompany = Param.CompanyName;
InviteCode.UseCompanyType = Param.CompanyType;
InviteCode.UsePhone = Param.CompanyPhone;
InviteCode.UseTime = DateTime.Now;
List <string> Fields = new List <string> {
"UseCompany", "UseCompanyType", "UsePhone", "UseTime"
};
UpdateField(InviteCode, null, Fields);
EnterpriseInfo Info = Param.MapToEntity <EnterpriseInfo>();
return(Insert(Info) ? ServiceMessage.INSERTSUCCESS : ServiceMessage.INSERTFAIL);
}
//逻辑恢复
private void RestoreBtn_Click(object sender, RoutedEventArgs e)
{
EnterpriseInfo[] enterinfo = new EnterpriseInfo[]
{
new EnterpriseInfo()
{
Id = Guid.Parse("E95CF06C-4B6D-E811-8696-002324E261D0"),
EnterpriseName = "oooo",
EnterpriseCode = "04",
EnterpriseAddress = "oooo",
EnterprisePhone = "4",
Description = "oooo",
Remark = "oooo",
//IsLocked = false,
CreatedTime = DateTime.Now,
CreatorUserId = "1",
LastUpdatedTime = DateTime.Now,
LastUpdatorUserId = "1",
//IsDeleted = false
},
new EnterpriseInfo()
{
Id = Guid.Parse("EA5CF06C-4B6D-E811-8696-002324E261D0"),
EnterpriseName = "pppp",
EnterpriseCode = "05",
EnterpriseAddress = "pppp",
EnterprisePhone = "5",
Description = "pppp",
Remark = "pppp",
CreatedTime = DateTime.Now,
//IsLocked = false,
CreatorUserId = "1",
LastUpdatedTime = DateTime.Now,
LastUpdatorUserId = "1",
//IsDeleted = false
}
};
var result = HttpClientHelper.PostResponse <OperationResult>(@"http://localhost:13800/api/service/" + "EnterpriseInfo/Restore", Utility.JsonHelper.ToJson(enterinfo));
OperationResultType type = result.ResultType;
string data = Convert.ToString(result.Data);
}
/// <summary>
/// 异步上传数据。
/// </summary>
/// <param name="info"></param>
private string UploadAsync(EnterpriseInfo info)
{
string requestSerialCode = null;
try
{
HjApi api = new HjApi()
{
Endpoint = "open/api/get", Method = "Corp.Upload", Version = "2.1"
};
var result = HjApiCaller.CallOpenApi(api, info);
requestSerialCode = result["data"]["requestSerialCode"]?.ToString();
}
catch (Exception e)
{
throw;
}
return(requestSerialCode);
}
/// <summary>
/// 一一匹配修改项
/// </summary>
/// <param name="enterprise"></param>
/// <param name="enterpriseInfo"></param>
private static void Modity(EnterpriseInfoRequest enterprise, EnterpriseInfo enterpriseInfo)
{
enterpriseInfo.State = enterprise.State;
enterpriseInfo.Name = enterprise.Name;
enterpriseInfo.LocationProvinceCode = enterprise.LocationProvinceCode;
enterpriseInfo.LocationCityCode = enterprise.LocationCityCode;
enterpriseInfo.LocationDistrictCode = enterprise.LocationDistrictCode;
enterpriseInfo.Address = enterprise.Address;
enterpriseInfo.Tel = enterprise.Tel;
enterpriseInfo.TypeName = enterprise.TypeName;
enterpriseInfo.RepresentativePerson = enterprise.RepresentativePerson;
enterpriseInfo.RepresentativeTel = enterprise.RepresentativeTel;
enterpriseInfo.Email = enterprise.Email;
enterpriseInfo.OpenAnAccount = enterprise.OpenAnAccount;
enterpriseInfo.BankAccount = enterprise.BankAccount;
enterpriseInfo.Nature = enterprise.Nature;
enterpriseInfo.RegisterUserID = enterprise.RegisterUserID;
enterpriseInfo.Remark = enterprise.Remark;
enterpriseInfo.Safety = enterprise.Safety;
enterpriseInfo.CreditCode = enterprise.CreditCode;
enterpriseInfo.AptitudeCertificate = enterprise.AptitudeCertificate;
enterpriseInfo.RegisteredCapital = enterprise.RegisteredCapital;
enterpriseInfo.BusinessLicenseNum = enterprise.BusinessLicenseNum;
}
protected void btnLogin_Click(object sender, EventArgs e)
{
if (IsValid)
{
// Validate the user password
var manager = Context.GetOwinContext().GetUserManager <ApplicationUserManager>();
var signinManager = Context.GetOwinContext().GetUserManager <ApplicationSignInManager>();
var user = manager.FindByName(tbUserName.Text);
if (user != null)
{
if (!user.EmailConfirmed)
{
tbUserName.ErrorText = "Invalid login attempt. You must have a confirmed email address. Enter your email and password, then press 'Resend Confirmation'.";
ResendConfirm.Visible = true;
}
else
{
// This doen't count login failures towards account lockout
// To enable password failures to trigger lockout, change to shouldLockout: true
var result = signinManager.PasswordSignIn(tbUserName.Text, tbPassword.Text, isPersistent: false, shouldLockout: false);
switch (result)
{
case SignInStatus.Success:
//Now that the user is authenticated, cast the user from ASP.NET Identity to retrieve his default landing project
var xmanager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(new ApplicationDbContext()));
//var currentUser = xmanager.FindById(User.Identity.GetUserId());
var currentUser = xmanager.FindByName(tbUserName.Text);
// Use the extended user property of 'project' which contains the GUID for the enterprise project and it to session so it can be used when querying data throughout the project
HttpContext.Current.Session.Add("enterpriseID", currentUser.enterprise);
HttpContext.Current.Session.Add("UserID", currentUser.Id);
HttpContext.Current.Session.Add("UserEmail", currentUser.Email);
//Mode for saying whether user is in Enterprise or Project Mode DEPRECATED
HttpContext.Current.Session.Add("Mode", "project");
//Now select query other information about the project and then add them to session variabes so they can be use. Session(projectID) will be used for querying
//and the other properties pro_name and pro_color will be used to customize the interface to show the use what project he is currently working on
//First, add the user's connection String to the sqldatasource - also save the connectionstring into session so that it can be declaratively used on SqlDataSources throughout the project
// Get Enteprise Name and COnnection String
EnterpriseInfo LoginEnterprise = common_services.GetEnterpriseInfo(currentUser.enterprise);
HttpContext.Current.Session.Add("userConnString", common_services.BuildConnString(LoginEnterprise.DBconnectionString));
HttpContext.Current.Session.Add("IdentityConnString", common_services.BuildConnString("rcxidentity", true));
//DEPRECATED BELOW - LoginEnterprise.DBConnectionString only pulls DB name now, which the function above makes into a connection string based on slot app settings
//HttpContext.Current.Session.Add("userConnString", LoginEnterprise.DBconnectionString);
HttpContext.Current.Session.Add("EnterpriseName", LoginEnterprise.EnterpriseName);
// Now get the project info from the enterprise database for this client (the client's enterprise DB has the information for each solution)
DropdownItem NewProject = new DropdownItem();
NewProject = common_services.GetProjectMilestone(currentUser.project);
HttpContext.Current.Session.Add("projectName", NewProject.Name);
HttpContext.Current.Session.Add("projectColor", NewProject.Color);
HttpContext.Current.Session.Add("projectID", NewProject.Id);
HttpContext.Current.Session.Add("MilestoneID", NewProject.MilestoneID);
HttpContext.Current.Session.Add("MilestoneName", NewProject.MilestoneName);
EventLogger.Log("Login");
//Use ASP.NET Identity method to return user to the correct page
IdentityHelper.RedirectToReturnUrl(Request.QueryString["ReturnUrl"], Response);
break;
case SignInStatus.LockedOut:
Response.Redirect("~/Account/Lockout.aspx");
break;
case SignInStatus.RequiresVerification:
Response.Redirect(String.Format("/Account/TwoFactorAuthenticationSignIn.aspx?ReturnUrl={0}&RememberMe={1}",
Request.QueryString["ReturnUrl"],
false),
true);
break;
case SignInStatus.Failure:
default:
tbUserName.ErrorText = "Invalid user";
tbUserName.IsValid = false;
break;
}
}
}
}
}
public JsonResponse AddEnterpriseInfo(EnterpriseInfoRequest enterprise)
{
try
{
if (string.IsNullOrEmpty(enterprise?.Name) || string.IsNullOrEmpty(enterprise.BusinessLicenseNum))
{
return(new JsonResponse(OperatingState.CheckDataFail, "未传入需要的条件"));
}
//根据企业名称、营业执照注册号 综合判断是否存在该项目资料
if (_enterpriseInfoRepository.Table.FirstOrDefault(s => s.Name == enterprise.Name) != null)
{
return(new JsonResponse(OperatingState.CheckDataFail, "已经存在该企业信息"));
}
////根据法定代表电话判断是否存在该用户
//if (_enterpriseUserInfo.Table.FirstOrDefault(s => s.Phone == enterprise.RepresentativeTel && s.DeletedState != (int)DeletedStates.Deleted) != null)
//{
// return new JsonResponse(OperatingState.CheckDataFail, "该法定代表电话已被注册");
//}
#region 新的EnterpriseInfo
var enterId = Guid.NewGuid();
var enterpriseInfo = new EnterpriseInfo()
{
Id = enterId,
DeletedState = null,
DeletedTime = null,
CreatedTime = DateTime.Now,
State = (int)EnterpriseState.New,
Name = enterprise.Name,
LocationProvinceCode = enterprise.LocationProvinceCode,
LocationCityCode = enterprise.LocationCityCode,
LocationDistrictCode = enterprise.LocationDistrictCode,
Address = enterprise.Address,
Tel = enterprise.Tel,
TypeName = enterprise.TypeName,
Safety = enterprise.Safety,
SafetyToAudit = null,
RepresentativePerson = enterprise.RepresentativePerson,
RepresentativeTel = enterprise.RepresentativeTel,
CreditCode = enterprise.CreditCode,
CreditCodeToAudit = null,
BusinessLicenseNum = enterprise.BusinessLicenseNum,
BusinessLicenseNumToAudit = null,
Email = enterprise.Email,
RegisteredCapital = enterprise.RegisteredCapital,
RegisteredCapitalToAudit = 0,
OpenAnAccount = enterprise.OpenAnAccount,
BankAccount = enterprise.BankAccount,
AptitudeCertificate = enterprise.AptitudeCertificate,
AptitudeCertificateToAudit = null,
Nature = enterprise.Nature,
RegisterUserID = enterprise.RegisterUserID,
Remark = enterprise.Remark,
RepresentativeIDCardType = enterprise.RepresentativeIDCardType == null?0: enterprise.RepresentativeIDCardType
};
#endregion
var relationship = _relationship.Table.FirstOrDefault(t => t.UserId == enterprise.RegisterUserID && t.EnterpriseID == enterId);
if (relationship != null)
{
relationship.Id = relationship.Id;
relationship.UserId = enterprise.RegisterUserID;
relationship.EnterpriseID = enterId;
relationship.RoleId = Guid.Empty;
relationship.State = 0;
relationship.IsEnterprise = true;
_relationship.Update(relationship);
}
else
{
relationship = new Relationship()
{
Id = Guid.NewGuid(),
UserId = enterprise.RegisterUserID,
DeptInfoId = Guid.Empty,
EnterpriseID = enterId,
RoleId = Guid.Empty,
State = 0,
IsEnterprise = true,
CreateTime = DateTime.Now
};
_relationship.PreInsert(relationship);
}
_enterpriseInfoRepository.PreInsert(enterpriseInfo);
_enterpriseInfoRepository.SaveChanges();
return(new JsonResponse(OperatingState.Success, "添加数据成功"));
}
catch (Exception e)
{
return(new JsonResponse(OperatingState.Failure, "添加数据失败", e.Message));
}
}
private static bool handleEnterpriseSignIn(Credentials credentials, SignInTicket ticket, ObjectStore os)
{
ticket.SetStatus(Resources.DownloadingConnectListEllipsis_Text);
EnterpriseInfo = new EnterpriseInfo(os, ticket.UserName);
if (!EnterpriseInfo.IsValid)
{
ticket.SetError(Credentials.FromResponse(AuthenticateResponse.ClientSideError, Resources.NoServersForUser_Text));
return false;
}
object value;
if (credentials.TryGetValue(Credentials.TimeOffsetId, typeof(TimeSpan), out value))
{
_enterpriseTimeOffset = (TimeSpan)value;
}
EnterpriseServer = ticket.Server;
EnterpriseObjectStore = os;
return true;
}
/// <summary>
/// 获取企业信息
/// </summary>
/// <param name="enterpriseID"></param>
/// <returns></returns>
public static Enterprise GetEnterprise(string enterpriseID)
{
EnterpriseInfo enterpriseInfo = new EnterpriseInfo();
return(enterpriseInfo.GetEnterpriseByCode(enterpriseID));
}
