private ZSZXFJModel Getmm(DataRow dr, DB_OPT dbo) { ZSZXFJModel model = new ZSZXFJModel { pk = dr["pk"].ToString(), Discription = dr["Discription"].ToString(), ExecuteValue1 = decimal.Parse(dr["ExecuteValue1"].ToString()), ExecuteValue2 = decimal.Parse(dr["ExecuteValue2"].ToString()), ExecuteValue3 = decimal.Parse(dr["ExecuteValue3"].ToString()), OperationPK = dr["OperationPK"].ToString() }; if (model.OperationPK.Trim() != "") { string strSql = "select Name FROM GOV_TC_DB_OPRATETACHE where PK='" + model.OperationPK.Trim() + "'"; model.OperationName = dbo.SelectString(strSql, null); } model.SFPK = dr["SFPK"].ToString(); SFTypeModel model2 = new SFTypeDal { PK = dr["SFPK"].ToString().Trim() }; model2 = model2.GetModel(dbo); model.Sfinfo = model2; model.ProjectType = dr["ProjectType"].ToString(); UsualBookTableModel model3 = new UsualBookTableDal { PK = dr["ProjectType"].ToString().Trim() }; model3 = model3.GetModel(false, dbo); model.ProjecttypeInfo = model3; model.TermName1 = dr["TermName1"].ToString(); model.TermName2 = dr["TermName2"].ToString(); model.flog = int.Parse(dr["flog"].ToString()); return model; }
public ServicesMessModel GetModel(DataRow dr, DB_OPT dbo) { ServicesMessModel model = new ServicesMessModel { PK = dr["PK"].ToString().Trim(), BH = dr["BH"].ToString().Trim(), ServiceTypePK = dr["ServiceTypePK"].ToString().Trim(), ServiceRegisterPK = dr["ServiceRegisterPK"].ToString().Trim() }; if (model.ServiceRegisterPK.Trim() != "") { model.ServiceRegisterInfo = new ServicesRegisterDal { PK = model.ServiceRegisterPK.Trim() }.GetModel(false, false, dbo); } model.OperationPK = dr["OperationPK"].ToString().Trim(); if (model.OperationPK.Trim() != "") { model.OperationInfo = new BusinessMessDal { PK = model.OperationPK.Trim() }.GetModel(dbo); } model.InPK = dr["InPK"].ToString().Trim(); model.InPKJZJZ = dr["InPKJZJZ"].ToString().Trim(); if (model.InPKJZJZ.Trim() != "") { model.InInfoJZJZ = new ServicesMessDal { PK = model.InPKJZJZ.Trim() }.GetModel(dbo); } model.CompanyPK = dr["CompanyPK"].ToString().Trim(); if (model.CompanyPK.Trim() != "") { model.CompanyInfo = new CompanyDal { pk_corp = model.CompanyPK.Trim() }.GetModel(false, false, false, dbo); } model.BranchPK = dr["BranchPK"].ToString().Trim(); if (model.BranchPK.Trim() != "") { model.BranchInfo = new BranchDal { BH = model.BranchPK.Trim() }.GetModel_BH(dbo); } model.TaxFeeCallectionPK = dr["TaxFeeCallectionPK"].ToString().Trim(); if (model.TaxFeeCallectionPK.Trim() != "") { string strSql = "select Name FROM GOV_TC_DB_SFProject where PK='" + model.TaxFeeCallectionPK.Trim() + "'"; model.TaxFeeCallectionName = dbo.SelectString(strSql, null); } model.PowerCode = dr["PowerCode"].ToString(); model.Name = dr["Name"].ToString(); model.Discription = dr["Discription"].ToString(); model.IsShow = dr["IsShow"].ToString(); model.IsBLService = dr["IsBLService"].ToString(); model.BLPKs = dr["BLPKs"].ToString(); model.BLPassType = dr["BLPassType"].ToString(); return model; }
public static string GetSqlPK(DB_OPT dbo) { string strSql = "select newid()"; return dbo.SelectString(strSql, null); }
public static string GetOraclePK(DB_OPT dbo) { string strSql = "select sys_guid() from dual"; return dbo.SelectString(strSql, null); }