/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Hownet.Model.MiniEmp model)
{
return(dal.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Hownet.Model.MiniEmp model)
{
dal.Update(model);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <Hownet.Model.MiniEmp> DataTableToList(DataTable dt)
{
List <Hownet.Model.MiniEmp> modelList = new List <Hownet.Model.MiniEmp>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Hownet.Model.MiniEmp model;
for (int n = 0; n < rowsCount; n++)
{
model = new Hownet.Model.MiniEmp();
if (dt.Rows[n]["ID"].ToString() != "")
{
model.ID = int.Parse(dt.Rows[n]["ID"].ToString());
}
else
{
model.ID = 0;
}
model.Name = dt.Rows[n]["Name"].ToString();
if (dt.Rows[n]["IntroducerID"].ToString() != "")
{
model.IntroducerID = int.Parse(dt.Rows[n]["IntroducerID"].ToString());
}
else
{
model.IntroducerID = 0;
}
model.IdentityCard = dt.Rows[n]["IdentityCard"].ToString();
if (dt.Rows[n]["Sex"].ToString() != "")
{
model.Sex = int.Parse(dt.Rows[n]["Sex"].ToString());
}
else
{
model.Sex = 0;
}
model.Sn = dt.Rows[n]["Sn"].ToString();
if (dt.Rows[n]["Province"].ToString() != "")
{
model.Province = int.Parse(dt.Rows[n]["Province"].ToString());
}
else
{
model.Province = 0;
}
model.Address = dt.Rows[n]["Address"].ToString();
model.Phone = dt.Rows[n]["Phone"].ToString();
if (dt.Rows[n]["AccDate"].ToString() != "")
{
model.AccDate = DateTime.Parse(dt.Rows[n]["AccDate"].ToString());
}
else
{
model.AccDate = DateTime.Parse("1900-1-1");
}
model.WorkTypeID = dt.Rows[n]["WorkTypeID"].ToString();
if (dt.Rows[n]["PayID"].ToString() != "")
{
model.PayID = int.Parse(dt.Rows[n]["PayID"].ToString());
}
else
{
model.PayID = 0;
}
if (dt.Rows[n]["DimDate"].ToString() != "")
{
model.DimDate = DateTime.Parse(dt.Rows[n]["DimDate"].ToString());
}
else
{
model.DimDate = DateTime.Parse("1900-1-1");
}
if (dt.Rows[n]["BedID"].ToString() != "")
{
model.BedID = int.Parse(dt.Rows[n]["BedID"].ToString());
}
else
{
model.BedID = 0;
}
if (dt.Rows[n]["TableID"].ToString() != "")
{
model.TableID = int.Parse(dt.Rows[n]["TableID"].ToString());
}
else
{
model.TableID = 0;
}
if (dt.Rows[n]["DepartmentID"].ToString() != "")
{
model.DepartmentID = int.Parse(dt.Rows[n]["DepartmentID"].ToString());
}
else
{
model.DepartmentID = 0;
}
if (dt.Rows[n]["DegreeID"].ToString() != "")
{
model.DegreeID = int.Parse(dt.Rows[n]["DegreeID"].ToString());
}
else
{
model.DegreeID = 0;
}
if (dt.Rows[n]["PolityID"].ToString() != "")
{
model.PolityID = int.Parse(dt.Rows[n]["PolityID"].ToString());
}
else
{
model.PolityID = 0;
}
model.SOSPhone = dt.Rows[n]["SOSPhone"].ToString();
model.SOSMan = dt.Rows[n]["SOSMan"].ToString();
model.NowAddress = dt.Rows[n]["NowAddress"].ToString();
if (dt.Rows[n]["FillDate"].ToString() != "")
{
model.FillDate = DateTime.Parse(dt.Rows[n]["FillDate"].ToString());
}
else
{
model.FillDate = DateTime.Parse("1900-1-1");
}
if (dt.Rows[n]["FillUser"].ToString() != "")
{
model.FillUser = int.Parse(dt.Rows[n]["FillUser"].ToString());
}
else
{
model.FillUser = 0;
}
if (dt.Rows[n]["LassMoney"].ToString() != "")
{
model.LassMoney = decimal.Parse(dt.Rows[n]["LassMoney"].ToString());
}
else
{
model.LassMoney = 0;
}
if (dt.Rows[n]["Royalty"].ToString() != "")
{
model.Royalty = decimal.Parse(dt.Rows[n]["Royalty"].ToString());
}
else
{
model.Royalty = 0;
}
model.Image = dt.Rows[n]["Image"].ToString();
if (dt.Rows[n]["IsUse"].ToString() != "")
{
if ((dt.Rows[n]["IsUse"].ToString() == "1") || (dt.Rows[n]["IsUse"].ToString().ToLower() == "true"))
{
model.IsUse = true;
}
else
{
model.IsUse = false;
}
}
if (dt.Rows[n]["City"].ToString() != "")
{
model.City = int.Parse(dt.Rows[n]["City"].ToString());
}
else
{
model.City = 0;
}
if (dt.Rows[n]["County"].ToString() != "")
{
model.County = int.Parse(dt.Rows[n]["County"].ToString());
}
else
{
model.County = 0;
}
model.Remark = dt.Rows[n]["Remark"].ToString();
if (dt.Rows[n]["IDCardID"].ToString() != "")
{
model.IDCardID = Int64.Parse(dt.Rows[n]["IDCardID"].ToString());
}
if (dt.Rows[n]["IsEnd"].ToString() != "")
{
model.IsEnd = int.Parse(dt.Rows[n]["IsEnd"].ToString());
}
else
{
model.IsEnd = 0;
}
if (dt.Rows[n]["Deposit"].ToString() != "")
{
model.Deposit = decimal.Parse(dt.Rows[n]["Deposit"].ToString());
}
else
{
model.Deposit = 0;
}
if (dt.Rows[n]["NeedDeposit"].ToString() != "")
{
model.NeedDeposit = decimal.Parse(dt.Rows[n]["NeedDeposit"].ToString());
}
else
{
model.NeedDeposit = 0;
}
model.DefaultWorkType = dt.Rows[n]["DefaultWorkType"].ToString();
if (dt.Rows[n]["BoardWages"] != null && dt.Rows[n]["BoardWages"].ToString() != "")
{
model.BoardWages = decimal.Parse(dt.Rows[n]["BoardWages"].ToString());
}
if (dt.Rows[n]["HeTongDate"] != null && dt.Rows[n]["HeTongDate"].ToString() != "")
{
model.HeTongDate = DateTime.Parse(dt.Rows[n]["HeTongDate"].ToString());
}
model.HeTongAmount = dt.Rows[n]["HeTongAmount"].ToString();
if (dt.Rows[n]["HeTongDQDate"] != null && dt.Rows[n]["HeTongDQDate"].ToString() != "")
{
model.HeTongDQDate = DateTime.Parse(dt.Rows[n]["HeTongDQDate"].ToString());
}
if (dt.Rows[n]["IsCaicTiCheng"] != null && dt.Rows[n]["IsCaicTiCheng"].ToString() != "")
{
if ((dt.Rows[n]["IsCaicTiCheng"].ToString() == "1") || (dt.Rows[n]["IsCaicTiCheng"].ToString().ToLower() == "true"))
{
model.IsCaicTiCheng = true;
}
else
{
model.IsCaicTiCheng = false;
}
}
if (dt.Rows[n]["MaxAmountDay"] != null && dt.Rows[n]["MaxAmountDay"].ToString() != "")
{
model.MaxAmountDay = int.Parse(dt.Rows[n]["MaxAmountDay"].ToString());
}
model.BankNO = dt.Rows[n]["BankNO"].ToString();
model.BankAccountName = dt.Rows[n]["BankAccountName"].ToString();
model.BankName = dt.Rows[n]["BankName"].ToString();
model.A = int.Parse(dt.Rows[n]["A"].ToString());
modelList.Add(model);
}
}
return(modelList);
}
