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();
}
}
