/// <summary> /// 获得数据列表 /// </summary> public List <BWS.ERP.Model.hrCompanyMasterEntity> DataTableToList(DataTable dt) { List <BWS.ERP.Model.hrCompanyMasterEntity> modelList = new List <BWS.ERP.Model.hrCompanyMasterEntity>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { BWS.ERP.Model.hrCompanyMasterEntity model; for (int n = 0; n < rowsCount; n++) { model = new BWS.ERP.Model.hrCompanyMasterEntity(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } model.sCompanyID = dt.Rows[n]["sCompanyID"].ToString(); model.sCompanySName = dt.Rows[n]["sCompanySName"].ToString(); model.sCompanyCName = dt.Rows[n]["sCompanyCName"].ToString(); model.sCompanyEName = dt.Rows[n]["sCompanyEName"].ToString(); model.sCorporation = dt.Rows[n]["sCorporation"].ToString(); model.sTel = dt.Rows[n]["sTel"].ToString(); model.sFax = dt.Rows[n]["sFax"].ToString(); model.sEmail = dt.Rows[n]["sEmail"].ToString(); model.sHomepage = dt.Rows[n]["sHomepage"].ToString(); model.sChnAddr = dt.Rows[n]["sChnAddr"].ToString(); model.sEngAddr = dt.Rows[n]["sEngAddr"].ToString(); model.sPostCode = dt.Rows[n]["sPostCode"].ToString(); model.sTax = dt.Rows[n]["sTax"].ToString(); model.sChnTitle = dt.Rows[n]["sChnTitle"].ToString(); model.sEngTitle = dt.Rows[n]["sEngTitle"].ToString(); model.sChnTitle2 = dt.Rows[n]["sChnTitle2"].ToString(); model.sEngTitle2 = dt.Rows[n]["sEngTitle2"].ToString(); if (dt.Rows[n]["mlogo"].ToString() != "") { model.mlogo = (byte[])dt.Rows[n]["mlogo"]; } model.sRemark = dt.Rows[n]["sRemark"].ToString(); model.dBillDate = dt.Rows[n]["dBillDate"].ToString(); if (dt.Rows[n]["iFlag"].ToString() != "") { model.iFlag = int.Parse(dt.Rows[n]["iFlag"].ToString()); } model.sUserID = dt.Rows[n]["sUserID"].ToString(); modelList.Add(model); } } return(modelList); }
/// <summary> /// 获得数据列表 /// </summary> public List<BWS.ERP.Model.hrCompanyMasterEntity> DataTableToList(DataTable dt) { List<BWS.ERP.Model.hrCompanyMasterEntity> modelList = new List<BWS.ERP.Model.hrCompanyMasterEntity>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { BWS.ERP.Model.hrCompanyMasterEntity model; for (int n = 0; n < rowsCount; n++) { model = new BWS.ERP.Model.hrCompanyMasterEntity(); if (dt.Rows[n]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[n]["ID"].ToString()); } model.sCompanyID = dt.Rows[n]["sCompanyID"].ToString(); model.sCompanySName = dt.Rows[n]["sCompanySName"].ToString(); model.sCompanyCName = dt.Rows[n]["sCompanyCName"].ToString(); model.sCompanyEName = dt.Rows[n]["sCompanyEName"].ToString(); model.sCorporation = dt.Rows[n]["sCorporation"].ToString(); model.sTel = dt.Rows[n]["sTel"].ToString(); model.sFax = dt.Rows[n]["sFax"].ToString(); model.sEmail = dt.Rows[n]["sEmail"].ToString(); model.sHomepage = dt.Rows[n]["sHomepage"].ToString(); model.sChnAddr = dt.Rows[n]["sChnAddr"].ToString(); model.sEngAddr = dt.Rows[n]["sEngAddr"].ToString(); model.sPostCode = dt.Rows[n]["sPostCode"].ToString(); model.sTax = dt.Rows[n]["sTax"].ToString(); model.sChnTitle = dt.Rows[n]["sChnTitle"].ToString(); model.sEngTitle = dt.Rows[n]["sEngTitle"].ToString(); model.sChnTitle2 = dt.Rows[n]["sChnTitle2"].ToString(); model.sEngTitle2 = dt.Rows[n]["sEngTitle2"].ToString(); if (dt.Rows[n]["mlogo"].ToString() != "") { model.mlogo = (byte[])dt.Rows[n]["mlogo"]; } model.sRemark = dt.Rows[n]["sRemark"].ToString(); model.dBillDate = dt.Rows[n]["dBillDate"].ToString(); if (dt.Rows[n]["iFlag"].ToString() != "") { model.iFlag = int.Parse(dt.Rows[n]["iFlag"].ToString()); } model.sUserID = dt.Rows[n]["sUserID"].ToString(); modelList.Add(model); } } return modelList; }
/// <summary> /// 更新一条数据 /// </summary> public void Update(BWS.ERP.Model.hrCompanyMasterEntity model, SqlTransaction trans) { dal.Update(model, trans); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BWS.ERP.Model.hrCompanyMasterEntity model, SqlTransaction trans) { return(dal.Add(model, trans)); }