//========================================================================= // FunctionName : Query /// <summary> /// 检索方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public T_BM_GZXXApplicationData Query(T_BM_GZXXApplicationData appData) { T_BM_GZXXBusinessEntity instanceT_BM_GZXXBusinessEntity = (T_BM_GZXXBusinessEntity)CreateBusinessEntityInstance(typeof(T_BM_GZXXBusinessEntity)); instanceT_BM_GZXXBusinessEntity.AppData = appData; if (instanceT_BM_GZXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.PK) { instanceT_BM_GZXXBusinessEntity.SelectByKey(); instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceT_BM_GZXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ID) { instanceT_BM_GZXXBusinessEntity.SelectByObjectID(); instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceT_BM_GZXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ALL) { instanceT_BM_GZXXBusinessEntity.SelectByAnyCondition(); instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BM_GZXXBusinessEntity.SelectByAnyCondition(); instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } return(instanceT_BM_GZXXBusinessEntity.AppData); }
//========================================================================= // FunctionName : Count /// <summary> /// 统计记录数方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public T_BM_GZXXApplicationData Count(T_BM_GZXXApplicationData appData) { T_BM_GZXXBusinessEntity instanceT_BM_GZXXBusinessEntity = (T_BM_GZXXBusinessEntity)CreateBusinessEntityInstance(typeof(T_BM_GZXXBusinessEntity)); instanceT_BM_GZXXBusinessEntity.AppData = appData; instanceT_BM_GZXXBusinessEntity.CountByAnyCondition(); instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; return(instanceT_BM_GZXXBusinessEntity.AppData); }
//========================================================================= // FunctionName : Modify /// <summary> /// 更新方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public T_BM_GZXXApplicationData Modify(T_BM_GZXXApplicationData appData) { T_BM_GZXXBusinessEntity instanceT_BM_GZXXBusinessEntity = (T_BM_GZXXBusinessEntity)CreateBusinessEntityInstance(typeof(T_BM_GZXXBusinessEntity)); instanceT_BM_GZXXBusinessEntity.AppData = appData; if (instanceT_BM_GZXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.PK) { if (instanceT_BM_GZXXBusinessEntity.IsExistByKey() == true) { instanceT_BM_GZXXBusinessEntity.UpdateByKey(); instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } else if (instanceT_BM_GZXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ID) { if (instanceT_BM_GZXXBusinessEntity.IsExistByObjectID() == true) { instanceT_BM_GZXXBusinessEntity.UpdateByObjectID(); instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } else if (instanceT_BM_GZXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.BATCH) { instanceT_BM_GZXXBusinessEntity.UpdateByObjectIDBatch(); instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceT_BM_GZXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ALL) { instanceT_BM_GZXXBusinessEntity.UpdateByAnyCondition(); instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { if (instanceT_BM_GZXXBusinessEntity.IsExistByObjectID() == true) { instanceT_BM_GZXXBusinessEntity.UpdateByObjectID(); instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } return(instanceT_BM_GZXXBusinessEntity.AppData); }
public static IEnumerable <T_BM_GZXXApplicationData> GetCollectionFromImportDataTable(DataTable dt) { List <T_BM_GZXXApplicationData> collection = new List <T_BM_GZXXApplicationData>(); foreach (DataRow dr in dt.Rows) { T_BM_GZXXApplicationData applicationData = new T_BM_GZXXApplicationData() { ObjectID = (dr.ReadGuidNullable("ObjectID") == null ? null : dr.ReadGuidNullable("ObjectID").ToString()), XM = dr.ReadString("姓名"), XB = dr.ReadString("XB"), SFZH = dr.ReadString("身份证号码"), FFGZNY = dr.ReadString("FFGZNY"), JCGZ = dr.ReadDoubleNullable("JCGZ"), JSDJGZ = dr.ReadDoubleNullable("JSDJGZ"), ZWGZ = dr.ReadDoubleNullable("职务(岗位)工资"), JBGZ = dr.ReadDoubleNullable("级别(薪级、技术等级)工资"), JKDQJT = dr.ReadDoubleNullable("艰苦边远地区津贴"), JKTSGWJT = dr.ReadDoubleNullable("JKTSGWJT"), GLGZ = dr.ReadDoubleNullable("GLGZ"), XJGZ = dr.ReadDoubleNullable("XJGZ"), TGBF = dr.ReadDoubleNullable("警衔工资(教师护士10%)"), DHF = dr.ReadDoubleNullable("公务移动通讯费"), DSZNF = dr.ReadDoubleNullable("独生子女费"), FNWSHLF = dr.ReadDoubleNullable("妇女卫生费"), HLF = dr.ReadDoubleNullable("HLF"), JJ = dr.ReadDoubleNullable("职工住宅取暖补贴"), JTF = dr.ReadDoubleNullable("上下班交通补助"), JHLGZ = dr.ReadDoubleNullable("特殊岗位津贴(教护龄工资)"), JT = dr.ReadDoubleNullable("JT"), BF = dr.ReadDoubleNullable("补发"), QTBT = dr.ReadDoubleNullable("QTBT"), DFXJT = dr.ReadDoubleNullable("地方津贴补贴(基础绩效工资)"), YFX = dr.ReadDoubleNullable("应发工资"), QTKK = dr.ReadDoubleNullable("QTKK"), SYBX = dr.ReadDoubleNullable("SYBX"), SDNQF = dr.ReadDoubleNullable("SDNQF"), SDS = dr.ReadDoubleNullable("SDS"), YLBX = dr.ReadDoubleNullable("YLBX"), YLIBX = dr.ReadDoubleNullable("YLIBX"), YSSHF = dr.ReadDoubleNullable("YSSHF"), ZFGJJ = dr.ReadDoubleNullable("ZFGJJ"), KFX = dr.ReadDoubleNullable("扣发部分"), SFGZ = dr.ReadDoubleNullable("实发工资"), GZKKSM = dr.ReadString("GZKKSM"), TJSJ = dr.ReadDateTimeNullable("TJSJ"), }; collection.Add(applicationData); } return(collection); }
//========================================================================= // FunctionName : Add /// <summary> /// 添加方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public T_BM_GZXXApplicationData Add(T_BM_GZXXApplicationData appData) { T_BM_GZXXBusinessEntity instanceT_BM_GZXXBusinessEntity = (T_BM_GZXXBusinessEntity)CreateBusinessEntityInstance(typeof(T_BM_GZXXBusinessEntity)); instanceT_BM_GZXXBusinessEntity.AppData = appData; if (instanceT_BM_GZXXBusinessEntity.IsExistByKey() == false) { instanceT_BM_GZXXBusinessEntity.Insert(); instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BM_GZXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } return(instanceT_BM_GZXXBusinessEntity.AppData); }