public int LoadRoomDesignerKJLRelatioByDesignID(RoomDesignerKJLRelation obj)
{
string sql = @"SELECT [ID]
, [DesignerNo]
, [KJLDesignID]
, [Status]
, [Created]
, [CreatedBy]
FROM [BE_RoomDesignerKJLRelation] WHERE [KJLDesignID]=@KJLDesignID OR [DesignerNo]=@DesignerNo" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pKJLDesignID = new SqlParameter("KJLDesignID", obj.KJLDesignID);
pKJLDesignID.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pKJLDesignID);
SqlParameter pDesignerNo = new SqlParameter("DesignerNo", obj.DesignerNo);
pDesignerNo.SqlDbType = SqlDbType.BigInt;
cmd.Parameters.Add(pDesignerNo);
int ret = 0;
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
if (!Convert.IsDBNull(dr["ID"]))
{
obj.ID = (Guid)dr["ID"];
}
if (!Convert.IsDBNull(dr["DesignerNo"]))
{
obj.DesignerNo = Convert.ToInt32(dr["DesignerNo"]);
}
if (!Convert.IsDBNull(dr["KJLDesignID"]))
{
obj.KJLDesignID = dr["KJLDesignID"].ToString();
}
if (!Convert.IsDBNull(dr["Status"]))
{
obj.Status = (bool)dr["Status"];
}
if (!Convert.IsDBNull(dr["Created"]))
{
obj.Created = (DateTime)dr["Created"];
}
obj.CreatedBy = dr["CreatedBy"].ToString();
ret += 1;
}
}
finally
{
dr.Close();
}
return(ret);
}
public int InsertRoomDesignerKJLRelation(RoomDesignerKJLRelation obj)
{
string sql = @"INSERT INTO[BE_RoomDesignerKJLRelation]([ID]
, [DesignerNo]
, [KJLDesignID]
, [Status]
, [Created]
, [CreatedBy]
) VALUES(@ID
, @DesignerNo
, @KJLDesignID
, @Status
, @Created
, @CreatedBy
)" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pID = new SqlParameter("ID", Convert2DBnull(obj.ID));
pID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pID);
SqlParameter pDesignerNo = new SqlParameter("DesignerNo", Convert2DBnull(obj.DesignerNo));
pDesignerNo.SqlDbType = SqlDbType.BigInt;
cmd.Parameters.Add(pDesignerNo);
SqlParameter pKJLDesignID = new SqlParameter("KJLDesignID", Convert2DBnull(obj.KJLDesignID));
pKJLDesignID.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pKJLDesignID);
SqlParameter pStatus = new SqlParameter("Status", Convert2DBnull(obj.Status));
pStatus.SqlDbType = SqlDbType.Bit;
cmd.Parameters.Add(pStatus);
SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created));
pCreated.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pCreated);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy));
pCreatedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCreatedBy);
return(cmd.ExecuteNonQuery());
}
public int UpdateRoomDesignerKJLRelationByDesignID(RoomDesignerKJLRelation obj)
{
string sql = @"UPDATE [BE_RoomDesignerKJLRelation] SET [DesignerNo]=@DesignerNo
WHERE [KJLDesignID]=@KJLDesignID" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pDesignerNo = new SqlParameter("DesignerNo", Convert2DBnull(obj.DesignerNo));
pDesignerNo.SqlDbType = SqlDbType.BigInt;
cmd.Parameters.Add(pDesignerNo);
SqlParameter pKJLDesignID = new SqlParameter("KJLDesignID", Convert2DBnull(obj.KJLDesignID));
pKJLDesignID.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pKJLDesignID);
return(cmd.ExecuteNonQuery());
}