public bool Save(string name, string phone, string idcardno,
string specialidcard, string belong,
DJ_GroupWorkerType workertype,DJ_DijiesheInfo currentDjs, out string errMsg)
{
DJ_Workers worker = new DJ_Workers();
return Save(name, phone, idcardno, specialidcard, belong, workertype, currentDjs, out worker, out errMsg);
}
public bool Save(string name, string phone, string idcardno,
string specialidcard, string belong,
DJ_GroupWorkerType workertype, DJ_DijiesheInfo currentDjs,out DJ_Workers worker, out string errMsg)
{
worker = new DJ_Workers();
bool result = true;
errMsg = string.Empty;
var workers = GetWorkers8Multi(string.Empty, name, phone, idcardno, string.Empty, workertype, currentDjs.Id.ToString());
if (workers.Count > 0)
{
result = false;
worker = workers[0];
errMsg = "此工作人员已录入，不能重复添加";
}
else
{
worker.CompanyBelong = belong;
worker.DJ_Dijiesheinfo = currentDjs;
worker.IDCard = idcardno;
worker.Name = name;
worker.Phone = phone;
worker.SpecificIdCard = specialidcard;
worker.WorkerType = workertype;
Save(worker);
}
return result;
}
protected void btnUpload_Click(object sender, EventArgs e)
{
string fullname = FileUpload1.FileName.ToString();//直接取得文件名
string url = FileUpload1.PostedFile.FileName.ToString();//取得上传文件路径
string typ = FileUpload1.PostedFile.ContentType.ToString();//获取文件MIME内容类型
string typ2 = fullname.Substring(fullname.LastIndexOf(".") + 1);//后缀名, 不带".".
int size = FileUpload1.PostedFile.ContentLength;
string message = string.Empty;
#region 保存
if (typ2 == "xlsx" || typ2 == "xls" || typ2 == "xlsm")
{
if (size <= 4134904)
{
FileUpload1.SaveAs(excelPath + "temp-"+CurrentDJS.SeoName+"." + typ2);
ExcelOplib.Entity.GroupAll group_excel = excel.getGroup(excelPath + "temp-" + CurrentDJS.SeoName + "." + typ2, out message);
group_excel.GroupMemberList = group_excel.GroupMemberList.Where(x => !string.IsNullOrEmpty(x.Memtype)).ToList();
#region group modify
//group修改
if (!string.IsNullOrEmpty(Request.QueryString["groupid"]))
{
lblTitle.Text = "从excel文件更新团队";
var group_db = bllgroup.GetOne(new Guid(Request.QueryString[0]));
/*
todo 显示要更新的团队信息
*/
group_db.Name = group_excel.GroupBasic.Name;
group_db.BeginDate = DateTime.Parse(group_excel.GroupBasic.Begindate);
group_db.DaysAmount = int.Parse(group_excel.GroupBasic.Days);
group_db.EndDate = DateTime.Parse(group_excel.GroupBasic.Begindate).AddDays(int.Parse(group_excel.GroupBasic.Days));
//group_db.Workers.Clear();
group_db.Members.Clear();
group_db.Routes.Clear();
group_model.DijiesheEditor = (Model.DJ_User_TourEnterprise)CurrentMember;
foreach (var item in group_excel.GroupMemberList.Where(x => x.Memtype == "导游" || x.Memtype == "司机"))
{
group_db.Workers.Add(new Model.DJ_Group_Worker()
{
DJ_TourGroup = group_db,
DJ_Workers = new Model.DJ_Workers()
{
IDCard = item.Memid,
SpecificIdCard = item.Cardno,
WorkerType = (Model.DJ_GroupWorkerType)Enum.Parse(typeof(Model.DJ_GroupWorkerType), item.Memtype),
Phone = item.Memphone,
Name = item.Memname
}
});
}
foreach (var item in group_excel.GroupMemberList.Where(x => x.Memtype != "导游" && x.Memtype != "司机"))
{
group_db.Members.Add(new Model.DJ_TourGroupMember()
{
DJ_TourGroup = group_db,
IdCardNo = item.Memid,
SpecialCardNo = item.Cardno,
MemberType = (Model.MemberType)Enum.Parse(typeof(Model.MemberType), item.Memtype),
PhoneNum = item.Memphone,
RealName = item.Memname
});
}
foreach (var item in group_excel.GroupRouteList)
{
var temp_scenic = item.Scenic.Split(new char[] { ',', '-' }, StringSplitOptions.RemoveEmptyEntries);
var temp_hotel = item.Hotel.Split(new char[] { ',', '-' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var item2 in temp_scenic)
{
var sceniclist = bllenterp.GetDJS8name(item2);
if (sceniclist.Count == 0)
{
bllenterp.Save(new Model.DJ_TourEnterprise()
{
Name = item2,
Type = Model.EnterpriseType.景点
});
}
group_model.Routes.Add(new Model.DJ_Route()
{
DJ_TourGroup = group_model,
DayNo = int.Parse(item.RouteDate),
Enterprise = sceniclist.Count == 0 ? bllenterp.GetDJS8name(item2).First() : sceniclist[0]
});
}
foreach (var item2 in temp_hotel)
{
var hotellist = bllenterp.GetDJS8name(item2);
if (hotellist.Count == 0)
{
bllenterp.Save(new Model.DJ_TourEnterprise()
{
Name = item2,
Type = Model.EnterpriseType.宾馆
});
}
group_model.Routes.Add(new Model.DJ_Route()
{
DJ_TourGroup = group_model,
DayNo = int.Parse(item.RouteDate),
Enterprise = hotellist.Count == 0 ? bllenterp.GetDJS8name(item2).First() : hotellist[0]
});
}
}
group_model = group_db;
bllgroup.Save(group_db);
}
#endregion
#region group new
else
{
lblTitle.Text = "从excel文件新建团队";
group_model.Name = group_excel.GroupBasic.Name;
group_model.BeginDate = DateTime.Parse(group_excel.GroupBasic.Begindate);
group_model.DaysAmount = int.Parse(group_excel.GroupBasic.Days);
group_model.EndDate = DateTime.Parse(group_excel.GroupBasic.Begindate).AddDays(int.Parse(group_excel.GroupBasic.Days));
group_model.Workers = new List<Model.DJ_Group_Worker>();
group_model.Members = new List<Model.DJ_TourGroupMember>();
group_model.Routes = new List<Model.DJ_Route>();
group_model.DJ_DijiesheInfo = CurrentDJS;
group_model.DijiesheEditor = (Model.DJ_User_TourEnterprise)CurrentMember;
foreach (var item in group_excel.GroupMemberList.Where(x => x.Memtype == "导游" || x.Memtype == "司机"))
{
//是否已经存在该worker
var worker = bllworker.GetWorkers8Multi(null, item.Memname, null, null, null,
Enum.Parse(typeof(Model.DJ_GroupWorkerType), item.Memtype), CurrentDJS.Id.ToString());
//不存在，添加
if (worker.Count == 0)
{
var new_worker = new Model.DJ_Workers()
{
IDCard = item.Memid,
SpecificIdCard = item.Cardno,
WorkerType = (Model.DJ_GroupWorkerType)Enum.Parse(typeof(Model.DJ_GroupWorkerType), item.Memtype),
Phone = item.Memphone,
Name = item.Memname,
DJ_Dijiesheinfo=CurrentDJS
};
bllworker.Save(new_worker);
group_model.Workers.Add(new Model.DJ_Group_Worker()
{
DJ_TourGroup = group_model,
DJ_Workers = new_worker
});
}
//存在
else
{
group_model.Workers.Add(new Model.DJ_Group_Worker()
{
DJ_TourGroup = group_model,
DJ_Workers = worker.First()
});
}
}
foreach (var item in group_excel.GroupMemberList.Where(x => x.Memtype != "导游" && x.Memtype != "司机"))
{
group_model.Members.Add(new Model.DJ_TourGroupMember()
{
DJ_TourGroup = group_model,
IdCardNo = item.Memid,
SpecialCardNo = item.Cardno,
MemberType = (Model.MemberType)Enum.Parse(typeof(Model.MemberType), item.Memtype),
PhoneNum = item.Memphone,
RealName = item.Memname
});
}
foreach (var item in group_excel.GroupRouteList)
{
var temp_scenic = item.Scenic.Split(new char[] { ',', '-' }, StringSplitOptions.RemoveEmptyEntries);
var temp_hotel = item.Hotel.Split(new char[] { ',', '-' }, StringSplitOptions.RemoveEmptyEntries);
foreach (var item2 in temp_scenic)
{
var sceniclist=bllenterp.GetDJS8name(item2);
if(sceniclist.Count==0)
{
bllenterp.Save(new Model.DJ_TourEnterprise(){
Name=item2,
Type=Model.EnterpriseType.景点
});
}
group_model.Routes.Add(new Model.DJ_Route()
{
DJ_TourGroup = group_model,
DayNo = int.Parse(item.RouteDate),
Enterprise = sceniclist.Count == 0 ? bllenterp.GetDJS8name(item2).First() : sceniclist[0]
});
}
foreach (var item2 in temp_hotel)
{
var hotellist = bllenterp.GetDJS8name(item2);
if (hotellist.Count == 0)
{
bllenterp.Save(new Model.DJ_TourEnterprise()
{
Name = item2,
Type = Model.EnterpriseType.宾馆
});
}
group_model.Routes.Add(new Model.DJ_Route()
{
DJ_TourGroup = group_model,
DayNo = int.Parse(item.RouteDate),
Enterprise = hotellist.Count == 0 ? bllenterp.GetDJS8name(item2).First() : hotellist[0]
});
}
}
bllgroup.Save(group_model);
}
#endregion
Response.Redirect("/LocalTravelAgent/Groups/GroupDetail.aspx?guid=" + group_model.Id);
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('你的文件超过限制大小!')", true);
return;
}
}
else
{
//Label1.Text = "上传文件格式不正确.";
return;
}
#endregion
}