public async Task <ActionResult> Edit([Bind(Include = "Id,OuterKeyId,MediaFor,MediaName,MediaUrl")] CompanyMedia companyMedia)
{
if (ModelState.IsValid)
{
db.Entry(companyMedia).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(companyMedia));
}
public async Task <ActionResult> Edit(OtaSalesReport otaSalesReport)
{
if (ModelState.IsValid)
{
db.Entry(otaSalesReport).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(otaSalesReport));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,CompanyId,CertificateName,CompanyName,PictureUrl,CreateTime,CreateUserName")] CompanyCertificate companyCertificate)
{
if (ModelState.IsValid)
{
db.Entry(companyCertificate).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(companyCertificate));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,CompanyBusinessDailyId,PhotoUrl,PhotoName")] CompanyBusinessDailyPhoto companyBusinessDailyPhoto)
{
if (ModelState.IsValid)
{
db.Entry(companyBusinessDailyPhoto).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(companyBusinessDailyPhoto));
}
public async Task <ActionResult> Create([Bind(Include = "Id,ParamName,SubItemName")] ParamDict paramDict)
{
if (ModelState.IsValid)
{
db.ParamDict.Add(paramDict);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(paramDict));
}
public async Task <ActionResult> Create([Bind(Include = "ID,UserName,ServeAreaName")] ServeArea serveArea)
{
if (ModelState.IsValid)
{
db.ServeArea.Add(serveArea);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(serveArea));
}
public async Task <ActionResult> Create([Bind(Include = "Id,CompanyMeetingId,Subject,Problem,Resolve,CreateTime,ResolveTime")] CompanyMeetingSubject companyMeetingSubject)
{
if (ModelState.IsValid)
{
db.CompanyMeetingSubject.Add(companyMeetingSubject);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(companyMeetingSubject));
}
public async Task <ActionResult> Create([Bind(Include = "Id,CompanySalesDailyId,SaleSource,EmployeeCount,TicketCount,EmployeePayment")] CompanySalesDailySalesSource companySalesDailySalesSource)
{
if (ModelState.IsValid)
{
db.CompanySalesDailySalesSource.Add(companySalesDailySalesSource);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(companySalesDailySalesSource));
}
public async Task <ActionResult> Create([Bind(Include = "Id,CompanySalesDailyId,SalesSource,FreezeFund,WorkingFund,NeededFund")] CompanySalesDailyFund companySalesDailyFund)
{
if (ModelState.IsValid)
{
db.CompanySalesDailyFund.Add(companySalesDailyFund);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(companySalesDailyFund));
}
public async Task <ActionResult> Create([Bind(Include = "Id,CompanyId,CompanyName,ManagerName,ManagerPhone,SalesType,CreateUserName,CreateTime,SalesLogDate")] CompanySalesDaily companySalesDaily)
{
if (ModelState.IsValid)
{
db.CompanySalesDaily.Add(companySalesDaily);
await db.SaveChangesAsync();
return(RedirectToAction("Edit", new { id = companySalesDaily.Id }));
}
return(View(companySalesDaily));
}
public async Task <ActionResult> Create([Bind(Include = "ID,ProvinceName,CityName")] ChinaCity chinaCity)
{
if (ModelState.IsValid)
{
db.ChinaCity.Add(chinaCity);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(chinaCity));
}
public async Task <ActionResult> Create([Bind(Include = "Id,CompanySalesDailyId,SalesSource,SalesProduct,SalesCount")] CompanySalesDailyProductDesp companySalesDailyProductDesp)
{
if (ModelState.IsValid)
{
db.CompanySalesDailyProductDesp.Add(companySalesDailyProductDesp);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(companySalesDailyProductDesp));
}
public async Task <ActionResult> Create([Bind(Include = "id,agentDomain,agentName,promotion,agentManager,totalTicketNum,totalTicket,passRate,less60minRate,orderAlterRate,voluntaryRate,involuntaryRate,complainRate,qapassRate,phoneAnswerRate,messageTimeoutRate,qualification,whiteList,totalScore,status,statDate,statMonth,grade,CurDateTicketCount,CreateTime")] AgentGradeOperation agentGradeOperation)
{
if (ModelState.IsValid)
{
db.AgentGradeOperation.Add(agentGradeOperation);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(agentGradeOperation));
}
public async Task <ActionResult> Create([Bind(Include = "Id,CompanySalesDailyId,ParamName,SubParamItem,ItemAmount")] CompanySalesDailyParam companySalesDailyParam)
{
if (ModelState.IsValid)
{
db.CompanySalesDailyParam.Add(companySalesDailyParam);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(companySalesDailyParam));
}
public async Task <ActionResult> Create(OtaCompany otaCompany)
{
if (ModelState.IsValid)
{
db.OtaCompany.Add(otaCompany);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(otaCompany));
}
public ActionResult UpdateSalesName(string paramdata)
{
string[] lines = paramdata.Split(new char[] { '\r', '\n' }, StringSplitOptions.RemoveEmptyEntries);
Dictionary <string, string> companyDict = new Dictionary <string, string>();
foreach (string line in lines)
{
string[] fields = line.Split(new char[] { '\t' });
string companyName = fields[0].Trim();
string salesName = fields[1].Trim();
if (!companyDict.ContainsKey(companyName))
{
companyDict.Add(companyName, salesName);
}
}
OtaCrmModel db = new OtaCrmModel();
var q = from p in db.OtaCompany
select p;
List <OtaCompany> cList = q.ToList();
foreach (OtaCompany item in cList)
{
if (companyDict.ContainsKey(item.CompanyName))
{
item.SalesUserName = companyDict[item.CompanyName];
}
}
db.SaveChangesAsync();
return(Content("完成"));
}
public async Task <ActionResult> Create(CompanyMeeting companyMeeting)
{
ViewData["MeetingTypeList"] = GetMeetingTypeList("上门拜访");
if (ModelState.IsValid)
{
//更新公司的lastupdatedate
var company = db.OtaCompany.FirstOrDefault(p => p.Id == companyMeeting.CompanyId);
company.LastMeetingDate = DateTime.Now;
db.SaveChanges();
db.CompanyMeeting.Add(companyMeeting);
await db.SaveChangesAsync();
return(RedirectToAction("Edit", new { Id = companyMeeting.Id }));
}
return(View(companyMeeting));
}
public void InsertCompanyCms(List <CompanyCmsData> itemList, string md5Key)
{
if (md5Key == GetMd5Str(DateTime.Now.ToString("yyyyMMddHHmm00") + md5hashstr))
{
OtaCrmModel db = new OtaCrmModel();
db.CompanyCmsData.AddRange(itemList);
db.SaveChangesAsync();
}
}
public void InsertAgentGradeOprations(List <AgentGradeOperation> itemList, string md5Key)
{
if (md5Key == GetMd5Str(DateTime.Now.ToString("yyyyMMddHHmm00") + md5hashstr))
{
//计算每一条具体的当天票量，用当前的减去比它日期早一天的票量
OtaCrmModel db = new OtaCrmModel();
db.AgentGradeOperation.AddRange(itemList);
db.SaveChangesAsync();
}
}
public ActionResult UpdateCompanyStatus()
{
OtaCrmModel db = new OtaCrmModel();
var q = from p in db.OtaCompany
select p;
foreach (OtaCompany item in q)
{
if (string.IsNullOrEmpty(item.LegalPerson) || item.LegalPerson == "未知")
{
item.LegalPerson = "空";
}
}
db.SaveChangesAsync();
return(Content("更新完成."));
}
public ActionResult Update(string paramdata)
{
string[] fields = paramdata.Split(new char[] { '-' });
string OrgName = fields[0];
string curName = fields[1];
//
OtaCrmModel db = new OtaCrmModel();
var q = from p in db.OtaCompany
where p.SalesUserName == OrgName
select p;
foreach (OtaCompany item in q)
{
item.SalesUserName = curName;
}
db.SaveChangesAsync();
return(Content("完成"));
}
public ActionResult UpdateLegal()
{
OtaCrmModel db = new OtaCrmModel();
var companycmss = from p in db.CompanyCmsData
select p;
Dictionary <string, string> cmsDict = new Dictionary <string, string>();
foreach (CompanyCmsData cmsItem in companycmss)
{
if (!cmsDict.ContainsKey(cmsItem.CompanyName))
{
cmsDict.Add(cmsItem.CompanyName, cmsItem.LegalPerson);
}
}
db = new OtaCrmModel();
var q = from o in db.OtaCompany
select o;
List <OtaCompany> otacompanys = q.ToList();
foreach (OtaCompany cItem in otacompanys)
{
if (string.IsNullOrEmpty(cItem.LegalPerson) || cItem.LegalPerson == "未知")
{
if (cmsDict.ContainsKey(cItem.CompanyName))
{
cItem.LegalPerson = cmsDict[cItem.CompanyName];
}
}
if (string.IsNullOrEmpty(cItem.LegalPerson) || cItem.LegalPerson == "ww")
{
cItem.LegalPerson = "未知";
}
}
db.SaveChangesAsync();
return(Content("完成"));
}
public ActionResult UpdateOtaCompany()
{
OtaCrmModel db = new OtaCrmModel();
var companycmss = from p in db.CompanyCmsData
select p;
Dictionary <string, CompanyCmsData> cmsDict = new Dictionary <string, CompanyCmsData>();
foreach (CompanyCmsData cmsItem in companycmss)
{
if (!cmsDict.ContainsKey(cmsItem.CompanyName))
{
cmsDict.Add(cmsItem.CompanyName, cmsItem);
}
}
var q = from o in db.OtaCompany
select o;
List <OtaCompany> otacompanys = q.ToList();
int updateCount = 0;
bool isUpdate = false;
foreach (OtaCompany cItem in otacompanys)
{
if (cmsDict.ContainsKey(cItem.CompanyName))
{
CompanyCmsData cmsItem = cmsDict[cItem.CompanyName];
//需要修改得地方是这些
if (!string.IsNullOrEmpty(cmsItem.SalesName))
{
cItem.SalesUserName = cmsItem.SalesName;
}
if (string.IsNullOrEmpty(cItem.RegisterAddress) && !string.IsNullOrEmpty(cmsItem.RegisterAddress))
{
isUpdate = true;
cItem.RegisterAddress = cmsItem.RegisterAddress;
}
if (string.IsNullOrEmpty(cItem.RealAddress) && !string.IsNullOrEmpty(cmsItem.RealAddress))
{
isUpdate = true;
cItem.RealAddress = cmsItem.RealAddress;
}
if (string.IsNullOrEmpty(cItem.BossBackground) && !string.IsNullOrEmpty(cmsItem.BossBackground))
{
isUpdate = true;
cItem.BossBackground = cmsItem.BossBackground;
}
if (string.IsNullOrEmpty(cItem.BossName) && !string.IsNullOrEmpty(cmsItem.ContactPerson))
{
isUpdate = true;
cItem.BossName = cmsItem.ContactPerson;
}
if (string.IsNullOrEmpty(cItem.BusinessStatus) && !string.IsNullOrEmpty(cmsItem.TTSStatusDesp))
{
isUpdate = true;
cItem.BusinessStatus = cmsItem.TTSStatusDesp;
}
if (string.IsNullOrEmpty(cItem.LegalPerson) && !string.IsNullOrEmpty(cmsItem.LegalPerson))
{
isUpdate = true;
cItem.LegalPerson = cmsItem.LegalPerson;
}
if (string.IsNullOrEmpty(cItem.LegalPersonPhone) && !string.IsNullOrEmpty(cmsItem.ContactPhone))
{
isUpdate = true;
cItem.LegalPersonPhone = cmsItem.ContactPhone;
}
if (isUpdate)
{
updateCount++;
}
}
isUpdate = false;
}
db.SaveChangesAsync();
string result = "成功更新:" + updateCount.ToString();
return(Content(result));
}