public static SysAreaMansion GetAreaMansion(string areaName, string mansionName)
{
var areaDict = AreaBLL.AreaNameMapping;
if (!areaDict.ContainsKey(areaName))
return null;
var area = areaDict[areaName];
var query = DB.Select( ).Top("1").From<SysAreaMansion>( )
.Where(SysAreaMansion.AreaIDColumn).IsEqualTo(area.Id)
.And(SysAreaMansion.NameColumn).IsEqualTo(mansionName);
SysAreaMansion mansion = null;
using (var dr = query.ExecuteReader( ))
{
if (dr.Read( ))
{
mansion = new SysAreaMansion( );
mansion.Load(dr);
}
}
if (mansion == null)
{
mansion = new SysAreaMansion
{
AreaID = area.Id,
Name = mansionName,
Address = null,
Code = null,
AreaDepth = area.Depth,
};
mansion.Save( );
}
return mansion;
}
public void Insert(int? AreaID,string Name,string AreaDepth,string Code,string Address)
{
SysAreaMansion item = new SysAreaMansion();
item.AreaID = AreaID;
item.Name = Name;
item.AreaDepth = AreaDepth;
item.Code = Code;
item.Address = Address;
item.Save(UserName);
}
public static bool ImportAreaMansion(DataTable dt, out string message)
{
bool result = false;
message = string.Empty;
var dcAreaName = (DataColumn)null;
var dcName = (DataColumn)null;
var dcAddr = (DataColumn)null;
if (dt.Columns.Contains("所属片区"))
dcAreaName = dt.Columns["所属片区"];
if (dt.Columns.Contains("派送范围"))
dcName = dt.Columns["派送范围"];
if (dt.Columns.Contains("大厦地址"))
dcAddr = dt.Columns["大厦地址"];
if (dcAreaName == null || dcName == null)
{
message = "上传的excel 文档必须包含有 所属片区 和 派送范围两列信息";
goto lbl_return;
}
var areaDict = AreaBLL.AreaNameMapping;
string areaName, mansionName;
SysArea area;
MansionAreaId mansionAreaId;
foreach (DataRow dr in dt.Rows)
{
if (string.IsNullOrEmpty(areaName = Convert.ToString(dr[dcAreaName]).Trim( )))
continue;
if (string.IsNullOrEmpty(mansionName = Convert.ToString(dr[dcName]).Trim( )))
continue;
if (!areaDict.ContainsKey(areaName))
continue;
area = areaDict[areaName];
mansionAreaId = MansionAreaId.GetMansionAreaId(area.Id, mansionName);
if (AreaMansionMapping.ContainsKey(mansionAreaId))
continue;
SysAreaMansion mansion = new SysAreaMansion
{
AreaID = area.Id,
Name = mansionName,
Address = dcAddr != null ? Convert.ToString(dr[dcAddr]).Trim( ) : null,
Code = null,
AreaDepth = area.Depth,
};
mansion.Save( );
AreaMansionMapping.Add(mansionAreaId, mansion);
}
result = true;
lbl_return:
return result;
}
public void Update(int Id,int? AreaID,string Name,string AreaDepth,string Code,string Address)
{
SysAreaMansion item = new SysAreaMansion();
item.MarkOld();
item.IsLoaded = true;
item.Id = Id;
item.AreaID = AreaID;
item.Name = Name;
item.AreaDepth = AreaDepth;
item.Code = Code;
item.Address = Address;
item.Save(UserName);
}
