private PBESTEntity GetPBESTFromIDataReader(DbDataReader dr) { PBESTEntity dt = new PBESTEntity(); if (dr.FieldCount > 0) { dt.PBESTTC = dr["PBESTTC"].ToString(); dt.PBESTTN = dr["PBESTTN"].ToString(); dt.PBESTTEN = dr["PBESTTEN"].ToString(); dt.PBESTTTWN = dr["PBESTTTWN"].ToString(); dt.PBESTUS = dr["PBESTUS"].ToString(); if (dr["PBESTOI"].ToString() != "" || dr["PBESTOI"] != null) dt.PBESTOI = Int32.Parse(dr["PBESTOI"].ToString()); dr.Close(); return dt; } dr.Close(); return null; }
/// <summary> /// 新增员工状态信息 /// </summary> /// <param name="_PBESTEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string AddPBEST(PBESTEntity _PBESTEntity) { //判断该记录是否已经存在 DbParameter[] prams = { MakeInParam("@PBESTTN",(DbType)SqlDbType.VarChar,50,_PBESTEntity.PBESTTN), }; string sql = "select * from PBEST where PBESTTN=@PBESTTN "; if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0) { return "-1";//该记录已经存在 } else { _PBESTEntity.PBESTTC = px_Sequence("PBESTCODE", "1"); DbParameter[] pramsInsert = { MakeInParam("@PBESTTC",(DbType)SqlDbType.VarChar,50,_PBESTEntity.PBESTTC ), MakeInParam("@PBESTTN",(DbType)SqlDbType.VarChar,50,_PBESTEntity.PBESTTN ), MakeInParam("@PBESTTEN",(DbType)SqlDbType.VarChar,50,_PBESTEntity.PBESTTEN ), MakeInParam("@PBESTTTWN",(DbType)SqlDbType.VarChar,50,_PBESTEntity.PBESTTTWN ), MakeInParam("@PBESTUS",(DbType)SqlDbType.Char,1,_PBESTEntity.PBESTUS ), MakeInParam("@PBESTOI",(DbType)SqlDbType.Int,4,_PBESTEntity.PBESTOI ), }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[PBEST]"); sb.Append("("); sb.Append("[PBESTTC]"); sb.Append(",[PBESTTN]"); sb.Append(",[PBESTTEN]"); sb.Append(",[PBESTTTWN]"); sb.Append(",[PBESTUS]"); sb.Append(",[PBESTOI]"); sb.Append(") "); sb.Append(" VALUES ("); sb.Append("@PBESTTC,"); sb.Append("@PBESTTN,"); sb.Append("@PBESTTEN,"); sb.Append("@PBESTTTWN,"); sb.Append("@PBESTUS,"); sb.Append("@PBESTOI)"); sb.Append(" select @@identity;"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); } }
/// <summary> /// 修改信息 /// </summary> /// <param name="_PBESTEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string UpDatePBEST(PBESTEntity _PBESTEntity) { //判断是否存在该工种名称 DbParameter[] prams = { MakeInParam("@PBESTTN",(DbType)SqlDbType.VarChar,50,_PBESTEntity.PBESTTN), MakeInParam("@PBESTTC",(DbType)SqlDbType.VarChar,50,_PBESTEntity.PBESTTC ) }; string sql = "select * from [PBEST] where PBESTTN = @PBESTTN and PBESTTC<>@PBESTTC"; if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0) { return "-1";//该名称已经存在 } else { DbParameter[] pramsUpDate = { MakeInParam("@PBESTTC",(DbType)SqlDbType.VarChar,50,_PBESTEntity.PBESTTC ), MakeInParam("@PBESTTN",(DbType)SqlDbType.VarChar,50,_PBESTEntity.PBESTTN ), MakeInParam("@PBESTTEN",(DbType)SqlDbType.VarChar,50,_PBESTEntity.PBESTTEN ), MakeInParam("@PBESTTTWN",(DbType)SqlDbType.VarChar,50,_PBESTEntity.PBESTTTWN ), MakeInParam("@PBESTUS",(DbType)SqlDbType.Char,1,_PBESTEntity.PBESTUS ), MakeInParam("@PBESTOI",(DbType)SqlDbType.Int,4,_PBESTEntity.PBESTOI ), }; StringBuilder sb = new StringBuilder(); sb.Append("UpDate [dbo].[PBEST]"); sb.Append(" set "); sb.Append(" [PBESTTN]=@PBESTTN,"); sb.Append(" [PBESTTEN]=@PBESTTEN,"); sb.Append(" [PBESTTTWN]=@PBESTTTWN,"); sb.Append(" [PBESTUS]=@PBESTUS,"); sb.Append(" [PBESTOI]=@PBESTOI"); sb.Append(" where [PBESTTC]=@PBESTTC"); sb.Append(" select @PBESTTC"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsUpDate).ToString(); } }